2024年3月9日发(作者：)

PART 1

using System;

using ;

using uration;

using tions;

using ;

using ty;

using ;

using trols;

using ts;

using ntrols;

using ;

using ent;

public partial class aaa :

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection conn = new

SqlConnection(tionStrings["CONNECTIONSTR

ING2"].ConnectionString);//链接数据库

();

int errorcount = 0;//记录错误信息条数

int insertcount = 0;//记录插入成功条数

try

{

string fileurl = typename(FileUpload1);

DataSet ds = new DataSet();

ds = xsldata(fileurl);

for (int i = 0; i < [0].; i++)

{

string info = [0].Rows[i][0].ToString();

string name = [0].Rows[i][1].ToString();

if (info != "" && name != "" )

{

SqlCommand insertcmd = new

SqlCommand("insert into dlinfo(dlname,truename) values('" + info + "','" +

name + "')", conn);

eNonQuery();

insertcount++;

}

else

{

errorcount++;

}

}

("");

}

catch (Exception ex)

{

("");

}

finally

{

();

}

}

protected String typename(FileUpload fileloads)

{

string fullfilename = me;

string filename = ing(dexOf("")

+ 1);

string type = ing(dexOf(".") + 1);

string murl = "";

if (type == "xls")

{

(h("excel") + "" +

filename);

murl = (h("excel") + "" + filename).ToString();

}