asp.net中Excel导入(使用微软OLEDB驱动)
来源:互联网 发布:软件商城开发公司 编辑:程序博客网 时间:2024/05/16 13:01
//web.config<configuration>中配置节点
<appSettings>
<add key="SqlString" value="uid=sa;PWD=sa;DATA SOURCE=(local);INITIAL CATALOG=chinasuntv" />
<add key="ExcelStr" value="Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source="/>
<add key="DataBase" value="/program/UploadFiles/Program.xls"></add>
</appSettings>
<appSettings>
<add key="SqlString" value="uid=sa;PWD=sa;DATA SOURCE=(local);INITIAL CATALOG=chinasuntv" />
<add key="ExcelStr" value="Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source="/>
<add key="DataBase" value="/program/UploadFiles/Program.xls"></add>
</appSettings>
1protected void btnUpLoad_Click(object sender, EventArgs e)
2 { //若此处未加逻辑判断,如果excel文件不存在则程序将会报异常
3 if(System.IO.File.Exists(MapPath(DataBase)))
4 {
5
6 OleDbConnection OleCon = new OleDbConnection( ExcelStr+MapPath(DataBase));
7 OleDbDataAdapter OleDAp = new OleDbDataAdapter( "SELECT prgName,PlayTime,prgColumn FROM [Sheet1$] ", OleCon);
8 DataSet ds = new DataSet();
9 OleDAp.Fill(ds);
10
11 string prgName,playTime,prgColumn,sSQL;
12 SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["SqlString"]);
13 conn.Open();
14 SqlCommand cmd;
15 try
16 {
17
18 foreach (DataRow dr in ds.Tables[0].Rows)
19 {
20
21 prgName = dr["prgName"].ToString();
22 playTime = dr["PlayTime"].ToString();
23 prgColumn = dr["prgColumn"].ToString();
24
25 sSQL = "Insert Into Ax_Program (prgName,PlayTime,prgColumn,prgComment) Values ('"+prgName +"','" + playTime+ "','"+prgColumn+"','"+DateTime.Now.ToString("yyyy-MM-dd HH:mm")+"Excel导入')";
26 cmd = new SqlCommand(sSQL,conn);
27 cmd.CommandType = CommandType.Text;
28 cmd.ExecuteNonQuery();
29 cmd.Dispose();
30
31 }
32 }
33 catch (Exception)
34 {
35 Response.Write("<script language='javascript'>window.alert('导入失败')</script>;");
36 return;
37 }
38 finally
39 {
40
41 conn.Close();
42 conn.Dispose();
43 }
44 Response.Write("<script language='javascript'>window.alert('导入成功')</script>;");
45 ExlDataGrid.Visible=false;
46
47 OpenAndBindNew();
48
49 lbWarning.Visible=false;
50 lbWarningS.Visible=true;
51 lbWarningS.Text="本此操作导入的节目信息";
52 }
53 else
54 {
55 Response.Write("<script language='javascript'>window.alert('Excel文件不存在!')</script>;");
56 }
57 }
2 { //若此处未加逻辑判断,如果excel文件不存在则程序将会报异常
3 if(System.IO.File.Exists(MapPath(DataBase)))
4 {
5
6 OleDbConnection OleCon = new OleDbConnection( ExcelStr+MapPath(DataBase));
7 OleDbDataAdapter OleDAp = new OleDbDataAdapter( "SELECT prgName,PlayTime,prgColumn FROM [Sheet1$] ", OleCon);
8 DataSet ds = new DataSet();
9 OleDAp.Fill(ds);
10
11 string prgName,playTime,prgColumn,sSQL;
12 SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["SqlString"]);
13 conn.Open();
14 SqlCommand cmd;
15 try
16 {
17
18 foreach (DataRow dr in ds.Tables[0].Rows)
19 {
20
21 prgName = dr["prgName"].ToString();
22 playTime = dr["PlayTime"].ToString();
23 prgColumn = dr["prgColumn"].ToString();
24
25 sSQL = "Insert Into Ax_Program (prgName,PlayTime,prgColumn,prgComment) Values ('"+prgName +"','" + playTime+ "','"+prgColumn+"','"+DateTime.Now.ToString("yyyy-MM-dd HH:mm")+"Excel导入')";
26 cmd = new SqlCommand(sSQL,conn);
27 cmd.CommandType = CommandType.Text;
28 cmd.ExecuteNonQuery();
29 cmd.Dispose();
30
31 }
32 }
33 catch (Exception)
34 {
35 Response.Write("<script language='javascript'>window.alert('导入失败')</script>;");
36 return;
37 }
38 finally
39 {
40
41 conn.Close();
42 conn.Dispose();
43 }
44 Response.Write("<script language='javascript'>window.alert('导入成功')</script>;");
45 ExlDataGrid.Visible=false;
46
47 OpenAndBindNew();
48
49 lbWarning.Visible=false;
50 lbWarningS.Visible=true;
51 lbWarningS.Text="本此操作导入的节目信息";
52 }
53 else
54 {
55 Response.Write("<script language='javascript'>window.alert('Excel文件不存在!')</script>;");
56 }
57 }
- asp.net中Excel导入(使用微软OLEDB驱动)
- asp.net中使用OLEDB操作Excel
- 使用ASP.NET OleDb驱动程序 导入到处EXCEL
- asp.net OleDb导入Excel,并显示导入内容
- asp.net 解决使用OLEDB导入excel数据时同时包含文本和数字的列无法正常读取情况
- .Net之路(十四)com组件、OLEDB导入EXCEL
- ASP.NET中使用Excel导入数据到数据库
- asp.net 中上传并读取Excel文件(OLEDB方式)
- Asp.net/c#+OleDb操作excel文件(二),数据传输使用Parameters
- Asp.net/c#+OleDb操作excel文件
- Asp.net/c#+OleDb操作excel文件
- 使用OleDb,将Excel导入DataSet
- [zz]使用OleDb,将Excel导入DataSet
- Asp.net中Excel文件导入sqlServer
- asp.net中Excel导入SQL
- asp.net中Excel导入SQL
- asp.net中Excel的导入导出
- ASP.NET Excel导入SQLserver 数据库中
- window.showModalDialog以及window.open用法简介
- VS2005快捷键大全
- 股市投资录
- 自己写的一个模板队列(修改了2月3号新版本)
- 制作多色列表框(Multi-color ListBox)
- asp.net中Excel导入(使用微软OLEDB驱动)
- sqlserver 2000与2005区别
- easysql,一个由中国人开发的类似于hibernate的框架,简单易用!
- Linux那些事儿之我是Block层(2)注册一个块设备驱动
- 读《设计心理学》-1
- 工作效率和薪水加倍的7个秘诀
- VS2005 crystalReportviewer 打印问题
- 用SQLSERVER远程备份
- WinXP环境下安装Apache2.2.3+php5.2.0+Mysql5.0.18+phpMyAdmin备忘