private DataSet GetOleData()
{
OleDbConnection objConn = null;
DataSet ds = new DataSet();
string FileAddr = "D: \\test.xlsx";
string strConn = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source='"FileUpload1.PostedFile.FileName.ToString() + "';Extended Properties='Excel 12.0;HDR=Yes;IMEX=1' ";
objConn = new OleDbConnection(strConn);
objConn.Open();
string strSql = "select * from [Sheet1$] ";
OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
OleDbDataAdapter sqlada = new OleDbDataAdapter();
sqlada.SelectCommand = objCmd;
sqlada.Fill(ds, "MyRecords ");
objConn.Close(); return ds; DataRow[] dr = ds.Tables[0].Select(); //定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Response.Write("<script>alert('Excel表为空表,无数据!')</script>"); //当Excel表为空时,对用户进行提示
}
else
{
for (int i = 0; i < dr.Length; i++)
{
string pininputdate = dr[i]["excel列名"].ToString();//日期 excel列名【名称不能变,否则就会出错】
// string insertstr = "insert语句";
OleDbCommand cmd = new OleDbCommand(strSql, objConn);
怎么加语句是这部分程序顺利运行?????
{
OleDbConnection objConn = null;
DataSet ds = new DataSet();
string FileAddr = "D: \\test.xlsx";
string strConn = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source='"FileUpload1.PostedFile.FileName.ToString() + "';Extended Properties='Excel 12.0;HDR=Yes;IMEX=1' ";
objConn = new OleDbConnection(strConn);
objConn.Open();
string strSql = "select * from [Sheet1$] ";
OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
OleDbDataAdapter sqlada = new OleDbDataAdapter();
sqlada.SelectCommand = objCmd;
sqlada.Fill(ds, "MyRecords ");
objConn.Close(); return ds; DataRow[] dr = ds.Tables[0].Select(); //定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Response.Write("<script>alert('Excel表为空表,无数据!')</script>"); //当Excel表为空时,对用户进行提示
}
else
{
for (int i = 0; i < dr.Length; i++)
{
string pininputdate = dr[i]["excel列名"].ToString();//日期 excel列名【名称不能变,否则就会出错】
// string insertstr = "insert语句";
OleDbCommand cmd = new OleDbCommand(strSql, objConn);
怎么加语句是这部分程序顺利运行?????
解决方案 »
- C# 哪个API函数是控制网卡可以共享的
- 请问如何用CodeDom编译cs文件在C#程序内使用?
- 求助!binaryWrite写进的int32,binaryReader读不出来
- 【求救】程序硬直假死,这种情况能做个进度条么?
- 如何遍历PANEL中的六个RadioButton
- C#做还原数据库时发生如下错误:从服务器接收结果时发生传输级错误。(provider: 共享内存提供程序, error: 1 -执行读\写期间检测到I\O错误
- 求个好算法解决随机数问题
- (热门求助)asp.net servlet Session 共享问题(3000分)
- windows2003系统服务器上用IIS发布ASP.NET(C#)项目局域网IP访问正常,用固定外网IP访问就访问不到
- 从数据库获取到数据,然后放入字典里,怎么循环操作依次字典内数据
- C# Winform生成另一个exe的实现原理?[在线等]
- 同时打开2个visual studio 编译器,如何其中一个F11 断点进入另一个编译器?
直接往数据库中用insert插入就可以了
insert into #tempTable select * from [Sheet1$]
delete from #tempTable where 数据为空
insert into yourTable select * from #tempTable好像不用那么麻烦吧