C#:c#读取Excel并显示出来,然后存入数据库.

直接从Excel中读取出来,然后对"供应商" select distinct,然后分别对每个供应商做表.

代码如下:

Code
<!--<br /><br />Code highlighting produced by Actipro CodeHighlighter (freeware)<br />http://www.CodeHighlighter.com/<br /><br />-->1
2protectedvoidPage_Load(objectsender,EventArgse)
3{
4DataSetds=ImportExcel(Server.MapPath("ExcelFile/供应商违约扣款.xls"));
5GridView1.DataSource=ds.Tables["ExcelInfo"].DefaultView;
6GridView1.DataBind();
7
8ToDataBase(ds);
9}
10
11privateDataSetImportExcel(stringstrFileName)
12{
13if(strFileName=="")returnnull;
14stringstrConn="Provider=Microsoft.Jet.OLEDB.4.0;"+
15"DataSource="+strFileName+";"+
16"ExtendedProperties=Excel8.0;";
17OleDbDataAdapterExcelDA=newOleDbDataAdapter("SELECTtrim(供应商)as供应商,零件名称,型号,批量,下线数,下线率,不合格原因,考核原因,考核金额FROM[Sheet1$]",strConn);
18DataSetExcelDs=newDataSet();
19try
20{
21ExcelDA.Fill(ExcelDs,"ExcelInfo");
22
23}
24catch(Exceptionerr)
25{
26System.Console.WriteLine(err.ToString());
27}
28returnExcelDs;
29}
30
31
32privateboolToDataBase(DataSetds)
33{
34DataTabledtSupplier=newDataTable("dtSupplier");
35
36
37DataViewdv=ds.Tables[0].DefaultView;
38
39string[]column={"供应商"};
40dtSupplier=dv.ToTable(true,column);
41
42for(inti=0;i<dtSupplier.Rows.Count;i++)
43{
44
45DataRow[]r=ds.Tables[0].Select("供应商='"+dtSupplier.Rows[i]["供应商"].ToString()+"'");
46
47//插父表
48
49for(intj=0;j<r.Length;j++)
50{
51stringItemName=r[j]["零件名称"].ToString();
52stringscale=r[j]["型号"].ToString();
53stringbatch=r[j]["批量"].ToString();
54stringdownLine=r[j]["下线数"].ToString();
55stringdownPercent=r[j]["下线率"].ToString();
56stringoutReason=r[j]["不合格原因"].ToString();
57stringreason=r[j]["考核原因"].ToString();
58stringamt=r[j]["考核金额"].ToString();
59
60//插子表
61}
62
63//save
64}
65returntrue;
66}