protected void btnOk_Click(object sender, EventArgs e)
{
//添加学生信息
#region
if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件
{
Label2.Visible = true;
Label2.Text = "请选择导入文件";
}
string filename = FileUpload1.FileName;//获取Execle文件名 DateTime日期函数
string savePath = Server.MapPath(("~/HouTai/wordfiles/") + filename);//Server.MapPath 获得虚拟服务器相对路径
FileUpload1.SaveAs(savePath);//SaveAs 将上传的文件内容保存在服务器上
ds = FilesDs(savePath, filename);//调用自定义方法
DataRow[] dr = ds.Tables[0].Select();//定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Label2.Visible = true;
Label2.Text = "导入表为空表,无数据";
}
else
{
for (int i = 0; i < dr.Length; i++)
{
pathmodel.SName = txtname.Text;
pathmodel.PathAdd = filename;
pathmodel.DateTime = DateTime.Now.Date;
//存储到数据库中
ds = path.GetList("SName=" + txtname.Text + "");
if (ds.Tables[0].Rows.Count>0)
{
path.Update(pathmodel);
Label2.Visible = true;
Label2.Text = "添加成功!";
}
else
{
path.Add(pathmodel);
Label2.Visible = true;
Label2.Text = "添加成功!";
}
}
Repeater1.DataBind();
}
#endregion
}
public DataSet FilesDs(string filenameurl, string table)
{ string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + "";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [word.doc]", conn);
odda.Fill(ds, table);
return ds;
}
{
//添加学生信息
#region
if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件
{
Label2.Visible = true;
Label2.Text = "请选择导入文件";
}
string filename = FileUpload1.FileName;//获取Execle文件名 DateTime日期函数
string savePath = Server.MapPath(("~/HouTai/wordfiles/") + filename);//Server.MapPath 获得虚拟服务器相对路径
FileUpload1.SaveAs(savePath);//SaveAs 将上传的文件内容保存在服务器上
ds = FilesDs(savePath, filename);//调用自定义方法
DataRow[] dr = ds.Tables[0].Select();//定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Label2.Visible = true;
Label2.Text = "导入表为空表,无数据";
}
else
{
for (int i = 0; i < dr.Length; i++)
{
pathmodel.SName = txtname.Text;
pathmodel.PathAdd = filename;
pathmodel.DateTime = DateTime.Now.Date;
//存储到数据库中
ds = path.GetList("SName=" + txtname.Text + "");
if (ds.Tables[0].Rows.Count>0)
{
path.Update(pathmodel);
Label2.Visible = true;
Label2.Text = "添加成功!";
}
else
{
path.Add(pathmodel);
Label2.Visible = true;
Label2.Text = "添加成功!";
}
}
Repeater1.DataBind();
}
#endregion
}
public DataSet FilesDs(string filenameurl, string table)
{ string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + "";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [word.doc]", conn);
odda.Fill(ds, table);
return ds;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货