Excel数据导入到Sqlserver

看了您将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);
    }