c#上传excel到数据库表

《c#上传excel到数据库表》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、C#上传excel到数据库表《一》using System.Data;    using System.Data.OleDb;    using System.IO;    using System.Text; protected void Page_Load(object sender, EventArgs e)     {               }     public void ExcelToDS(string path)        {             string strSheetName = "sheet1";            string st

2、rConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";            //Sql语句             string strExcel = "select * from  [" + strSheetName + "$] ";                      DataSet ds = new DataSet();           //连接数据源             OleDbC

3、onnection conn = new OleDbConnection(strConn);             conn.Open();               //适配到数据源             OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, conn);            adapter.Fill(ds, "data");               conn.Close();               GridView1.DataSource = ds.Tables["data"]; 

4、           GridView1.DataBind();              Label1.Text = ds.Tables[0].Rows.Count.ToString();            SqlAccess.Sqldatabase sql = new SqlAccess.Sqldatabase();            StringBuilder sb = new StringBuilder();            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)            {     

5、              sb.Append("insert into data values('" + ds.Tables[0].Rows[i]["companyname"] + "','" + ds.Tables[0].Rows[i]["telname"] + "','" + ds.Tables[0].Rows[i]["qytel"] + "','" + ds.Tables[0].Rows[i]["fax"] + "');");               }            sql.ExecuteNonQuery(CommandType.Text, sb.ToStr

6、ing());           }        protected void Button1_Click(object sender, EventArgs e)        {            string fileName = null;            try           {                Boolean fileOK = false;                String path = Server.MapPath("./doc/");                if (FileUpload2.HasFile)     

7、           {                    String fileExtension =                        System.IO.Path.GetExtension(FileUpload2.FileName).ToLower();                    String[] allowedExtensions =                     { ".xls" };    //C#读取Excel中数据