protected void Button1_Click(object sender, EventArgs e)
{
{
string savepath = Server.MapPath("~/xls/" + FileUpload1.FileName);
FileUpload1.PostedFile.SaveAs(savepath); DataSet ds = new DataSet(); string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + savepath + ";" + @"Extended Properties=""text;HDR=Yes;FMT=Delimited""";
string filename = FileUpload1.FileName;
string query = "SELECT * FROM [filename]";
OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(ConnStr));
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
oleAdapter.Fill(ds, filename);
int rowcount = ds.Tables[0].Rows.Count;
gridview1.DataSource = ds;
gridview1.DataBind();
}
}
将一个CSV文件通过FileUpload读取到gridview中,老是报错,各位帮忙看下,谢谢。
{
{
string savepath = Server.MapPath("~/xls/" + FileUpload1.FileName);
FileUpload1.PostedFile.SaveAs(savepath); DataSet ds = new DataSet(); string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + savepath + ";" + @"Extended Properties=""text;HDR=Yes;FMT=Delimited""";
string filename = FileUpload1.FileName;
string query = "SELECT * FROM [filename]";
OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(ConnStr));
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
oleAdapter.Fill(ds, filename);
int rowcount = ds.Tables[0].Rows.Count;
gridview1.DataSource = ds;
gridview1.DataBind();
}
}
将一个CSV文件通过FileUpload读取到gridview中,老是报错,各位帮忙看下,谢谢。
"Data Source=" + savepath + ";" 这里要是 :~/xls/
但是导到GRID的中文是乱码啊(不论什么编码模式),而且没有像EXCEL自动划分列,被当成一个列了。