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

Asp.net - How to find last error which occurred?

1 Answers   Abacus,

---

Explain what are the advantages of asp.net mvc framework? : asp.net mvc

0 Answers  

---

How to retrieve the information from datatable citywise in c#?

2 Answers   HCL,

---

How can you access the properties and controls of master pages from content pages?

0 Answers  

---

Can you use c# without .net?

0 Answers  

---

Master Page

1 Answers   Syntel,

---

What is a proxy in web service?

0 Answers  

---

What is the difference between visual basic and asp.net?

0 Answers  

---

what is webservices. howit is use in our project .

1 Answers   Patni,

---

Explain about asp.net 2.0 themes?

0 Answers  

---

How do you declare static variable? What is its lifetime?

0 Answers  

---

i have one gridview contains edititemtemplate(which contains update and cancel buttons) and i have one item template (contains edit button) i want the code for update and cancelbuttons in edit item template and i want the code for edit button in itemtemplate. please help me

4 Answers  

---