如何判断ACCESS数据表中的某条记录是否存在

判断 方法为： OleDbConnectioncon=newOleDbConnection(连接字符串); stringname=test; con.Open(); OleDbCommandcmd=newOleDbCommand(selectcount(*)fromstudentDetailswheresname='name',con); intcount=Convert.ToInt32(cmd.ExecuteScalar()); con.Close(

判断方法为：

OleDbConnection con=new OleDbConnection("连接字符串");
string name="test";
con.Open();
OleDbCommand cmd=new OleDbCommand("select count(*) from studentDetails where sname='"+name+"'",con);

int count=Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
if (count>0)
{
//说明记录存在..
}
else
{
//说明记录不存在..
}