Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Differentiate between file-based dependency and key-based dependency.

939


How can we make sure that Web API returns JSON data only?

1025


What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?

1132


Does google crawl redirects?

965


What is the use of session state and application state and difference between them?

921


What are the disadvantages of using session?

1107


Which data type does the rangevalidator control support?

949


What is razor? : asp.net mvc

1041


What is the behavior of a Web browser when it receives an invalid element?

1115


What is the difference between mvc and asp.net? : Asp.Net MVC

1022


Securitywise What are the Enhancements in 2.0?

1940


Explain form level validation and field level validation?

1015


Define application state variable and session state variable?

999


What is asp.net futures?

1098


What is the difference between typeof() vs gettype()?

1110