在vb.net中连接SQL Server 2000你可以用一个 SqlConnection,连接一下看行不行? Dim nwindConn As SqlClient.SqlConnection = New SqlClient.SqlConnection("data source=QIN;initial catalog=gsales;persist security info=False;user id=sa;password=sa;workstation id=GCC-BC;packet size=4096") Dim selectCMD As SqlClient.SqlCommand = New SqlClient.SqlCommand("SELECT * FROM orders", nwindConn)
selectCMD.CommandTimeout = 30 Dim custDA As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter()
custDA.SelectCommand = selectCMD nwindConn.Open()
Dim custDS As DataSet = New DataSet()
custDA.Fill(custDS)
DataGrid1.DataSource = custDS
nwindConn.Close()
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货