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();

When working with ASP.Net server controls, it is important to use the right event handlers to capture the event for the application to function properly. What event would you use to capture the selection of a new item in a DropDownList control? a) The Click event. b) The SelectionChanged event. c) The SelectionIndexChanged event. d) The ChangedSelection event.

4 Answers   Syntax Softtech,

---

Differences between “dataset” and “datareader”.

0 Answers  

---

What is the namespace to create thread in .net?

0 Answers  

---

Explain the boxing and unboxing concept in .net?

0 Answers  

---

What is a web server? What are the load limits in it?

0 Answers   Wipro,

---

Can a user browsing my Web site read my Web.config or Global.asax files ?

1 Answers  

---

Can two web application share a session and application variable ?

5 Answers   Satyam, V3 Engineers,

---

Using shadow variable is good or bad for application?

1 Answers   Keane India Ltd,

---

Difference between connected architecture and Dissconnected architecture?

2 Answers  

---

About writting a query and SP which is better ?

5 Answers   Abacus, Satyam,

---

How to Separate background image and front image from original picture....

0 Answers   Sans Pareil IT Services,

---

To call a Web service SOAP which transport protocol you use?

3 Answers   Siebel,

---