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 |
What is the difference between cache and cookies?
What are the security types in ASP/ASP.NET? Different Authentication modes?
Is asp.net core faster?
How does SQL Server session state works
Where is cookie used in asp.net?
Explain the difference between the web config and machine config.
Why do I get error message "could not load type" whenever I browse to my asp.net web site?
What is the main differences between asp and asp.net?
In order to bind the data from a data source to the Repeater control what property is set and what method must you call in your code,?
What are the new login controls in asp.net 2.0?
What are the advantages of asp.net mvc framework? : asp.net mvc
How do you do exception management