How to merge 2 tables fields in DataTable in asp.net

Answer Posted / prakash

You Can Write Query :

select (databasename).(owner).(tablename1).
(datafield),select (databasename).(owner).(tablename2).
(datafield) from (databasename).(owner).(tablename1),
(databasename).(owner).(tablename2)


Example:select
LSKGROUP.dbo.addsites.state,LSKGROUP.dbo.employee.empname
from LSKGROUP.dbo.addsites,LSKGROUP.dbo.employee

and then fill the values to new dataset table.

Remember:

if database also differ put databse's name accordingly




Good Luck.....

Is This Answer Correct ?    13 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is view state management in asp net?

459


What are the best practices to follow to secure connection strings in an ASP.NET web application?

548


Who generates session id?

483


Explain the difference between an exe and a dll?

521


What are the advantages of passport authentication?

501






Are cookies stored on server or client?

496


Is asp.net outdated?

520


What is the used of "ispostback" property?

556


Describe in brief .net framework and its components.

538


Can you explain one critical mapping? Performance issue which one is better?

459


What is the server of asp.net?

498


What is a query string in a url?

531


Explain how is the asp.net mvc architecture different from others? : asp.net mvc

494


What are the advantages and disadvantages of Using Cookies?

510


If I have more than one version of one assemblies, then how will I use old version (how/where to specify version number?) In my application?

513