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 dataset,and 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. }

Validate Textbox value with Databse

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)