如何检查是否记录存在与否和MS Access数据库在C＃中插入 [英] How to check if record exists or not and insert in ms access database in c#

问题描述

我要检查，如果记录存在与否，如果它存在，我不想插入如果我BOT要插入在MS Access数据库中的数据在C＃。

I want to check if record exists or not if it exists i dont want to insert if it bot i want to insert the data in ms access database in c#.

        OleDbCommand cmd = new OleDbCommand("insert into MyTable values('" + test + "','" + test + "','" + "123" + "');", con);
        OleDbCommand cmd1 = new OleDbCommand("select * from MyTable", con);
        temp = 0;
        try
        {
            con.Open();
            string count = (string)cmd1.ExecuteScalar();
            temp = cmd.ExecuteNonQuery();
            if (temp > 0)
            {
                MessageBox.Show("One Record Added");
            }
            else
            {
                MessageBox.Show("Record not added");
            }


        }
        catch
        { }

任何人都可以建议我一些代码。

Can Anyone suggest me some code.

先谢谢了。

推荐答案

过滤一些关键的基础上，你的SELECT查询。检查是否返回的存在或特定的记录不存在，做所需的处理。

Filter your Select query on the basis of some key . Check if it returns for existence or non-existence of the particular record and do the processing required .

 string cmdStr = "Select count(*) from MyTable where id = 1"; //get the existence of the record as count 

 OleDbCommand cmd = new OleDbCommand(cmdStr, conn);

  int count = (int)cmd.ExecuteScalar();

  if(count >0)
  {
         //record already exist 
  }

修改此行

  OleDbCommand cmd1 = new OleDbCommand("select * from MyTable", con);

这篇关于如何检查是否记录存在与否和MS Access数据库在C＃中插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！