求大神 在线等 vb.net连接access 查找数据库中是否有id号相同的数据
如题。现在在添加之前想要做个if else 查看是否有与textbox1.text中ID号相同的数据。（注 加入包括三个元素 id name age） id号不相同即可。
我的思路是dim strFind string= select countt(*) from student where id='" &textbox1.text&"'
问题是 如何判断这条sql语句的执行结果。请大神告诉我下

[解决办法]

VB.NET code

 Function getDataset(ByVal sql As String) As DataSet        Dim connstr As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=|DataDirectory|\data.mdb"        Dim conn As OleDbConnection = New OleDbConnection(connstr)              '("provider=microsoft.Jet.OLEDB.4.0;data source=" & CurDir() & "\data.mdb")        Dim adapter1 As OleDb.OleDbDataAdapter = New OleDbDataAdapter(sql, conn)        Dim cmd As OleDbCommand = New OleDbCommand        getDataset = New DataSet        adapter1.Fill(getDataset, "temp")End FunctionMyDs1 = New DataSetMyDs1 = getDataset("select * from stock where [列名] like '" & textbox1.text & "' ）        If MyDs1.Tables("temp").Rows.Count = 1 Then  ...................your code