上传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);
        }
    }
}

posted @ 2009-11-09 00:31  吹啵糖こ  阅读(155)  评论(0编辑  收藏  举报