问题与数据库有关

本文介绍了问题与数据库有关的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

如何在数据库中检查单行是否存在c＃ms access

how we can check single row exist or not in database in c# ms access

推荐答案

qry = "select * from department_master where dep_code='" + txt.Text + "'";
sql_cmd = new SqlCommand(qry, sql_con);
sql_con.Open();
sql_rs = sql_cmd.ExecuteReader();
if (sql_rs.Read())
{
    //exists
}
else
{
    //not exists
}
sql_rs.Close();
sql_con.Close();

OleDbConnection cn;
OleDbCommand cmd2;
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" your dbpath herer ";Jet OLEDB:");
cn.Open();
OleDbDataAdapter objDA = new OleDbDataAdapter("select * from Users where UserId='007'", cn);
DataTable objDT = new DataTable();
objDA.Fill(objDT);
if ((objDT.Rows.Count == 1)) {
    // database have row
}

以上代码从表中选择精确数据，这里用户是表，但是你想要数据库有没有数据

试试这样

the above code for select exact data from table,here users is table,but u want database have data or not
try like this

OleDbConnection cn;
OleDbCommand cmd2;
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" your dbpath herer ";Jet OLEDB:");
cn.Open();
OleDbDataAdapter objDA = new OleDbDataAdapter("select * from Users", cn);
DataTable objDT = new DataTable();
objDA.Fill(objDT);
if ((objDT.Rows.Count == 1)) {
    // database have row
}

问候

Aravind

Regards
Aravind

这篇关于问题与数据库有关的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！