Important

hi, im wannt to know what the different bettween sql data reader and sql data adapter

A SqlDataAdapter is used for working with datasets. Basically the concept is that you connect to the db, retrieve the data into a datset and disconnect. WHen you are done modifying the dataset, you connect again and issue the update command to send the changes back to the server. Most of the time useful for when you need to use databinding or when you have a large amount of data.

A SqlDataReader reads the data sequentially records by record and must have an open connection to work. It is useful for reading small amounts of data. Much quicker than filling a dataset if you have a small amount of data you need to read or retrieve.