my question is create login page.
in my datyabase i have username and password fields.
in login form i have two textboxs txtun and txtpwd and button
now i want to redirect to another page if correct username,password is given or it have to show msg incorrect password
i wrote some extent afterwards iam not getting
cmd=new SqlCommand("select username='" + TextBox1.Text + "',password='" + TextBox2.Text + "' from login",con);