自定义列的问题

自定义列的问题 [无满意答案结贴,结贴人:chaye12]

chaye12
等级:

发表于：2008-07-05 11:04:04 楼主

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"];
DataRow dr;
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()的值赋给上面的这行自定义列请问该如何解决呢！
}

问题点数：15 回复次数：2 修改删除举报引用回复