UC知道用vb连接sql进行查询操作怎样让datagrid只显示查询后的记录而不是全部记录
来源：百度知道 编辑：UC知道 时间：2024/06/19 23:42:17
这是编码
Dim a As String
a = Text2(5).Text
Adodc1.RecordSource = " select * from guest where 姓名= '" & a & "' "
DataGrid1.Refresh
Set DataGrid1.DataSource = Adodc1
为何还没输入姓名就sql表全部输出了
Dim a As String
a = Text2(5).Text
Adodc1.RecordSource = " select * from guest where 姓名= '" & a & "' "
DataGrid1.Refresh
Set DataGrid1.DataSource = Adodc1
为何还没输入姓名就sql表全部输出了
把语句改成这样试试
Dim a As String
a = Text2(5).Text
Private Sub Command1_Click()
Adodc1.RecordSource = " select * from guest where 姓名= '" & a & "' "
DataGrid1.Refresh
Set DataGrid1.DataSource = Adodc1
End Sub