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.....

What are the features of asp.net mvc?

1041

---

How to create events for a control?

1056

---

What is the use of service provider?

1085

---

What are directives in asp.net? List down all the important directives.

990

---

What’s the difference between response .redirect and server.transfer?

1036

---

Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?

1038

---

What is asp.net master page?

1037

---

What is cookieless session id explain in brief?

1094

---

What are the new data controls in asp.net 2.0?

1007

---

How about the security in Activex DLL and Activex EXE ?

2314

---

What is viewstate in asp net with example?

1029

---

Explain Authentication mechanism in dotnet

1098

---

What is autopostback true?

1122

---

What is the difference between session object and application object?

1091

---

How can you send an email message from an asp.net web page?

1034

---