string Username, tSex, tInClass, tQuestion, tAnswer;
Username = ds.Tables["[Sheet1$]"].Rows[i]["3,4"].ToString();
tSex = ds.Tables["[Sheet1$]"].Rows[i]["性别"].ToString();
tInClass = ds.Tables["[Sheet1$]"].Rows[i]["部门"].ToString();
tQuestion = ds.Tables["[Sheet1$]"].Rows[i]["编号"].ToString();
tAnswer = ds.Tables["[Sheet1$]"].Rows[i]["初始密码"].ToString();
string excelsql = "insert into tb_Users(RealName, Sex, InClass,Question,Answer) values ('" + Username + "','" + tSex + "','" + tInClass + "','" + tQuestion + "','" + tAnswer + "')";
try
然后我把姓名改成数字还是提示3,4不属于表[Sheet1$]
求解。
Username = ds.Tables["[Sheet1$]"].Rows[i]["3,4"].ToString();
tSex = ds.Tables["[Sheet1$]"].Rows[i]["性别"].ToString();
tInClass = ds.Tables["[Sheet1$]"].Rows[i]["部门"].ToString();
tQuestion = ds.Tables["[Sheet1$]"].Rows[i]["编号"].ToString();
tAnswer = ds.Tables["[Sheet1$]"].Rows[i]["初始密码"].ToString();
string excelsql = "insert into tb_Users(RealName, Sex, InClass,Question,Answer) values ('" + Username + "','" + tSex + "','" + tInClass + "','" + tQuestion + "','" + tAnswer + "')";
try
然后我把姓名改成数字还是提示3,4不属于表[Sheet1$]
求解。
姓 名 杨
于
单
张
欧
宋