Click here to Skip to main content
15,179,246 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi friends,

I am using two datatables, one was filled by SqlServer database and another was filled by me manually(adding columns,rows manually). when i tried to bind the datatable to microsoft excel using oledb, datatable filled from Sqlserver cannot bind the values to excel.

Please help regarding this.

Thank you.

DamithSL 9-Jul-14 22:48pm
update question with the code you tried? you need to add exception details as well
George Jonsson 9-Jul-14 22:49pm
You can try to save the two data tables into XML files and compare the data.
Use DataTable.WriteXML()
You should provide more info if you want a better answer.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900