DisConnected Architecture in ADO.Net

DisConnected Architecture in ADO.Net using stored procedure
-----------------------------------------------------------------------
string sqlConstring = System.Configuration.ConfigurationManager.AppSettings["SqlConnectionString"];
            SqlConnection Con = new SqlConnection();
            Con.ConnectionString = sqlConstring;
            SqlCommand cmd = new SqlCommand();
            cmd = Con.CreateCommand();
           
            cmd.CommandText = "RFID_GET_RFID_IssueDetails";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Admn_No", "");
            cmd.Parameters.AddWithValue("@Status", "Full");
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds =new DataSet();
            da.Fill(ds);
         
            return ds.Tables[0];


DisConnected Architecture in ADO.Net using string query

 string sqlCon = System.Configuration.ConfigurationManager.AppSettings["SqlConnectionString"];
            SqlConnection Con = new SqlConnection(sqlCon);
            SqlDataAdapter da = new SqlDataAdapter("Select * from RFID_ISSUE_DETAILS", Con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];