Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

How to create a SqlDataAdapter in ADO.Net?
SqlDataAdapter holds the SQL commands and connection object for reading and writing data.  It initializes with a SQL select statement and connection object:
SqlDataAdapter daStudent = new SqlDataAdapter(
    "select StudentID, CollegeName from Students", conn);
The SQL select statement specifies what data will be read into a DataSet.   
The connection object, conn, should have already been instantiated, but not opened. 
SqlCommandBuilder is instantiated with a single constructor parameter of the SqlDataAdapter, daStudent, instance.
SqlCommandBuilder cmdBldr = new SqlCommandBuilder(daStudent);
SqlCommandBuilder will read the SQL select statement (specified when the SqlDataAdapter was instantiated), infer the insert, update, and delete commands.
Posted By: Name:Rajesh Kr URL: How to create a SqlDataAdapter in ADO.Net?