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