Why would DataGrid preserves the original order/format?

EDN Admin · Nov 1, 2012

<span style="font-family:Times New Roman,serif I’m using this code to pull data from an Excel file into a DataGrid:

<span style="color:blue private <span style="color:blue void button1_Click(<span style="color:blue object sender,

{

<span style="color:#2B91AF DataTable table = <span style="color:blue
new 
<span style="color:blue string strConn = <span style="color:blue
string.Format(<span style="color:#A31515 "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1;TypeGuessRows=0;ImportMixedTypes=Text"",
<span style="color:#A31515 "C:\Users\Excel\Desktop\Coding\DOT.NET\Samples C#\Export DataGridView to SQL Server Table\Import_List.xls");

<span style="color:blue using (<span style="color:#2B91AF OleDbConnection dbConnection =
<span style="color:blue new 
 {

<span style="color:blue using (<span style="color:#2B91AF OleDbDataAdapter dbAdapter =
<span style="color:blue new <span style="color:#2B91AF OleDbDataAdapter(<span style="color:#A31515 "SELECT * FROM [Sheet1$]", dbConnection))

dbAdapter.Fill(table);

dataGridView1.DataSource = table;

 
}

}
<span style="font-family:Times New Roman,serif
Excel View:
<img alt="" src="http://social.msdn.microsoft.com/Forums/getfile/187999
DataGrid View:<span style="font-family:Times New Roman,serif
<span style="font-family:Times New Roman,serif <img alt="" src="http://social.msdn.microsoft.com/Forums/getfile/188000

At first, I had Fname, Lname, and Age. Then I added Key (in ColumnA of the Excel Sheet) and “Nothing” (in ColumnD of the Excel Sheet); I put Age in ColumnE of the Excel Sheet.
It seems like the DataGrid preserves the original order of the Excel Sheet, and doesn’t really import the data from the Excel Sheet in the actual order of the data in the Excel Sheet.
I even deleted dataGridView1, and put in a new dataGridView1 object.
It did the same thing!! It’s like the DataGrid preserves the original order/format.
Is this the way it is supposed to work? Is this the desired functionality?
 Why would a developer actually want this? This seems so weird!!



View the full article

Why would DataGrid preserves the original order/format?

EDN Admin

Well-known member

Similar threads