C# DataGridView Loading data from Excel

The DataGridView control and its related classes are designed to be a flexible, extensible system for displaying and editing tabular data. The following C# source code shows how to Import data from an Excel file to a DataGridView control .

Full Source C#
using System; using System.Data; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { System.Data.OleDb.OleDbConnection MyConnection; System.Data.DataSet DtSet; System.Data.OleDb.OleDbDataAdapter MyCommand; MyConnection = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\csharp.net-informations.xls';Extended Properties=Excel 8.0;"); MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection); MyCommand.TableMappings.Add("Table", "Net-informations.com"); DtSet = new System.Data.DataSet(); MyCommand.Fill(DtSet); dataGridView1.DataSource = DtSet.Tables[0]; MyConnection.Close(); } } }







Related Topics
  1. C# DataGridView Binding - SQL Server dataset
  2. C# DataGridView Binding - OLEDB dataset
  3. C# DataGridView Sorting and Filtering
  4. C# DataGridView Add Columns and Rows
  5. C# DataGridView Hide Columns and Rows
  6. C# DataGridView Read Only Columns and Rows
  7. Add Button to C# DataGridView
  8. Add CheckBox to C# DataGridView
  9. Add ComboBox to C# DataGridView
  10. Add Image to C# DataGridView
  11. Add ViewLink to C# DataGridView
  12. C# DataGridView Paging
  13. C# DataGridView Formatting
  14. C# DataGridView Template
  15. C# DataGridView Printing
  16. C# DataGridView Export to Excel
  17. C# DataGridView Database Operations
  18. Delete row from datagridview by right click
  19. DataGridView Autocomplete TextBox in C#