Loading

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

magesh manavalan

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
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.
0
venkata saibabu14y ago
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
0