Relationship between DataSet and DataAdapter, datasetdataadapter

Relationship between DataSet and DataAdapter, datasetdataadapter

DataSet
Purpose: DataSet and DataAdapter read data.
Q: What is DataAdapter?
A: The DataAdapter object serves as a bridge between DataSet and data.

String strConn = "uid = Account; pwd = password; database = database; server = Server"; // SQL server link string
SqlConnection ConnSql = new SqlConnection (strConn); // instantiate the SQL link class
ConnSql. Open (); // Open the database
String strSQL = "SELECT * FROM table name 1"; // The SQL statement to be executed
SqlDataAdapter da = new SqlDataAdapter (strSQL, ConnSql); // create a DataAdapter data adapter instance
DataSet ds = new DataSet (); // create a DataSet instance
Da. Fill (ds, "Custom virtual table name"); // use the DataAdapter Fill method (Fill) to call the SELECT command
ConnSql. Close (); // Close the database