看了您将Excel数据导入到sqlserver的案例,我的却只能遍历一次Excel而不是把Excel所有行遍历并保存到sqlserver try
{
DataTable dt = xsldata();
for (int i = 0; i < dt.Rows.Count; i++)
{
string Xno = dt.Rows[i][0].ToString();//dt.Rows[i]["Name"].ToString(); "Name"即为Excel中Name列的表头
string Mtime = dt.Rows[i][1].ToString();
DateTime Mdate = Convert.ToDateTime(dt.Rows[i][2]);//Date = {2015/4/9 0:00:00}2015/4/1 0:00:00
string MTab = dt.Rows[i][3].ToString();
string MTitle = dt.Rows[i][4].ToString();
string MRoom = dt.Rows[i][5].ToString();
string MPerson = dt.Rows[i][6].ToString();
string Mhost = dt.Rows[i][7].ToString();
string MType = dt.Rows[i][8].ToString();
MeetInfo m = new MeetInfo();
m.meettime = Mtime;
m.meetdate = Mdate;
m.timeab = MTab;
m.meetTitle = MTitle;
m.meetRoom = MRoom;
m.meetPerson = MPerson;
m.meethostP = Mhost;
m.meetType = MType;
if (new getMeetManage().InsertMeet(m) > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('會議發佈成功!')", true);
Response.Redirect("~/Main.aspx");
}
}
Response.Write(("数据导入成功!"));
}
catch (Exception ex)
{
Response.Write(ex.Message);
}