讓ASP.NET也可以如PHP一樣include

　　一般在寫ASP.NET時,總是會有一些部份的功能是要自己寫的,如果是要連DataBase那就要定義一些sqlconnection之類的東西,如果有很多的Page都要用到,那麼就會有一堆一樣的東西,若那天要移到別台SERVER或PC上時,一定又是一頁一頁的改,若把那些東西都寫在某一個File中,要用的時候在"建立"(new),並且引用,這樣一來不是方便多了!

先建立一個"類別"
For VB

Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient

Public Class Class1
    Public str As String = "Data Source=CUTE;Initial Catalog=C:\INETPUB\WWWROOT\PRACTICE\APP_DATA\STUDY.MDF;Integrated Security=True"
    Public sqlcon As SqlConnection = New SqlConnection(str)
    Public strsql As String
    Public cmd As SqlCommand

End Class

For C#

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// 

/// Class1 的摘要描述
/// 
public class Class1
{
    public OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\questionary\\App_Data\\qu_an.mdb");
    public OleDbCommand cmd;
    public OleDbDataReader dr;
    public void constr()
    {

    }
}