fname=file.filename filename=formPath&"09.mdb" if file.FileSize>0 then file.SaveAs Server.mappath(FileName) end if dim conn1 dim connstr1 on error resume next connstr1="DBQ="+Server.MapPath( filename )+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};" set conn1=server.createobject("ADODB.CONNECTION") conn1.open connstr1 set rs=conn1.execute("select * from grade") flag=0 do while not rs.eof sql="insert into grade(Fileid,Name,Id_card,Knowledge,Phone,Address,Module_sig,Exam_date,Grade) values ('"&rs("Fileid")&"','"&rs("Name")&"','"&rs("Id_card")&"','"&rs("Knowledge")&"','"&rs("Phone")&"','"&rs("Address")&"','"&rs("Module_sig")&"','"&rs("Exam_date")&"','"&rs("Grade")&"')" conn.execute(sql) rs.movenext loop
自己解决了,不给分了using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb;public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { }
上传mdb,追加到mdb
现在想做成aspx的
filename=formPath&"09.mdb"
if file.FileSize>0 then
file.SaveAs Server.mappath(FileName)
end if
dim conn1
dim connstr1
on error resume next
connstr1="DBQ="+Server.MapPath( filename )+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn1=server.createobject("ADODB.CONNECTION")
conn1.open connstr1
set rs=conn1.execute("select * from grade")
flag=0
do while not rs.eof
sql="insert into grade(Fileid,Name,Id_card,Knowledge,Phone,Address,Module_sig,Exam_date,Grade) values ('"&rs("Fileid")&"','"&rs("Name")&"','"&rs("Id_card")&"','"&rs("Knowledge")&"','"&rs("Phone")&"','"&rs("Address")&"','"&rs("Module_sig")&"','"&rs("Exam_date")&"','"&rs("Grade")&"')"
conn.execute(sql)
rs.movenext
loop
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (FileUpload1.PostedFile.FileName == "")
{
Label1.Text = "要上传的文件不允许为空!";
return;
}
else
{
string filepath = FileUpload1.PostedFile.FileName;
string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1);
string strDocExt = System.IO.Path.GetExtension(FileUpload1.FileName); //得到文件的扩展名
string serverpath = Server.MapPath("File/") + 9 + strDocExt;
Boolean fileOk = false;
string[] allowExtension = { ".mdb", ".MDB" };
//对上传的文件的类型进行一个个匹对
for (int i = 0; i < allowExtension.Length; i++)
{
if (strDocExt == allowExtension[i])
{
fileOk = true;
FileUpload1.PostedFile.SaveAs(serverpath);
Label1.Text = "上传成功!";
//下面将添加数据添加语句 string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("grade.mdb");
string ConStr1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("File/9.mdb");
OleDbConnection oc=new OleDbConnection(ConStr ) ;
OleDbConnection oc1 = new OleDbConnection(ConStr1);
oc.Open();
oc1.Open();
OleDbDataAdapter oa = new OleDbDataAdapter("select * from grade",oc1);
DataSet ds=new DataSet ();
oa.Fill (ds);
//string sql="insert into grade(Fileid,Name,Id_card,Knowledge,Phone,Address,Module_sig,Exam_date,Grade) values ('"&rs("Fileid")&"','"&rs("Name")&"','"&rs("Id_card")&"','"&rs("Knowledge")&"','"&rs("Phone")&"','"&rs("Address")&"','"&rs("Module_sig")&"','"&rs("Exam_date")&"','"&rs("Grade")&"')"
if(ds!=null && ds.Tables.Count>0)
{
foreach(DataRow dr in ds.Tables[0].Rows)
{
//在这里遍历,然后查询
//string Sql="select * from 表名 where Name='"+dr["姓名"]+"'";
string sql = "insert into grade(Fileid,Name,Id_card,Knowledge,Phone,Address,Module_sig,Exam_date,Grade) values ('" +dr["Fileid"] + "','" + dr["Name"] + "','" + dr["Id_card"]+ "','" + dr["Knowledge"] + "','" + dr["Phone"] + "','" + dr["Address"] + "','" + dr["Module_sig"] + "','" + dr["Exam_date"] + "','" + dr["Grade"] + "')";
OleDbCommand instd=new OleDbCommand (sql,oc);
instd.ExecuteNonQuery(); }
}
oc.Close();
oc1.Close();
break;
}
else
{
Label1.Text = "上传失败,文件类型不符,请选择正确的文件!";
}
}
}
}
catch (Exception error)
{
Label1.Text = "处理发生错误!原因:" + error.ToString();
}
}
}