Display the data from Access Database and Sqlserver in a single grid.

I need to populate a grid with data from a table in Access DB and another table in Sqlserver. Can some body help me regarding this.

Thanks in advance!

Sandy

.NET Development31

absolutely. There are multiple threads about this...I hope these help get you started:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=753872&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=981046&SiteID=1

its the same for SQL Server also, the only things that really need to be changed are just the classes! So instead of using the OleDb classes, use the Sql classes (in the System.Data.SqlClient namespace)