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
What is view state management in asp net?
What are the best practices to follow to secure connection strings in an ASP.NET web application?
Who generates session id?
Explain the difference between an exe and a dll?
What are the advantages of passport authentication?
Are cookies stored on server or client?
Is asp.net outdated?
What is the used of "ispostback" property?
Describe in brief .net framework and its components.
Can you explain one critical mapping? Performance issue which one is better?
What is the server of asp.net?
What is a query string in a url?
Explain how is the asp.net mvc architecture different from others? : asp.net mvc
What are the advantages and disadvantages of Using Cookies?
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?