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
How is mvc different from asp.net? : Asp.Net MVC
Explain the difference between value type and reference type?
What is enableviewstate in asp net?
Explain what is postback in asp. Net?
What are the three parts of an http response?
What is postback and autopostback in asp.net?
how to debug web services on consumer side?
Explain cashing in asp.net.
How can we identify that the Page is Post Back?
What is difference between ispostback and autopostback in asp net?
What is asp.net ajax?
Define the steps to set up validation control.
How can we communicate with each server in N-tier Architecture? and what are the methods?
Define secured sockets layer.
What are html helpers in asp.net?