铁圈咬住女孩手指,夜店俏佳人免费阅读,笔记本硬件知识
if (fileupload1.hasfile == false)
{
page.clientscript.registerstartupscript(this.gettype(), "shifou", "<script>alert('请您选择 excel文件')</script> ");
return;
}
string name = fileupload1.postedfile.filename; //获取初始文件名
int j = name.lastindexof("."); //取得文件名中最后一个"."的索引
string newext1 = name.substring(j); //获取文件扩展名
if (newext1 != ".xls" && newext1 != ".xlsx")
{
page.clientscript.registerstartupscript(this.gettype(), "wenjian", "<script>alert('只可以选择 excel文件')</script>");
return;//当选择的不是excel文件时,返回
}
sqlconnection cn = new sqlconnection(configurationmanager.appsettings["connectionstring"]);
cn.open();
//savepath = path.getfullpath(fileupload1.postedfile.filename);// fileupload1.postedfile.filename.tostring();
if (fileupload1.hasfile == false)//hasfile用来检查fileupload是否有指定文件
{
page.clientscript.registerstartupscript(this.gettype(), "wenjian", "<script>alert('excel路径有 问题')</script>");
return;//当无文件时,返回
}
filename = fileupload1.filename; //path.getfilenamewithoutextension (fileupload1.postedfile.filename);
savepath = server.mappath(("../../uploadfiles/xls/") + filename);
fileupload1.saveas(savepath); //保存xls文件
dataset ds = execleds(savepath, filename); //调用自定义方法
datarow[] dr = ds.tables[0].select(); //定义一个datarow数组
int rowsnum = ds.tables[0].rows.count;
if (rowsnum == 0)
{
//当excel表为空时,对用户进行提示
page.clientscript.registerstartupscript(this.gettype(), "kong", "<script>alert('excel表为空表, 无数据!')</script>");
}
else
{
for (int i = 0; i < dr.length; i++)
{
//自定义的model-student
student.belong = "";
student.birthday = convert.todatetime("1990-1-1");
student.classid = 1;
student.id = 1;
student.inschool = convert.todatetime("1990-1-1");
student.phone = "";
student.sex = "";
student.type = "";
student.isaudite = "否";
student.roleid = convert.toint32("22");
try
{
student.stuname = dr[i]["姓名"].tostring();
student.stuid = dr[i]["学号"].tostring();
student.username = dr[i]["姓名"].tostring();
student.userpassword = dr[i]["学号"].tostring();
}
catch(exception ex) {
response.write("<script>alert('"+ex.message+"')</script>");
return;
}
dataset ds2 = studentbll.getlist("stuid='" + dr[i]["学号"].tostring() + "'");
if (ds2.tables[0].rows.count == 0)
{
try
{
bool addstudent = convert.toboolean(studentbll.add(student));
if (addstudent)
page.clientscript.registerstartupscript(this.gettype(), "daochu", "<script>alert('excle表导入成功!')</script>");
}
catch (membershipcreateuserexception ex) //捕捉异常
{
page.clientscript.registerstartupscript(this.gettype(), "chongfu", "<script>alert('导入内容:" + ex.message + "')</script> ");
}
}
else
{
page.clientscript.registerstartupscript(this.gettype(), "chongfu", "<script>alert ('内容重复!禁止导入')</script> ");
continue;
}
}
}
}
public dataset execleds(string filenameurl, string table)
{
string strconn = "provider=microsoft.jet.oledb.4.0;data source=" + filenameurl + ";extended properties='excel 8.0;hdr=yes;imex=1;'";//这段字符串注意空格别写错否则会报错
oledbconnection conn = new oledbconnection(strconn);
oledbdataadapter odda = new oledbdataadapter("select * from [sheet18$]", conn);//【sheet18$】是表格名
dataset ds = new dataset();
odda.fill(ds, table);
return ds;
}
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Blazor server side 自家的一些开源的, 实用型项目的进度之 CEF客户端
.NET IoC模式依赖反转(DIP)、控制反转(Ioc)、依赖注入(DI)
vue+.netcore可支持业务代码扩展的开发框架 VOL.Vue 2.0版本发布
网友评论