在vb。net中查询和访问SQL SERVER数据库的格式是什么样的?在下面的程序中我访问SQL SERVER数据库上不去啊?请高手执教,回内部信箱。其中dgrid1是datagrid控件。关键我想明白的是第二个语句的格式是不是正确啊。访问SQL SERVER的格式请执教。很着急的。
Dim con1 As OleDb.OleDbConnection
Dim strConnect As String = "Provider=SQLOLEDB;Persist Security Info=False;Data Source=sunhongtao1;Initial Catalog=sql server;User ID=sa;Password=sa;"
con1 = New System.Data.OleDb.OleDbConnection(strConnect)
con1.Open()
Dim oledp As New OleDb.OleDbDataAdapter("select * from analogtag", con1)
oledp.Fill(ds, "hui1")
dgrid1.DataSource = ds11.Tables("hui1")
con1.Close()
--
FROM 218.244.54.*