datagrid无法找到表0问题,各位帮我看看!
datagrid无法找到表0问题,各位帮我看看!代码:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sqlstr As String
sqlstr = "select * from lp where'" & TextBox1.Text & Label6.Text & TextBox2.Text & Label7.Text & TextBox3.Text & "'"
If TextBox1.Text = TextBox2.Text = TextBox3.Text = "" Then
msgbox("请输入数据!",MsgBoxStyle.OKOnly)
End If
Dim mydb As New DataSet
mydb.Clear()
Me.DataGrid1.ReadOnly = True
mydb = gddb(sqlstr)
Me.DataGrid1.DataSource = mydb.Tables(0).DefaultView
End Sub
Private Sub Form8_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sqlstr As String
sqlstr = "select * form oddset"
Dim mydb As New DataSet
mydb.Clear()
Me.DataGrid1.ReadOnly = True
mydb = gddb(sqlstr)
Me.DataGrid1.DataSource = mydb.Tables(0).DefaultView
End Sub
有没有比较简单的办法解决查询结果在datagrid里显示?谢谢 --------------------编程问答-------------------- mydb = gddb(sqlstr)
你这一行是通过gddb方法,根据指定的sql语句查询数据库,返回数据到mydb中,所以提示找不到表0,是否这个方法没有返回一个带有数据的数据集?
其实,你可以这样修改看看?
mydb = gddb(sqlstr)
这一句修改为
--------------------编程问答-------------------- 单步跟踪查看sqlstr
Dim sqlDa As SqlDataAdapter
sqlDa=New SqlDataAdapter(sqlstr,sqlConn)'sqlConn是数据库连接对象
sqlDa.Fill(mydb)'这样只要数据库的oddset表有数据,就可以读取数据到数据集中
if(ds!=null&&ds.Tables.Count > 0)
{
} --------------------编程问答-------------------- gddb(string)返回null? --------------------编程问答--------------------
补充:.NET技术 , VB.NET