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

Explain the difference between inline and code behind - which is best in?

1056

---

What is asp.net localization?

1029

---

What are the advantages of using session?

941

---

Why session is necessary in web application?

1010

---

how to debug web services on consumer side?

1109

---

What do you understand by aggregate dependency?

1139

---

What is smpte vc-1?

1087

---

What is active web page?

995

---

How to make paging concepts in datagrid in ASP.NET?

1069

---

What is a page life cycle?

1098

---

How will you do Redo and Undo in a TextControl?

1252

---

What is a SESSION and APPLICATION object?

1091

---

What are the different properties of server control that exists?

1215

---

What is the asp.net mvc folder conventions? : asp.net mvc

957

---

Explain the difference between dataset and datareader.

1067

---