Mssql-sqldataadapter connecting databases to improve performance usage

SqlDataAdapter is used with SqlConnection and SqlCommand to improve performance when connecting to a SQL Server database.

This implementation of SqlDataAdapter automatically turns SqlConnection on and off (if it is not already open).  It is useful in applications where the Fill method must be called for two or more SqlDataAdapter objects . if SqlConnection is already open, you must explicitly call Close or Dispose to close it.

private static DataSet Selectrows (DataSet dataset,string connectionstring,string queryString) {    using ( SqlConnection connection = new SqlConnection (connectionString))    {        SqlDataAdapter adapter = new SqlDataAdapter ( );        Adapter. SelectCommand = new SqlCommand (queryString, connection);        Adapter. Fill (dataset);        return dataset;}    }

　　

Mssql-sqldataadapter connecting databases to improve performance usage