fdaliry
یک شنبه 25 بهمن 1388, 22:24 عصر
سلام کد زیر را نوشتم تا با هر بار اجرا شدن یک واحد به متغییر داخل دیتابیس اضافه کنه
ولی جواب نمیده
ممنون میشم بگید ایرادش کجاست
string d3;
OleDbConnection con3;
OleDbDataAdapter adap3;
DataSet ds3 = new DataSet();
con3 = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + Application.StartupPath + "\\db.mdb");
d3 = "select * from countsh where(sal='" + textBox2.Text + "')";
adap3 = new OleDbDataAdapter(d3, con3);
adap3.Fill(ds3, "countsh");
long count = int.Parse(ds3.Tables[0].Rows[0]["count"].ToString());
count++;
con3.Close();
OleDbConnection con = new OleDbConnection();
string cmdstr;
OleDbCommand cmdoledb = new OleDbCommand();
con.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + Application.StartupPath + "\\db.mdb";
con.Open();
cmdstr = "Update countsh Set count='" + count + "'Where sal="+ textBox2.Text +"";
cmdoledb.Connection = con;
cmdoledb.CommandText = cmdstr;
cmdoledb.ExecuteNonQuery();
con.Close();
ولی جواب نمیده
ممنون میشم بگید ایرادش کجاست
string d3;
OleDbConnection con3;
OleDbDataAdapter adap3;
DataSet ds3 = new DataSet();
con3 = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + Application.StartupPath + "\\db.mdb");
d3 = "select * from countsh where(sal='" + textBox2.Text + "')";
adap3 = new OleDbDataAdapter(d3, con3);
adap3.Fill(ds3, "countsh");
long count = int.Parse(ds3.Tables[0].Rows[0]["count"].ToString());
count++;
con3.Close();
OleDbConnection con = new OleDbConnection();
string cmdstr;
OleDbCommand cmdoledb = new OleDbCommand();
con.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + Application.StartupPath + "\\db.mdb";
con.Open();
cmdstr = "Update countsh Set count='" + count + "'Where sal="+ textBox2.Text +"";
cmdoledb.Connection = con;
cmdoledb.CommandText = cmdstr;
cmdoledb.ExecuteNonQuery();
con.Close();