Validate Textbox value with Databse

Question

Hi I have one Textbox. In that textbox I have entered sometext. Now my question is how to check that textbox's value to my database which I have created in Access on Button_Click event?

Krishna Garad · Answer

Try this Public Bool CheckValue(string _value) { string _Sql=Select From Where ='+_value+'; SqlConnection cn=new SqlConnection(Connectionstring); SqlCommand sqlcmd = new SqlCommand(_Sql cn); SqlDataReader sqldr = sqlcmd.ExecuteReader(); if (sqldr.HasRows) return true; else return false; } May help you.

Sahil Jani · Answer

Hi Ankit Thanks for your reply I have tried your code first but I am getting some exception. After that I have tried the code given by Krishna that is working fine in my project. Once again thanks for the reply.

Krishna Garad · Answer

ok fine just replace Sql with oledbconnection and oledbcommand as well oledbdatareader objects.

Sahil Jani · Answer

Hi Krishna Thanks for the reply but I have mentioned in my post that my database which I have created in Access not in SQL.

Ankit Nandekar · Answer

use this query select * from tablename where studname='+txtstudname.Text+' with the use of this query store data in datasetand count rows of dataset like if(ds.Tables[0].Rows.Count >0) { condition true then value is present inside database } else { value not present in database. }