我用的是vs2005!
Dim cnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\VB小程序\幼儿园管理系统\信息.mdb"
Dim cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(cnStr)
Dim da As OleDb.OleDbDataAdapter
cn.Open()
Dim sql As String
sql = "select count(*) from 签到 where 编号='1'"
只会写到这了。。。这应该是查询了吧?如何获取查询后的返回值?我想用查询出来的相同编号的数据的条数这个值来进行下一步运算。求解如何写?
------解决方案--------------------
OleDbConnection conn = new OleDbConnection(con);
DataTable dt = new DataTable();
sql = "select count(*) from 签到 where 编号='1'"
dtAdapter = new OleDbDataAdapter(sql, conn);
conn.Open();
dtAdapter.Fill(dt);
i= dt.Rows.Count