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


Please Help Members By Posting Answers For Below Questions

what is the difference between response.write() and response.output.write()?

702


Why we use content place holder in asp.net?

505


What are the new features implemented in ASP.NET?

611


What is viewstate? What does the “enableviewstate” property do?

526


What are the modes of updation in an updatepanel?

555






What is difference between view state and session state?

481


WSDL means?

672


5. What three Specific Job Positions do you target from Swatz Oils GROUP U.K?

1773


What are the advantages of asp.net mvc framework? : asp.net mvc

544


How to find last error which occurred?

540


How many types of server controls do we have?Also explain differance between them taking an example of ASP.NET?

2366


Explain diff. Between friend and protected friend?

500


how to include timer or counting time to display next page in asp.net

1605


Explain how do you validate the controls in an asp .net page?

523


Explain about the Class view window?

594