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 cookies cache and session?

0 Answers  

---

How Can assign alias name for ASP.NET Web API Action?

0 Answers  

---

What is the difference between “Web.config” and “Machine.Config”?

0 Answers  

---

Suppose you want a certain ASP.NET function executed on MouseOver overa certain button. Where do you add an event handler?

3 Answers   Visual Soft,

---

How do I send an email message from my ASP.NET page?

0 Answers  

---

What are session state modes in asp.net?

0 Answers  

---

How can u sort strings in array where strings are passed to method as arguments.

3 Answers   CTS, Syncfusion,

---

Can a master page inherit another master page?

13 Answers   Emphasis, IBM, NIIT, Sebiz Square,

---

Explain the difference between debug.write and trace.write?

0 Answers  

---

What is difference between response.redirect and server.transfer ?

2 Answers   Kalinga Software, Satyam,

---

Demonstrate Render and PreRender?

0 Answers   QuestPond,

---

suppose we have two object;obj1 and obj2 can we assign obj2 to one1; and if yes; then after assigning suppose we delete obj2 then obj1 will retain obj2 value or not.

3 Answers  

---