数据逐条插入
DataSet ds = lh.GetExcelData(HiddenField1.Value);
DataTable dt = ds.Tables[0];
string account = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString();
for (int i = 0; i < dt.Rows.Count; i++)
{
string username = dt.Rows[i][0].ToString();
string realname = dt.Rows[i][1].ToString();
string part = dt.Rows[i][2].ToString();
string Amount = dt.Rows[i][3].ToString();
string Remarks = dt.Rows[i][4].ToString();
lh.AddLaborTable(username, realname, part, Amount, Remarks, account);
Response.Write("o了!<br>");
}
lh.GetExcelData是获取dataset的方法,lh.AddLaborTable是添加一条数据的方法。