Read Excel Data Using ASP.net 2.0 C#

[ntuyen01]

Hi All,

I try to read the data from the excel, but I ran into this problem

I have two excel files.
file one.xls data inside like this:

1234 1234
1234 1234
abc-123 abc-123
abc-123 abc-123
File two.xls data inside like this:
abc-123 abc-123
abc-123 abc-123
1234 1234
1234 1234
Read from file one:

source = "Provider=Micro soft.Jet.OLEDB. 4.0;" +
"Data Source=d:\\File one.xls;" +
"Extended Properties=" + (char)34 + "Excel
8.0;HDR=Yes;IME X=1;" + (char)34;

/*
OleDbConnection objConn = new OleDbConnection (source);

// Open connection with the database.
objConn.Open();

// Create new OleDbCommand to return data from worksheet.
OleDbCommand objCmdSelect = new OleDbCommand("S ELECT
GroupName, ProtocolID FROM [Sheet1$]", objConn);

// Create new OleDbDataAdapte r that is used to build a DataSet
// based on the preceding SQL SELECT statement.
OleDbDataAdapte r objAdapter = new OleDbDataAdapte r();

// Pass the Select command to the adapter.
objAdapter.Sele ctCommand = objCmdSelect;

// Create new DataSet to hold information from the worksheet.
DataSet objDataset = new DataSet();

// Fill the DataSet with the information from the worksheet.
objAdapter.Fill (objDataset, "XLData");

GridView1.DataS ource = objDataset.Tabl es[0].DefaultView;
GridView1.DataB ind();
Gridview only display:
1234 1234
1234 1234

If I read from file two:
Gridview only display:
abc-123 abc-123
abc-123 abc-123
1234 1234
1234 1234
Both column in the excel is general.

Please help. Thanks in advance