how can i connet the sql on c# and using the command of Adapter : private void button2_Click(object sender, EventArgs e)
        {
            
           
            OleDbConnection cnn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\bbbde\Database2.mdb");
            cnn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\bbbde\Database2.mdb";
            OleDbDataAdapter da = new OleDbDataAdapter("select count(*) Form nameList where  name='" + textBox1.Text + "'and password ='" + textBox2 + "'", cnn);
            DataTable dt = new DataTable();
            da.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {

                this.Hide();
                Form2 frm = new Form2();
                frm.Show();
            }
and there is a error that System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'count(*) Form nameList where  name=''and password ='System.Windows.Forms.TextBox, Text: ''.'
