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 are the features that make asp.net more used framework? : asp.net mvc

0 Answers  

---

when the user control event occur in ASp page life cycle?

3 Answers   Microsoft,

---

Any alternative to avoid name collisions other then Namespaces?

1 Answers  

---

For Web services where you can browse on the Internet?

1 Answers   Siebel,

---

Please briefly explain the usage of global.asax?

0 Answers  

---

i wand basic interview based questions in asp.net and vb.net

0 Answers   Legio Infotech,

---

Which is better union or union all?

0 Answers  

---

Explain what a diffgram is, and a good use for one?

1 Answers  

---

We Only Know The Total Number Of Feet In The Farmyard. Write A Program that will compute the total number of rabbits and chickens in the farmyard. Assume number of feet in the farmyard are 40. how many rabbits and chickens are?

0 Answers  

---

What are Caching techniques in .NET

0 Answers   Microsoft,

---

What are client activated objects and server activated objects?

0 Answers  

---

What is a reflection?

0 Answers  

---