NURU DAWUD

NURU DAWUD

  • 1.4k
  • 349
  • 16.4k

In c# windows form Update anddcommand for access database not working

Mar 29 2022 12:09 PM

Please Help Friends,

namespace VERS
{
     public   class ConnectionClass
     {
        public OleDbConnection conn;
        public OleDbCommand cmd;
        private OleDbDataAdapter da;
        private DataTable dt;
        public OleDbDataReader d2;
        public DataSet DataSet;
        public string path ;
        public void Myoledbconnection()
        {
            LoginForm l = new LoginForm();
            conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\1\VERS\versdb.accdb ");
            conn.Open();
        }
        
        public void oledbquery(string quertext)
        {
            Myoledbconnection();
            cmd = new OleDbCommand(quertext, conn);
        }
        public DataTable queryex()
        {
            da = new OleDbDataAdapter(cmd);
            dt = new DataTable();

            da.Fill(dt);            
            return dt;
        }

        public void nonqueryex()
        {
            cmd.ExecuteNonQuery();
            conn.Close();
        }
     }
}

But

1) Update for the following code is not working

private void BtnUpdate_Click(object sender, EventArgs e)
{
    if (txtUserName.Text != "" && txtPassword.Text != "")
    {
        con = new ConnectionClass();
        con.oledbquery("update tbluser set id=@id,userlogin = @userName,password = @password where id = @id");
        con.cmd.Parameters.AddWithValue("@id", textBox1.Text.ToString());
        con.cmd.Parameters.AddWithValue("@userName", txtUserName.Text.ToString());
        con.cmd.Parameters.AddWithValue("@password", txtPassword.Text.ToString());
        con.nonqueryex();
        MessageBox.Show("Record Updated Successfully");
        DisplayData();
        ClearData();
    }
    else
    {
        MessageBox.Show("Please Select Record to Update");
    }
}

2) count for the following code is display Nothing when I add  year between  TextBox1.Text  and  TextBox2.Text

con = new ConnectionClass();
con.Myoledbconnection();
//current
con.oledbquery("SELECT COUNT([sex])  FROM [birth table] where calculate >=0 and calculate <=90 and [palce 111] ='city' and [sex] ='male' and  year between  TextBox1.Text  and  TextBox2.Text ");
Int32 count_1 = (Int32)con.cmd.ExecuteScalar();

Answers (1)