Welcome to the Webmaster Forum.
Results 1 to 5 of 5
  1. #1
    Senior Member
    Join Date
    Jan 2014
    Location
    Banglore
    Posts
    289

    What is difference between dataset and data reader ?

    The major difference is that dataset and datareader:-
    Dataset can retain content while datareader don’t persist content.
    Dataset is a disconnected architecture while datareader is a connected Datareader Provides read-only and forward-only access to data.

  2. #2
    Senior Member
    Join Date
    Jan 2016
    Location
    Mumbai
    Posts
    148

    Re: What is difference between dataset and data reader ?

    DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader.
    DataSet is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of DataTables and relations between tables. It is used to hold multiple tables with data. You can select data form tables, create views based on table and ask child rows over relations. Also DataSet provides you with rich features like saving data as XML and loading XML data.


    Bulkmailstack

  3. #3
    Senior Member
    Join Date
    Jan 2016
    Location
    Mumbai
    Posts
    566

    Re: What is difference between dataset and data reader ?

    The DataSet class in ADO.Net operates in an entirely disconnected nature, while DataReader is a connection oriented service.

    Proxiesforrent

  4. #4
    Senior Member
    Join Date
    Oct 2016
    Posts
    158

    Re: What is difference between dataset and data reader ?

    DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader.
    DataSet is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of DataTables and relations between tables. It is used to hold multiple tables with data. You can select data form tables, create views based on table and ask child rows over relations. Also DataSet provides you with rich features like saving data as XML and loading XML data.

  5. #5
    Senior Member
    Join Date
    Jan 2016
    Location
    Mumbai
    Posts
    519

    Re: What is difference between dataset and data reader ?

    Very informative post thanks for sharing.

 

 

Similar Threads

  1. data php
    By jameswoods11x in forum Coding & Programming
    Replies: 0
    Last Post: 09-11-2013, 04:05 AM
  2. retrieve data?
    By preetisoft2 in forum PHP
    Replies: 0
    Last Post: 05-15-2013, 01:40 AM
  3. Google Reader Retired
    By Tara in forum Technology Forum
    Replies: 0
    Last Post: 03-14-2013, 07:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Back to top

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178