Excel导入数据库时把标题也导入了,怎么解决?另外可不可以把标题写入到对应的列?如:
foreach (DataRow myRow in myDataSet.Tables[0].Rows)
{
string SuitType = myRow[0].ToString(); 改成string SuitType = myRow["标题名"].ToString();
string PointType = myRow[1].ToString();
string Result = myRow[2].ToString();
string PointNum = myRow[3].ToString();
string Flow = myRow[4].ToString();
string ChildFlow = myRow[5].ToString();
string FlowEnd = myRow[6].ToString();
}
foreach (DataRow myRow in myDataSet.Tables[0].Rows)
{
string SuitType = myRow[0].ToString(); 改成string SuitType = myRow["标题名"].ToString();
string PointType = myRow[1].ToString();
string Result = myRow[2].ToString();
string PointNum = myRow[3].ToString();
string Flow = myRow[4].ToString();
string ChildFlow = myRow[5].ToString();
string FlowEnd = myRow[6].ToString();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货