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 caching,session? when & what is used mostly in which situtations, how they r implemented in real time? tell with example?

1 Answers   Satyam,

---

Can we add code files of different languages in app_code folder?

0 Answers  

---

Singleton Design pattern?How do you achieve it?

3 Answers   Microsoft,

---

What is MSIL?

4 Answers  

---

Explain the difference between response.redirect vs server.transfer

0 Answers  

---

How to migrate from sqlserver 2005 to sql server 2000 (every one know reverse process of that )

2 Answers   Cap Gemini,

---

what is webservices. howit is use in our project .

1 Answers   Patni,

---

Where can we set the specific variables for a application and Session objects ?

2 Answers   Siebel,

---

Your manager has asked you to describe what you would use application variables for. What statement best describes the use of application variables? a) Application Variables are used to keep state for each connected user. b) Application Variables are used to keep state for the web site c) Application Variables are used to keep state for the application on the server d) Application Variables are used to keep state for all applications objects in the web site.

1 Answers   Syntax Softtech,

---

How do you design a website with multilingual support in ASP.NET ?

0 Answers   MCN Solutions,

---

What is the function of the CustomValidator? a) It allows for custom C# client-side code to validate entries in a control. b) It allows for a custom mixture of validator controls to use one central control for the display of messages. c) It uses scripted client-side code to validate the entry in a control. d) It uses server-side code to validate the entry in a control.

4 Answers   ABC, Syntax Softtech, TCS,

---

Describe a diffgram ? Write any one use of that?

3 Answers   Siebel,

---