| Author: Rex Sahaya Gregory 15 Oct 2008 | Member Level: Bronze | Rating: Points: 6 |
string connectionString = @"Provider=Microsoft.Jet. OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
DbDataAdapter adapter = factory.CreateDataAdapter();
DbCommand selectCommand = factory.CreateCommand(); selectCommand.CommandText = "SELECT ID,City,State FROM [Cities$]";
DbConnection connection = factory.CreateConnection(); connection.ConnectionString = connectionString;
selectCommand.Connection = connection;
adapter.SelectCommand = selectCommand;
DataSet cities = new DataSet();
adapter.Fill(cities);
gridEX1.SetDataBinding(cities.Tables[0], ""); gridEX1.RetrieveStructure();
|