Trying to get an excel file into a listview,
My code:
//this is how I call the excel file using OLEBD
OleDbConnection cnn = new
OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
+ textBox_Choose.Text + (@"~\data\cocustomerdetails.xlsx") + ";
Extended Properties=Excel 12.0;");
OleDbCommand oconn = new OleDbCommand("select * from [" +
textBox_Choose.Text, cnn);
cnn.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(oconn);
DataTable dt = new DataTable();
adp.Fill(dt);
foreach (DataRow row in dt.Rows)
{
ListViewItem item = new ListViewItem(row[0].ToString());
for (int i = 1; i < dt.Columns.Count; i++)
{
item.SubItems.Add(row[i].ToString());
}
listView1.Items.Add(item);
No comments:
Post a Comment