Scribd
Upload
9 views2 pages

Load Excel Data in C# Windows Forms

The document contains a C# Windows Forms application code that connects to an Excel file using OleDb. It retrieves data from the first sheet of the Excel file and displays it in a DataGridView when a button is clicked. The connection to the Excel file is established using a specified connection string and the data is loaded into a DataSet before being assigned to the DataGridView's data source.

Uploaded by

Aurel Borcan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
9 views2 pages

Load Excel Data in C# Windows Forms

The document contains a C# Windows Forms application code that connects to an Excel file using OleDb. It retrieves data from the first sheet of the Excel file and displays it in a DataGridView when a button is clicked. The connection to the Excel file is established using a specified connection string and the data is loaded into a DataSet before being assigned to the DataGridView's data source.

Uploaded by

Aurel Borcan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

using System;

using [Link];

using [Link];

using [Link];

namespace WindowsFormsApplication1

public partial class Form1 : Form

public Form1()

InitializeComponent();

private void button1_Click(object sender, EventArgs e)

[Link] MyConnection;

[Link] DtSet;

[Link] MyCommand;

MyConnection = new
[Link](@"provider=[Link].4.0;Data
Source='c:\[Link]';Extended Properties=Excel 8.0;");

MyCommand = new [Link]("select * from


[Sheet1$]", MyConnection);

[Link]("Table", "[Link]");

DtSet = new [Link]();

[Link](DtSet);

[Link] = [Link][0];

[Link]();

}
}

You might also like