what is ADO.net DataSet


Hello Guys !
                         many people have the problem that what is ado.net Dataset. so this bolg very help full for you...
just read carefully...nd enjoy this blog..... :) 

The ADO.NET DataSet contains DataTableCollection and their DataRelationCollection . It represents a collection of data retrieved from the Data Source. We can use Dataset in combination with DataAdapter Class . The DataSet object offers a disconnected data source architecture. The Dataset can work with the data without knowing the source of the data coming from. That is , the Dataset can work with a disconnected mode from its Data Source . It gives a better advantage over DataReader , because the DataReader is working only with the connection oriented Data Sources.



The Dataset contains the copy of the data we requested. The Dataset contains more than one Table at a time. We can set upData Relations between these tables within the DataSet. The data set may comprise data for one or more members, corresponding to the number of rows.





Data Source


The DataAdapter Object allows us to populate DataTables in a DataSet. We can use Fill method of the DataAdapter for populating data in a Dataset. The DataSet can be filled either from a data source or dynamically. A DataSet can be saved to an XML file and then loaded back into memory very easily. A DataSet can read and write data and schema as XMLdocuments. The data and schema can then be transported across HTTP and used by any application, on any platform that is XML-enabled.



I hope you all have clear that particular problem with this bolg.......
so guys. enjoy the ADO.net....................


Comments

Post a Comment

Popular posts from this blog

i am writing With sad hearts some problems with my windows phone samsung omnia w

Last month i bought a Windows phone Samsung Omnia W.... After a few days i realise the some problem with it...... WP7.5 (Mango) is already in its second generation but it still has many restrictions, limitations and serious usability issues. This is a list of its shortcomings as compared with other smartphone OS in the market. We are not comparing special features or abilities but those which have become the norm for all smartphones and even dumb phones. An Android, Symbian or MeeGo phone would have almost none of these shortcomings. An iphone share some restrictions with WP7.5 but is still miles ahead. Even the Nokia N9 running the first generation MeeGo OS is far better with none of the disastrous issues which impact on the sheer usability of the phone. OS LIMITATIONS 1. No true multitasking - apps are frozen in the background. 2. No Divx/Xvid video codec support. Zune will convert with loss of quality. 3. No mass storage mode. 4. No micro-SD card support. 5. Only suppor...
Read more

Delete Duplicate Records in DataBase sql server

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%)  from tblname   group by b.coloumnname) Hope it helped you........ plz comments.........
Read more