老子不活了,分都用了,没了
问两个问题,1
string source = "pcdb.mdb";
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "select ryzl.工号,ryzl.姓名, ryzl.养老金 + ryzl.医疗金 + ryzl.失业金 as 三金 from ryzl";
OleDbConnection olecon = new OleDbConnection(conn);
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon);
DataSet ds = new DataSet();
sda.Fill(ds, "ryzl");
DataTable dt = new DataTable();
dt = ds.Tables["ryzl"];
string sql1 = "select * from sqxm";
OleDbConnection olecon1 = new OleDbConnection(conn);
OleDbDataAdapter sda1 = new OleDbDataAdapter(sql1, olecon1);
DataSet ds1 = new DataSet();
sda1.Fill(ds1, "sqxm");
DataTable dt1 = ds1.Tables["sqxm"];
foreach (DataRow dr1 in dt1.Rows)
{
dt.Columns.Add(new DataColumn(dr1["money"].ToString()));
我想在这把列的值都还成dr1["price"].ToString()));请问该如何实现呢
}
dataGridView1.DataSource = ds.Tables[0];
2,是我的datagirdview绑定了数据表A,显示在窗体中,我想让它是可编辑状态,可以添加记录,然后点击更新按钮后,
datagirdview自己刷新数据,数据表中的数据要背刷新,请问该如何去做?