| Author: gomathinayagam 15 Oct 2008 | Member Level: Gold | Rating:  Points: 2 |
sqlcommand cmd ="select * from table where mobileno='" + textbox.text;
SqlDataAdapter oda = new SqlDataAdapter(cmd);
cmd.connection = new sqlconnection("connection string");
cmd.open();
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count > 0)
{
// authorized
}
else
{
//not authorized
}
Gomathi Nayagam
Please Rate my answer if it has helpful to you
|