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 server redirect?

0 Answers  

---

Explain different authentication modes in asp.net?

0 Answers  

---

Explain difference betn dataset and recordset?

0 Answers  

---

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

3 Answers   Siebel,

---

What is asp.net globalization?

0 Answers  

---

What are the disadvantages of view state?

0 Answers  

---

What’s the use of “GLOBAL.ASAX” file?

0 Answers  

---

i want the asp.net technical questions and answeres

0 Answers  

---

What is the lifespan for items stored in ViewState?

4 Answers   Siebel Systems,

---

In my code i have 3 tables,i have to insert 3 tables data using single insert query so that i wrote transations in a sp.but what my problem is,in those 3 tables i have to include my empId from another table.when i'm passing values im getting error at this EmpId. how can i solve this error to execute insert query? plesae tell me the solution...

1 Answers  

---

What is query string in asp.net?

0 Answers  

---

What is the exact purpose of http handlers?

0 Answers  

---