調試asp.net客戶机如何連接服器中的SQL數據庫?

[nnh]

最近要取得服務器中的SQL數据(服務器IP:192.168.1.1),請問客戶机如何才能連上服務器,並取得它的數據?

請給出完整的代碼,謝謝.

[dayasky]

Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter

MyConnection = New SqlConnection("server=192.168.1.1;database=pubs;User=sa;pwd=你的密码")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)

DS = new DataSet()
MyCommand.Fill(ds, "Authors")

MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()

[dayasky]

C#的:
SqlConnection myConnection = new SqlConnection("server=192.168.1.1;database=pubs;User=sa;pwd=你的密码");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");

MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();