关于dataGridView控件的问题,请教一下各位大神。
我用vb.net做了一个软件用的是datagridview控件然后该软件到其他的电脑上连接不上我的数据库。
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn = New SqlConnection(ConnectionString)
If conn.State = ConnectionState.Open Then
conn.Close()
End If
ConnectionString = "Data Source=HUKAIYI-PC\SQLEXPRESS12;Initial Catalog=hxxhp;User Id=sa;Password=hukaiyi123"
conn.ConnectionString = ConnectionString
conn.Open()
Dim da As New SqlDataAdapter("SELECT * FROM [hxxhp].[dbo].[hxxhpylb] where [代码] = '" & TextBox1.Text & "'", conn)
Dim ds As New DataSet("hxxhpylb")
da.Fill(ds, "hxxhpylb")
DataGridView1.DataSource = ds.Tables("hxxhpylb").DefaultView
End Sub
这是我连接数据库的代码