Dataset is sorted when I select a record from excelcate. I want to record the same sequence as excelsheet, why data format has been sorted.
OleDbCommand objCommand = new OleDbCommand ("Select specific * to [" + strSheet + "]", objXConn);
OleDbDataAdapter objAdapter = New OleDbDataAdapter (objCommand);
objAdapter.Fill (dtEx);
This first column was taking the datatype as numeric. I added IMEX = 1 in extended properties, since the column is considered as a string, the data is no longer sorted.
Thanks
Comments
Post a Comment