[RESOLVED] [2.0] this is a really simple question

[r0k3t]

And I should know it but I don't...

What is the simplest way to check for the existence of a value in a database. Like I wanna know if studyIdNumber FF12033 already has been inserted. I have like 14 lines of code to do it. There has to be a better way.

Thanks

[Harsh Gupta]

//your SqlConnection here, name it conn

//SqlCommand
Sqlcommand cmd = new SqlCommand();
cmd.CommandText = "Select Count(studyIdNumber) from table_name WHERE studyIdNumber='FF12033'";

cmd.Connection = conn;

conn.Open();

int num_of_instance = cmd.ExecuteScalar();

conn.Close();

if (num_of_instance == 1)
{
//Item already inserted
}
else
{
//Insert new Item
}
Hope it helps!!

[r0k3t]

Wowser... As soon as you posted that I realized I had done that before. what can I say? It is the day after the fourth.

Thanks!