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

Answer 1

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(qry,con);
  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();
}

Answer 2

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