how can we display records in single datagrid using two
datasets in different place?
Answers were Sorted based on User's Feedback
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 |
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 |
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?
How you can access the values from the Repeater control in ASP.NET?
What is a swagger in web api?
What is the concept of view state in asp.net?
What is SOAP, UDDI and WSDL ?
2 Answers Infosys, Network, TCS, Wipro,
In the Repeater control which way you can edit?
What is different authentication mechanisms used in ASP.NET?
How would you get asp.net running in apache web servers?
What is a multilingual website?
Is it true that a Web service must be written in .NET or not?
what is difference between java and .net
11 Answers Base2 Infotech, Karur Vysya Bank KVB, TATA AIG, TCC,