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();


        if (dt.Rows[0][0].ToString() == "1")
            mainLoginform mlf = new mainLoginform();
            MessageBox.Show(" Please check your user name and password");

0 answers