Answer / senthil kumar

you can use the query to merge the fields.that query will
be executed through the sqlcommand.

Answer / ankur sehgal

Consider a dataset(ds) having two datatables or we can say
that it contains data from two tables..

System.Data.DataTable dt = new DataTable();
dt.Columns.Add("Field1", typeof(string));
dt.Columns.Add("Field2", typeof(string));

if(ds.Tables[0].Rows.Count > 0)
{
foreach(DataRow dr in ds.Tables[0].Rows)
{
DrNew = dt.NewRow();
DrNew[0] = dr["Field1"].ToString();
}
}

if(ds.Tables[1].Rows.Count > 0)
{
foreach(DataRow dr in ds.Tables[1].Rows)
{
DrNew = dt.NewRow();
DrNew[0] = dr["Field2"].ToString();
}
}
dt.AcceptChanges();

Answer / sunil kumar

DataTable dt1 = retDT("select col1,col2 from Table1");
DataTable dt2 = retDT("select col3,col4 from Table2");
dt1.Merge(dt2);

retDT is a funtion to return datatable based on the query.

The output will be like below
if you check the dt1 content then the output will be

col1 col2 col3 col4
1 2 3 4

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

Answer / abc

DataTable dt1 = retDT("select col1,col2 from Table1");
DataTable dt2 = retDT("select col3,col4 from Table2");
dt1.Merge(dt2);

retDT is a funtion to return datatable based on the query.

The output will be like below
if you check the dt1 content then the output will be

Answer / k

get data from first table and add it as a column in another
table and do the same way to retrive the second data from
other table.Add it to third column..

What is the difference between abstract class vs interface? Can give me the real time examples?

0 Answers  

What are the different types of proxy patterns?

0 Answers  

If you have to replicate a set of controls(UI) across a number of web pages, what will you do

1 Answers  

What is postback pixel?

0 Answers  

Explain login controls.

0 Answers  

Hi, We have a user control that have button Now we use this user control on different aspx pages. We want when we click on the user control button then button behave differently on different page (Dynamacilly).

2 Answers   HCL,

Tell something about state management in asp.net?

3 Answers   Accenture,

What’s the difference between asp.net web forms and asp.net mvc?

0 Answers  

What are the asp.net objects? is it application obects, cache objests etc. or is it state managements, web services etc?

3 Answers   Syntel,

how can i call output parameters from ado.net

3 Answers   TCS,

In which event of the page viewstate is available?

0 Answers  

How would you get asp.net running in apache web servers?

0 Answers