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 various ways of securing a web site that could prevent from hacking etc ?

1 Answers  

---

When maintaining session through sql server, what is the impact of read and write operation on session objects?

0 Answers  

---

In Data grid the question is below quantity price total these are 3 fields available in data grid if you enter quantity the total has to update automatically.Price field is already filled completely

0 Answers   Quest,

---

Why session management is required?

0 Answers  

---

How to transpose rows into columns and columns into rows in a multi-dimensional array ?

1 Answers   Microsoft,

---

What is a postback in asp net?

0 Answers  

---

Explain how inline and code behind is used differently ?

1 Answers   Siebel,

---

WHAT IS THE SEQUENCE IN WHICH ASP.NET EVENTS IS PROCEED?

4 Answers  

---

What is the use of web.config? Difference between machine.config and Web.config?

5 Answers  

---

What is the difference between WindowsDefaultLocation and WindowsDefaultBounds?

0 Answers   BirlaSoft,

---

what is the difference between server.Transfer and response.redirect in .net

1 Answers  

---

What is asp.net and how it works?

0 Answers  

---