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

What is the difference between ADO and ADO.Net?

1119


Explain what are acid properties?

1052


Explain what is datagrid with an example?

1143


What is data access pattern?

996


Explain the difference between data reader and data adapter?

1009


What is ado net stands for?

1007


Why do we need ado.net?

1020


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

1081


What are the steps to connect to a database?

1069


How to check if the Dataset has records ?

1046


What is the difference between a datareader and a dataset?

1091


What are the features of ado.net?

1107


What is ado circle?

1181


How to aggregating data across related tables?

1094


How can you add or remove rows from the datatable object of dataset?

1069