Sri
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.xls;Extended Properties=Excel 8.0;";DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");DbDataAdapter adapter = factory.CreateDataAdapter();DbCommand selectCommand = factory.CreateCommand();selectCommand.CommandText = "SELECT Last_Name,First_Name,Completion_Date,Completion_Date2,Completion_Date3,Completion_Date4 FROM " + table + " WHERE Last_Name IS NOT NULL ORDER BY Last_Name, First_Name";DbConnection connection = factory.CreateConnection();connection.ConnectionString = connectionString;selectCommand.Connection = connection;adapter.SelectCommand = selectCommand;DataSet ds = new DataSet();adapter.Fill(ds);return ds;
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.xls;Extended Properties=Excel 8.0;";DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");DbDataAdapter adapter = factory.CreateDataAdapter();DbCommand selectCommand = factory.CreateCommand();selectCommand.CommandText = "SELECT Last_Name,First_Name,Completion_Date,Completion_Date2,Completion_Date3,Completion_Date4 FROM " + table + " WHERE Last_Name IS NOT NULL ORDER BY Last_Name, First_Name";
DbConnection connection = factory.CreateConnection();connection.ConnectionString = connectionString;selectCommand.Connection = connection;adapter.SelectCommand = selectCommand;DataSet ds = new DataSet();adapter.Fill(ds);return ds;