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 is ashx file in asp.net?

1066

---

Why web api is better than wcf?

1111

---

How do you remove duplicates without using remove duplicate stage?

1059

---

What is applicatio domain?

1008

---

How can u deifne the benefits and limitation of using Viewstate for state management?

1139

---

How can you enable impersonation in the web.config file?

1153

---

how to implement some securty aspect in our application i.e 1.cookie poisioning. 2.data encryption. 3.forcefull browsing 4.sql/code injection 5.securing web app by using web services ........my question is how to implement these thing in our application is this done by hard coding or by help of some tool

2105

---

When should I use server transfer and response redirect?

989

---

if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....

2131

---

What is view state and how it works in asp net?

992

---

Explain about Automatic resource management?

1069

---

How does u get record no from 5 to 15 from a dataset of 100 records?

954

---

How do you use viewstate?

1010

---

Why is global asax is used?

1033

---

Define asp.net caching?

1173

---