B/S Excel导入到sql server

 try        {            string physicspath = "D:\\" + FileUpload.FileName;  //excel文件存放的位置            //生成连接Excel数据表格的字符串            string strOdbcCon = @"Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info=False;Data Source=" + physicspath + "; Extended Properties=Excel 8.0";            //定义OleDbConnection对象实例并连接Excel表格            OleDbConnection OleDB = new OleDbConnection(strOdbcCon);            //定义OleDbDataAdapter对象实例并调用Select查询语句提取Excel数据信息            OleDbDataAdapter OleDat = new OleDbDataAdapter("select * from [Sheet1$]", OleDB);            DataTable dt = new DataTable();    //定义DataTable对象实例            OleDat.Fill(dt);                   //调用Fill方法            //连接数据表格，显示数据            DataSet ds = new DataSet();            if (dt.Rows.Count > 0)            {                List<Tb_RDUserInfo> list = new List<Tb_RDUserInfo>();  //这里写的例子，是用的是架构，但其思路：先读取excel里面的值填充到dataset然后insert到数据库中                foreach (DataRow dr in dt.Rows)                {                    Tb_RDUserInfo model = new Tb_RDUserInfo();                    model.UsersId = dr["编号"].ToString();                    model.UsersName = dr["姓名"].ToString();                    model.LoginName = dr["登录用户名"].ToString();                    string RoleId = dr["角色"].ToString();                    Tb_RDRoleInfo Tb_RDRole_4 = new Tb_RDRoleInfo();                    Tb_RDRoleService Tb_RDRole_5 = new Tb_RDRoleService();                    Tb_RDRole_4 = Tb_RDRole_5.GetModel(RoleId);                    model.RoleId = Tb_RDRole_4;                    model.PassWord = dr["密码"].ToString();                    model.Mobile = dr["手机号码"].ToString();                    model.Birthday = dr["出生日期"].ToString();                    model.Sex = dr["性别"].ToString();                    model.DentityCard = dr["身份证"].ToString();                    model.OrgName = dr["单位名称"].ToString();                    model.DeptName = dr["部门名称"].ToString();                    model.Post = dr["职务信息"].ToString();                    model.PeriodName = dr["届次"].ToString();                    model.Email = dr["电子邮箱"].ToString();                    model.Phone = dr["固定电话"].ToString();                    model.Address = dr["通讯地址"].ToString();                    model.ZipCodeId = dr["邮政编码"].ToString();                    model.IsAdmin = dr["是否管理员"].ToString();                    model.CurrentState = dr["当前状态"].ToString();                    model.Memo = dr["备注"].ToString();                    string DelegationId = dr["所属代表团"].ToString();                    Tb_DelegationInfo Tb_Delegation_21 = new Tb_DelegationInfo();                    Tb_DelegationService Tb_Delegation_22 = new Tb_DelegationService();                    Tb_Delegation_21 = Tb_Delegation_22.GetModel(DelegationId);                    model.DelegationId = Tb_Delegation_21;                    model.ManageWork = dr["分管工作"].ToString();                    model.UserType = dr["用户分类个体"].ToString();                    list.Add(model);                }                UserManager.Add(list);                MessageBox.Show(this, "批量添加用户成功！");            }            else            {                MessageBox.Show(this, "对不起,无数据无法添加！");            }        }        catch (Exception ey)        {            MessageBox.Show(this, ey.Message);         //提示对话框        }

添加引用：using System.Data.OleDb;

在页面设计中拖入FileUpload控件

代码部分：