如何在vb.net中调用SQL Server数据库?
Public Sub CreateCommand(ByVal queryString As String, _
ByVal connectionString As String)
Using connection As New SqlConnection(connectionString)
Dim command As New SqlCommand(queryString, connection)
command。 Connection。Open()
Dim reader As SqlDataReader = command。ExecuteReader()
While reader。 ...全部
Public Sub CreateCommand(ByVal queryString As String, _
ByVal connectionString As String)
Using connection As New SqlConnection(connectionString)
Dim command As New SqlCommand(queryString, connection)
command。
Connection。Open()
Dim reader As SqlDataReader = command。ExecuteReader()
While reader。
Read()
Console。WriteLine("{0}", reader(0))
End While
End Using
End Sub
queryString就是你的查询泽肤串,例如 select * from 表名。
While reader。Read()
Console。WriteLine("{0}", reader(0))
End While
这个部分你可能需要替换成和datagridview绑定的代码。
以上代码在。dotnet带的msdn帮助中都可以查到。收起