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

Why we use asp.net for website development?

855

---

What are the different types of events are occured when a client requests an ASP.NET page from IIS server?

1051

---

Are xaml file compiled or built on runtime?

916

---

Is data edited in the Repeater control?

990

---

What are themes and skins in 2.0, explain usage scenario?

895

---

What is the used of "ispostback" property?

1032

---

How do I create a web form?

969

---

What is validation in asp.net?

1008

---

Explain why datareader is useful?

934

---

What are the types of caching in asp.net?

997

---

Why we use dbms for projects? Why don’t we save any application data in separate files instead of dbms?

960

---

Explain server-side scripting?

996

---

Explain the difference between the web config and machine config.

975

---

Can you dynamically assign a Master Page?

936

---

How to unit test Web API?

1157

---