protected void UploadAs_Click(object sender, EventArgs e) { if (DataSetName.Text.Trim().Length != 0 && DataSetUpload.HasFile) { //move most to uploader //handle spaces in file name String uploadPath = System.IO.Path.Combine(System.IO.Path.GetTempPath().ToString(), DataSetUpload.FileName); DataSetUpload.SaveAs(uploadPath); String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.IO.Path.GetTempPath().ToString() + ";Extended Properties='text;HDR=Yes;FMT=Delimited'"; connection = new OleDbConnection(connectionString); OleDbCommand cmd = new OleDbCommand("SELECT * FROM " + DataSetUpload.FileName, connection); da = new OleDbDataAdapter(cmd); connection.Open(); dt = new System.Data.DataTable(); da.Fill(dt); System.Data.DataSet ds = new System.Data.DataSet(DataSetName.Text.Trim()); String[] parameters = { "main" }; ds.Load(dt.CreateDataReader(), System.Data.LoadOption.OverwriteChanges, parameters); Session.Add("table", dt); Session.Add("connection", connection); Session.Add("adapter", da); Registry.Registry registry = Registry.Registry.getRegistry(Session); registry.registerDataset(ds); DatasetList.Items.Add(ds.DataSetName); } }
protected void Preview_Click(object sender, EventArgs e) { if (DataSetUpload.HasFile) { //move most to uploader String uploadPath = System.IO.Path.Combine(System.IO.Path.GetTempPath().ToString(), DataSetUpload.FileName); DataSetUpload.SaveAs(uploadPath); String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.IO.Path.GetTempPath().ToString() + ";Extended Properties='text;HDR=Yes;FMT=Delimited'"; connection = new OleDbConnection(connectionString); OleDbCommand cmd = new OleDbCommand("SELECT * FROM " + DataSetUpload.FileName, connection); da = new OleDbDataAdapter(cmd); connection.Open(); dt = new System.Data.DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); Application.Add("dataset", dt); } }