how to compare value from table with textbox value

Question

Hi Experts...I need to compare username field from the table with the textbox value using datareader...Please tell me code...Thanks in advance

Soft Corner · Answer

Hi Try this Code : SqlConnection con = new SqlConnection(Data Source=.\SQLEXPRESS;Initial Catalog=DBNAME;Integrated Security=true;); SqlDataReader dr; SqlCommand cmd; try { con.Open(); string qry =select * from table where username ='+textbox1.Text+'; cmd = SqlCommand(qrycon); dr = cmd.ExecuteReader(); while(dr.read()) { //do something MessageBox.Show(UserName:+dr.GetString(0)); } dr.Close(); con.Close(); } catch(Exception ex) { MessageBox.Show(ex.message); } finally { con.Close(); }

Abhimanyu K Vatsa · Answer

i think you are wishing to search out the record when user type in textbox and clicks button isn't it? if so then read a article which let u find record from database read this