how can we display records in single datagrid using two
datasets in different place?

Answers were Sorted based on User's Feedback



how can we display records in single datagrid using two datasets in different place?..

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

Is This Answer Correct ?    4 Yes 1 No

how can we display records in single datagrid using two datasets in different place?..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

How to write unmanaged code and how to identify whether the code is managed / unmanaged ?

2 Answers   Accenture, BirlaSoft, Cogtest,


Explain about Automatic resource management?

0 Answers  


How you can access the values from the Repeater control in ASP.NET?

0 Answers  


What is a swagger in web api?

0 Answers  


What is the concept of view state in asp.net?

0 Answers  


What is SOAP, UDDI and WSDL ?

2 Answers   Infosys, Network, TCS, Wipro,


In the Repeater control which way you can edit?

0 Answers   Siebel,


What is different authentication mechanisms used in ASP.NET?

0 Answers   Amdocs,


How would you get asp.net running in apache web servers?

0 Answers  


What is a multilingual website?

0 Answers  


Is it true that a Web service must be written in .NET or not?

0 Answers   Siebel,


what is difference between java and .net

11 Answers   Base2 Infotech, Karur Vysya Bank KVB, TATA AIG, TCC,


Categories