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
How to rename a table using sql queries?
What is the use of response redirect in asp.net?
What are the types of validation in asp net?
Any disadvantages in Dataset and in reflection ?
Explain Areas in MVC?
What is a web farm?
What are the steps involved to fill a dataset?
What is autopost?
What is difference between session and cookies?
What is autopostback in asp net?
Why do we need Sessions?
What are the advantages of using session?
How many types of validation are there?
What is smpte vc-1?
What is state management techniques in asp.net?