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 session ?how sessions are handeled in application? write the clauses of sql server in their order.

3 Answers   Olive Tech,

what is clr .

1 Answers   Patni,

What is difference between Server.Transfer and Response.Redirect in ASP.NET?

0 Answers   Sans Pareil IT Services,

What is virtual directory in asp.net?

0 Answers  

Give an example of what might be best suited to place in the application_start and session_start subroutines?

0 Answers  

Name two properties common in every validation control?

1 Answers  

Explain how cookies work.

0 Answers  

What is a postback ispostback and autopostback in asp net?

0 Answers  

How can you register a custom server control to a web page?

0 Answers  

what are the files used in asp .net

1 Answers  

What methods are fired during the page load? Init()

0 Answers  

Why mvc is faster than asp.net? : Asp.Net MVC

0 Answers