K Kevin Spencer Sep 7, 2004 #2 Why exactly one should use SqlDataAdapter? One should use it only because it is needed for what one is doing. -- HTH, Kevin Spencer ..Net Developer Microsoft MVP Big things are made up of lots of little things.
Why exactly one should use SqlDataAdapter? One should use it only because it is needed for what one is doing. -- HTH, Kevin Spencer ..Net Developer Microsoft MVP Big things are made up of lots of little things.
C Carl Prothman [MVP] Sep 7, 2004 #3 Ashish said: Why exactly one should use SqlDataAdapter? Click to expand... To fill a DataTable (or DataSet which contains a DataTable). And to apply the changes in a DataTable back to the data source. Remember, the DataSet / DataTable are disconnected. Whereas the SqlCommand / SqlDataReader are connected. http://msdn.microsoft.com/library/e...stemDataSqlClientSqlDataAdapterClassTopic.asp - See the Remarks section. -- Thanks, Carl Prothman Microsoft ASP.NET MVP Hire top-notch developers at http://www.able-consulting.com
Ashish said: Why exactly one should use SqlDataAdapter? Click to expand... To fill a DataTable (or DataSet which contains a DataTable). And to apply the changes in a DataTable back to the data source. Remember, the DataSet / DataTable are disconnected. Whereas the SqlCommand / SqlDataReader are connected. http://msdn.microsoft.com/library/e...stemDataSqlClientSqlDataAdapterClassTopic.asp - See the Remarks section. -- Thanks, Carl Prothman Microsoft ASP.NET MVP Hire top-notch developers at http://www.able-consulting.com
N Naveen K Kohli Sep 7, 2004 #4 Advantage is that it does not use OLE DB to transport the data back and forth. It uses the SQL Server native protocol for that. So it is faster.
Advantage is that it does not use OLE DB to transport the data back and forth. It uses the SQL Server native protocol for that. So it is faster.
