string sheetname = GetExcelSheetName(file);
string conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file +
@";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""";
DataSet ds = new DataSet();
OleDbConnection objconn = new OleDbConnection(conn);
objconn.Open();
string sql = string.Format("SELECT distinct * FROM [{0}]", sheetname);
OleDbCommand objcmd = new OleDbCommand(sql, objconn);
OleDbDataAdapter sqlada = new OleDbDataAdapter();
sqlada.SelectCommand = objcmd;
sqlada.Fill(ds, "Records");
objconn.Close();
return ds;各位ds表中数据与EXECL表中数据排序不一致,请问有何方法解决
string conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file +
@";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""";
DataSet ds = new DataSet();
OleDbConnection objconn = new OleDbConnection(conn);
objconn.Open();
string sql = string.Format("SELECT distinct * FROM [{0}]", sheetname);
OleDbCommand objcmd = new OleDbCommand(sql, objconn);
OleDbDataAdapter sqlada = new OleDbDataAdapter();
sqlada.SelectCommand = objcmd;
sqlada.Fill(ds, "Records");
objconn.Close();
return ds;各位ds表中数据与EXECL表中数据排序不一致,请问有何方法解决
string sql = string.Format("SELECT distinct * FROM [{0}] ORDER BY excel排序的列", sheetname);