Our Training Programs

All contents are copyright of their authors.

import Data from Excel to under The columns of DatagridView.

import Data from Excel to under The columns of DatagridView.

Zeb Muhammad

9yAsked Aug 10, 2017, 4:07 AM822Learn iOS Programming

first I want to say thank you all , You have a stuning Job here.

Secondly,

I Want to Import Data from Excel File to My DataGrideview columns.

I tried but data coms after My added columns.Please, Check my code bellow.

private void button8_Click_1(object sender, EventArgs e)
{
string content = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strExcelPathName.Text + "; Extended Properties=\"Excel 8.0;\";";
OleDbConnection con = new OleDbConnection(content);
OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM[" + txtSheet.Text + "$]", con);
DataTable dt = new DataTable();
oda.Fill(dt);
dataGridView1.DataSource = dt;
}

please, help me

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Zeb Muhammad9y ago
ok I fetch Value of Excel File witout headers in DataGrideView but it Lefts Datagrideview Header and put these values next columns ........... what is problem?
Zeb Muhammad9y ago
thx darjeam nh
But I need . when columns headers are already adde....
Rahul Prasad9y ago
this article may help

http://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database