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 are validator? Name the validation controls in asp.net? How do you disable them? Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?
How long do session variables last?
code for "For every 5days system has to create 1text file with the corresponding date and it has to store in c-drive" by using web applications
Explain the use of errorprovider control in .net?
How do you declare static variable? What is its lifetime?
Define common type system?
Define cookie.
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
What is the difference between equals() and == in c#?
What is session start?
Whats the difference between registerclientscriptblock, registerclientscriptinclude and registerclientscriptresource?
What are standard controls?
What is custom attribute?
What does it mean your session has timed out?
What is the difference between table and query?