c# - Login error based on SQL server

Question

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";
        }

Answer 1

can you try this !

SqlDataAdapter adp = new SqlDataAdapter();
DataSet ds = new DataSet();
adp.SelectCommand = new SqlCommand("Your SQL Statement Here", con);
adp.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count  > 0)
{
    settext = textBox1.Text;
    Admin_Main_Page AdminMainForm = new Admin_Main_Page();
    AdminMainForm.Show();
    this.Hide();
}
else{
   label4.Text = "Invalid Login Details";
}