everytime i key-in the username and password even if it is in the database it says invalid login details. IS the sql code correct? The registration part is correct but when it comes to login there will always be an error
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-CJGIQ74;Initial Catalog=Login;Integrated Security=True");
con.Open();
string newcome = "SELECT Name FROM register WHERE Name='" + textBox1.Text + "'and Password='" + textBox2.Text + "'";
SqlDataAdapter adp = new SqlDataAdapter(newcome, con);
DataSet ds = new DataSet();
adp.Fill(ds);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count>=1)
{
settext = textBox1.Text;
Admin_Main_Page AdminMainForm = new Admin_Main_Page();
AdminMainForm.Show();
this.Hide();
}
else
{
label4.Text = "Invalid Login Details";
}
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…