excel导入时间日期格式问题
excel表 某日期为 2011-1-1
在数据库在我的电脑上用导入到datatable上,用gridview显示datatable,改日期变为 2011-01-01 00:00:00
要是数据库在别的电脑上,导入到datatable上,用gridview显示datatable,改日期变为 2011-1-1 0:00:00
为什么这么奇怪呢??请问要怎么改??
private DataSet excel(string str)
{
string sqlstr;
sqlstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str + ";Extended Properties='Excel 8.0; HDR=NO; IMEX=1;'";
OleDbConnection conn = new OleDbConnection(sqlstr);
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", conn);
adapter.Fill(ds,"excel");
return ds;
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
bool data = true;
string str = FileUpload1.FileName;
string FilePath = Server.MapPath("./FileUpload/") + str;
FileUpload1.PostedFile.SaveAs(FilePath);
DataTable dt = excel(FilePath).Tables["excel"];
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
}