How to check if value exist in database

Question

I have a value let's say it's 3243; and my database table name is mytable and the column I'll look into is mycolumn. I want to check if this value exist in that column. I do have a dataset and I tried the following code : DataTable table = dsEditData.Tables[mytable]; DataRow[] row; row = table.Select(mycolumn = '3243'); MessageBox.Show(row[0][0].ToString()); but this code gives me the error There is no row at position 0. Database table is not empty and I'm %100 sure that the row I'm looking for exist. I've never used these codes. So it might be totally wrong. I want to know if I need to correct my code or if there is any other way to do what I want to do.

theLizard · Answer

yes amit but you can make it simpler public bool getDuplicateValue(string table string field string value) { sqlCon con = new sqlCon(); //the connection class string s = SELECT Count(*) FROM  + table +  WHERE  + field +  = @value; //how to add parameters cmd.Parameters.AddWithValue(value value); return(( con.cmd.ExecuteScalar() }

Amit Choudhary · Answer

hi friend There is more easy way to do this if you want to check the value directly in database: public bool isValueExist(string table string field string value) { int result=0; // Create connection here SqlConnection conn=new SqlConncetion( ); string s = SELECT Count(*) FROM  + table +  WHERE  + field +  = @value; //how to add parameters cmd.Parameters.AddWithValue(value value); result=cmd.ExecuteScalar(); if(result return false; else return true; } Please mark as answer if it helps you. if any other issue then please let me know

theLizard · Answer

from code n a post to Georgio here //-------------------------------------------------------------- public bool getDuplicateValue(string table string field string value) { bool found = false; string s = SELECT * FROM  + table +  WHERE  + field +  = @value; sqlCon con = new sqlCon(); //how to add parameters con.cmd.Parameters.AddWithValue(value value); try { con.connect(); con.command(s); con.ExecuteReader(); if (con.read()) { found = true; } } catch (Exception err) { } finally { con.terminate(); } return (found); }