SqlDataAdapter returns empty even though there is correct data in the DataBase.
I am new to c# web DB programing . I have tried to write a registration form .
Here the DB connection part:
The remarks part are my tries to make it work (which did not) .
The problem is that dt stays empty even though there is corrrect data in loginTable table.
Wouls you help me understand and solve the problem?
private void loginBotton_Click(object sender, EventArgs e)
{
// Integrated Security = true;
// User Instance = true;
// sp_configure 'user instances enabled','1';
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\SARAH\Documents\loginData.mdf;Integrated Security=True;Connect Timeout=30");
// SqlDataAdapter sda = new SqlDataAdapter( "select count(*) from loginTable where userName=' "+ userNameTextBox.Text + "' and passwrd ='"+ passwrdTextBox.Text+"'", con );
SqlDataAdapter sda = new SqlDataAdapter("select ( * ) from loginTable", con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
mainLoginform mlf = new mainLoginform();
mlf.Show();
}
else
{
MessageBox.Show(" Please check your user name and password");
}
}