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...

About ado.net components/objects. Usage of data adapters and
tell the steps to retrieve data ?

Answer Posted / kalirajan

ADO.NET Obj:

SqlConnection
SQlcommand
SqlDataReader
SqlDataAdapter
Dataset


Retrieving Data:

SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = new SqlCommand("select * from Tbl", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give an example of a .net application which connects to microsoft access database using ado.net classes.

1151


What is bubbled event can you please explain?

1048


How to load multiple tables into a dataset?

1054


What is difference between ado and other data object?

913


How many major types of connection objects in ADO.NET?

1035


How to pass values into a datatable?

1138


Explain how to create dynamic gridview?

980


Explain executenonquery?

1135


What is data relation?

916


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

1027


What is ado recordset?

994


What is ambient transaction?

947


Why do we use sqldataadapter?

951


What are the different execute methods of Ado.Net?

1025


Define different execute methods of ADO.NET command object ?

1095