| 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
|