if(this.File1.ToString() !="")
{
url=this.File1 .PostedFile .FileName;
try
{
Excelin();
//ExcelDaoRu=true;
}
catch(Exception error)
{
this.tslab .Text ="您没有选择文件或者选择的类型不对,请重新选择!";
}
}
private void Excelin()
{
OleDbConnection c = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;"+ "Data Source="+url+";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'"); //成功
c.Open();
OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$] ", c);
OleDbDataAdapter d = new OleDbDataAdapter(cmd);
DataSet dataset = new DataSet();
d.Fill(dataset);
cjdgd.DataSource = dataset;
cjdgd.DataBind();
c.Close();
}
{
url=this.File1 .PostedFile .FileName;
try
{
Excelin();
//ExcelDaoRu=true;
}
catch(Exception error)
{
this.tslab .Text ="您没有选择文件或者选择的类型不对,请重新选择!";
}
}
private void Excelin()
{
OleDbConnection c = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;"+ "Data Source="+url+";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'"); //成功
c.Open();
OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$] ", c);
OleDbDataAdapter d = new OleDbDataAdapter(cmd);
DataSet dataset = new DataSet();
d.Fill(dataset);
cjdgd.DataSource = dataset;
cjdgd.DataBind();
c.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货