Ad:

C# Discussion Thread
Unsolved
Views: 4213

Oct 22nd, 2009

How to check if an ID exist in database

Expand Post »

Im doing an application n c# and using Ms Access 2003. i want to check whether a product id already exist in the database. Below is part of my code

C# Syntax (Toggle Plain Text)
string sql;
            OleDbCommand cmd;
            OleDbDataReader rdr;
 
 
            mDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Path.Combine(Application.StartupPath, "..\\..\\Company.mdb");
            mDB.Open();
            sql = "Select COUNT (*) ProductID FROM Product";
 
 
 
            cmd = new OleDbCommand(sql, mDB);
 
            rdr = cmd.ExecuteReader();
            if (txtProductID.Text == (string)rdr["ProductID"] )
            {
 
                MessageBox.Show("ID exixst");
 
            }
            else
            {
                return;
 
            }
string sql;
            OleDbCommand cmd;
            OleDbDataReader rdr;
           

            mDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Path.Combine(Application.StartupPath, "..\\..\\Company.mdb");
            mDB.Open();
            sql = "Select COUNT (*) ProductID FROM Product";



            cmd = new OleDbCommand(sql, mDB);

            rdr = cmd.ExecuteReader();
            if (txtProductID.Text == (string)rdr["ProductID"] )
            {

                MessageBox.Show("ID exixst");

            }
            else
            {
                return;

            }

Similar Threads

VB-MySQL Check if exist then insert in VB.NET
Check if user exists in db? in PHP
How to determine the availability of database file in Visual Basic 4 / 5 / 6
Check and Repair MySQL Database in MySQL
How to check my database in Visual Basic 4 / 5 / 6

sara455

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2009

Permalink

Oct 22nd, 2009

Re: How to check if an ID exist in database

Hi!

One possibility is, that you do an other sql-statement where you try to select the desired ProduktID:

C# Syntax (Toggle Plain Text)
string sqlString = "Select ProductID FROM Product where ProductID="+txtProductID.Text;
OleDbCommand dbCmd = new OleDbCommand(sqlString, mDB);
mDB.Open();
OleDbDataReader reader = dbCmd.ExecuteReader();
if (reader.Read())
{
	MessageBox.Show("ID exixst");
}
else
{
  // do something else here
}
string sqlString = "Select ProductID FROM Product where ProductID="+txtProductID.Text;
OleDbCommand dbCmd = new OleDbCommand(sqlString, mDB);
mDB.Open();
OleDbDataReader reader = dbCmd.ExecuteReader();
if (reader.Read())
{
	MessageBox.Show("ID exixst");
}
else
{
  // do something else here
}

I have not tested the code, but i think this should work!

Daniel

DanielGreen

Reputation Points: 16

Solved Threads: 4

Light Poster

Offline

28 posts
since Oct 2009

Permalink

Oct 12th, 2011

Re: How to check if an ID exist in database

Click to Expand / Collapse Quote originally posted by DanielGreen ...

Hi!

One possibility is, that you do an other sql-statement where you try to select the desired ProduktID:
C# Syntax (Toggle Plain Text)
string sqlString = "Select ProductID FROM Product where ProductID="+txtProductID.Text;
OleDbCommand dbCmd = new OleDbCommand(sqlString, mDB);
mDB.Open();
OleDbDataReader reader = dbCmd.ExecuteReader();
if (reader.Read())
{
	MessageBox.Show("ID exixst");
}
else
{
  // do something else here
}
string sqlString = "Select ProductID FROM Product where ProductID="+txtProductID.Text; OleDbCommand dbCmd = new OleDbCommand(sqlString, mDB); mDB.Open(); OleDbDataReader reader = dbCmd.ExecuteReader(); if (reader.Read()) { MessageBox.Show("ID exixst"); } else { // do something else here }
I have not tested the code, but i think this should work!

Daniel

ohh! great! Daniel green. thx!
Is easy code but serves

Hacoga

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2011

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: What happens if you inherit multiple interfaces and they have conflicting method name

Next Thread in C# Forum Timeline: Click event on a 3D object

DaniWeb Message

Cancel Changes

User Name
Password