Hi Friends,
I have a requirement like excel to be appaned to datatable.for this I am adding excel column names statically as shown below:
cmdExcel.CommandText ="SELECT * From [" + SheetName +
"]";
oda.SelectCommand = cmdExcel;
OleDbDataReader rdr = cmdExcel.ExecuteReader();
Go to the complete details ...