建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
C#讀取Excel中數(shù)據(jù)并插入到數(shù)據(jù)庫中
C#讀取Excel中數(shù)據(jù)，首先上傳選擇的xls文件,根據(jù)得到路徑,讀取文件信息,插入到數(shù)據(jù)庫中。
為合江等地區(qū)用戶提供了全套網(wǎng)頁設(shè)計(jì)制作服務(wù)，及合江網(wǎng)站建設(shè)行業(yè)解決方案。主營業(yè)務(wù)為成都網(wǎng)站制作、成都網(wǎng)站建設(shè)、合江網(wǎng)站設(shè)計(jì)，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會(huì)得到認(rèn)可，從而選擇與我們長(zhǎng)期合作。這樣，我們也可以走得更遠(yuǎn)！
- 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 strConn = "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();
- //連接數(shù)據(jù)源
- OleDbConnection conn = new OleDbConnection(strConn);
- conn.Open();
- //適配到數(shù)據(jù)源
- OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, conn);
- adapter.Fill(ds, "data");
- conn.Close();
- GridView1.DataSource = ds.Tables["data"];
- 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++)
- {
- 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.ToString());
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- string fileName = null;
- try
- {
- Boolean fileOK = false;
- String path = Server.MapPath("./doc/");
- if (FileUpload2.HasFile)
- {
- String fileExtension =
- System.IO.Path.GetExtension(FileUpload2.FileName).ToLower();
- String[] allowedExtensions =
- { ".xls" }; //C#讀取Excel中數(shù)據(jù)
- for (int i = 0; i < allowedExtensions.Length; i++)
- {
- if (fileExtension == allowedExtensions[i])
- {
- fileOK = true;
- }
- }
- }
- if (fileOK)
- {
- fileName = "r_" + DateTime.Now.ToString("yyyy_MM_dd_hh_mm_ss") + "_" + DateTime.Now.Millisecond +
- System.IO.Path.GetExtension(FileUpload2.FileName).ToLower();
- if (File.Exists(path + fileName))
- {
- Random rnd = new Random(10000);
- fileName = fileName + rnd.Next();
- }
- FileUpload2.PostedFile.SaveAs(path
- + fileName);
- }
- else
- {
- }
- }
- catch (Exception exp)
- {
- }
- ExcelToDS(Server.MapPath(".") + "\\doc\\"+fileName);
- }
C#讀取Excel中數(shù)據(jù)并插入到數(shù)據(jù)庫中就介紹到這里。
網(wǎng)站題目：C#讀取Excel中數(shù)據(jù)并插入到數(shù)據(jù)庫中
URL地址：http://fisionsoft.com.cn/article/dpopohi.html
