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

What is the current version of asp.net?

941

---

Can we create a multiple user simultaneously ?

1050

---

Which ASP.NET configuration options are supported in the ASP.NET implementation on the shared web hosting platform?

1071

---

How do you handle server controls?

1084

---

What is the difference between cache and cookies?

953

---

How would you turn off cookies on one page of your website?

899

---

How dataadapter.fill works?

981

---

Why session management is required?

951

---

What is difference between URL and URI?

1047

---

How to register exception filter globally?

963

---

What is comparevalidator?

912

---

Where code pages are used?

1137

---

How can we inherit a static member?

1012

---

What is the difference between GridView and Repeater controls in ASP.NET?

1026

---

What is master page in dtp?

939

---