Login by backend table data... This code shows how to login using backend table data
private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = "data source = JBB-690AB60E108;,Initial catalog = True; Integrated Security = True"; con.Open(); SqlCommand cmd = new SqlCommand("select username,pass from loge where username=@UserName and pass=@password ", con); cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 10); cmd.Parameters.Add("@password", SqlDbType.VarChar, 15); cmd.Parameters["@UserName"].Value = textBox1.Text; cmd.Parameters["@password"].Value = textBox2.Text; if ((cmd.ExecuteReader().HasRows)) { MessageBox.Show("Welcome"); } else { MessageBox.Show("Check the UserName or Password", "Incorrect Entry", MessageBoxButtons.RetryCancel, MessageBoxIcon.Exclamation); } } } }
Thanks Nikhil
For more details, visit www.dotnetask.blog.co.in
|
| Author: pankaj gupta 15 Nov 2009 | Member Level: Silver Points : 0 |
Thank you for this code. This is really working.
|