Answer / ruby

we can do it using merge method of dataset.
but for that bot the tables must have same no. of columns , same fields and their respective datatypes.

also both the data table's name must be same("Table1" of both the datasets)

Sub BindGrid()
Dim myConnection as New SqlConnection (strConn)

Dim DS1 As DataSet
Dim DS1 As DataSet
Dim MyCommand As SqlDataAdapter

MyCommand = new SqlDataAdapter("exec s_get_table1", MyConnection)
DS1 = new DataSet()
MyCommand.Fill(DS1, "Table1")

MyCommand = new SqlDataAdapter("exec s_get_table2", MyConnection)
DS2 = new DataSet()
MyCommand.Fill(DS2, "Table1")
// Then using MERGE function of dataset we can merge both the datasets like

ds1.merge(ds2)
//binding with grid

MyDataGrid.DataSource=DS1.tables(0).DefaultView
MyDataGrid.DataBind()
End Sub

Answer / nitin jadav

OracleConnection cn = new OracleConnection("user
id=scott;password=tiger;data source=ganesh1");
OracleDataAdapter da1 = new
OracleDataAdapter("select * from table1", cn);

DataSet ds = new DataSet();
da1.Fill(ds, "temp");

OracleDataAdapter da2 = new
OracleDataAdapter("select * from table2", cn);
DataSet ds1 = new DataSet();
da2.Fill(ds1, "temp");

ds.Merge(ds1);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
label1.Text = ds.Tables[0].Rows.Count.ToString();

What is difference between masterpage and user control, what is the objective of master page when we had user control in .NET 1.1 version

3 Answers   DELL, Soham,

---

What are type/key pairs in client script registration? Can there be 2 scripts with the same type/key pair name?

0 Answers  

---

What is & in a url?

0 Answers  

---

About Usage of server variables ?

2 Answers   Cognizant, CTS,

---

what is publisher?

0 Answers   Microsoft,

---

Explain the difference between asp and asp.net?

0 Answers  

---

What are sessions used for?

0 Answers  

---

Can a master page have more than one contentplaceholder?

0 Answers  

---

How do we assign page-specific attributes?

0 Answers  

---

17. If I?m developing an application that must accommodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing) what would be the best approach to maintain login-in state for the users?

1 Answers  

---

What is is post back property in asp net?

0 Answers  

---

Why do you use the app_code folder in asp.net?

0 Answers  

---