Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim aa As DataTable
Dim sqlConnection1 As SqlClient.SqlConnection
Dim strConnect As String = "Data source=localhost;Initial Catalog=111;"
sqlConnection1 = New System.Data.SqlClient.SqlConnection(strConnect)
sqlConnection1.Open()
Dim mycomand As New SqlCommand
mycomand = New SqlClient.SqlCommand("select tx from 222", sqlConnection1)
Dim sqlda As SqlDataAdapter
sqlda.Fill(aa)
这是我连接数据库的部分，不过运行时，总是提示系统错误，大家能不能帮我修改一下

Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim aa As DataTable
Dim sqlConnection1 As SqlClient.SqlConnection
Dim strConnect As String = "Data source=localhost;Initial Catalog=111;"
sqlConnection1 = New System.Data.SqlClient.SqlConnection(strConnect)
sqlConnection1.Open()
Dim mycomand As New SqlCommand
mycomand = New SqlClient.SqlCommand("select tx from 222", sqlConnection1)
Dim sqlda As SqlDataAdapter
sqlda.Fill(aa)


Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim aa As new dataset
Dim sqlConnection1 As SqlClient.SqlConnection
Dim strConnect As String = "Data source=localhost;Initial Catalog=111;uid=帐号;pwd=密码"
sqlConnection1 = New System.Data.SqlClient.SqlConnection(strConnect)
sqlConnection1.Open()
Dim mycomand As New SqlCommand
mycomand = New SqlClient.SqlCommand("select tx from 222", sqlConnection1)
Dim sqlda As SqlDataAdapter
sqlda.Fill(aa)

那我要求这个字段一共有多少行，该怎么求啊？

我已经完全按照你那个写，不过它还是出现问题(未处理的“system。data。sqlclient。sqlecception”类型的异常出现在system.data.dll中.
系统错误.) sqlConnection1.Open()

Imports System.data.sqlclient

dim conStr As New SqlClient.SqlConnection("data source=.;database=数据库名字;integrated security=true;")
dim ds As New DataSet
dim command as new sqlcommand("select * from 表名",constr)
Dim da As New SqlDataAdapter("select * from 表名", conStr)
da.fill(ds,"bb")
DataGrid1.SetDataBinding(ds, "bb")

看这样行不

select count(字段名) from 表名

我现在最重要的问题是我的数据库打不开
总是提示系统错误

uid=帐号;pwd=密码，你是不是就这么写的？！

我没有写帐号和密码
我用的是WINDOWS集成安全

算了不用写代码了,
用连接向导 可视化操作了

一般都是 SA 跟系统安全集成 混合