Bind Data in Grid View two Database in single query and single Gridview?

Question

Bind Data in Grid View two Database in single query.

i have two database
1.CRMS
2.ERP

i want to bind the data from two database(Tables)

For Example:

my connection string is ,

SqlConnection con = new SqlConnection("Server=(local);initial catalog=CRMS;Trusted_Connection=True");

SqlConnection con = new SqlConnection("Server=(local);initial catalog=ERP;Trusted_Connection=True");

Thanks&Regs

Magesh

Jignesh Trivedi · Answer

hi current Answer is good idea but it has some limitation like its hard code data base name in query. I think use data relationship or LINQ-DataSet. http://www.codeproject.com/Articles/18304/Using-Data-Relation-with-Data-Table http://msdn.microsoft.com/en-us/library/ay82azad%28v=vs.71%29.aspx Good article http://blogs.msdn.com/b/adonet/archive/2007/01/26/querying-datasets-introduction-to-linq-to-dataset.aspx hope this help.

venkata saibabu · Answer

Query: SELECT T1.Name AS Name  T1.DeparmentName AS DeparmentName  T2.Value AS Value FROM [CRMS].[dbo].Table1 AS T1 INNER JOIN [ERP].[dbo].[Table2] T2 ON T1.id = T2.id Assign the result to a dataset ds=Query and gridview1.datasurce=ds; gridview1.databind(); hope this will resolve ur problem