how can we display records in single datagrid using two
datasets in different place?
Answer Posted / 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 View All Answers
Differentiate between file-based dependency and key-based dependency.
How can we make sure that Web API returns JSON data only?
What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?
Does google crawl redirects?
What is the use of session state and application state and difference between them?
What are the disadvantages of using session?
Which data type does the rangevalidator control support?
What is razor? : asp.net mvc
What is the behavior of a Web browser when it receives an invalid element?
What is the difference between mvc and asp.net? : Asp.Net MVC
Securitywise What are the Enhancements in 2.0?
Explain form level validation and field level validation?
Define application state variable and session state variable?
What is asp.net futures?
What is the difference between typeof() vs gettype()?