上传MDB
namespace WebApplication6
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Thread th =new Thread(SaveFile);
th.Start();
while(th.ThreadState!=ThreadState.Stopped)
{ Thread.Sleep(100);}
String conStr = @"Data Source=SHADOW\HF_SQL;Initial Catalog=test;User ID=sa";
SqlConnection conn = new SqlConnection(conStr);
SqlCommand comm = new SqlCommand("insert into test(id) SELECT 编号 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("~/dbfile") + "/" + FileUpload1.FileName+";Persist Security Info=False')...pos机", conn);
conn.Open();
comm.ExecuteNonQuery();
comm=new SqlCommand("insert into test3(id) (SELECT 商户编号 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("~/dbfile") + "/" + FileUpload1.FileName+";Persist Security Info=False')...商户)", conn);
comm.ExecuteNonQuery();
conn.Close();
}
protected void SaveFile()
{
string path = Server.MapPath("~/dbfile") + "/" + FileUpload1.FileName;
FileUpload1.SaveAs(path);
}
}
}