title: Cannot implicitly convert type 'System.Data.SqlClient.SqlDataReader' to 'System.Data.DataSet'
body: <p>I'm doing a project in C# using 3 a tier architecture. I wrote the code to sort the records from SQL. But it doesn't return any values.</p>
  
  <p>Query:</p>
  
  <pre><code>BEGIN
     SELECT 
         Bank_Code, Bank_Name, Bank_ShortName, CreditCard_Commission_Percent 
     FROM
         BankMaster 
     WHERE 
         bank_name LIKE '% + @BankName + %'
  END
  </code></pre>
  
  <p>Calling the query - BOL :</p>
  
  <pre><code>public DataSet SortBank()
  {
      try
      {
          SqlCommand cmd = new SqlCommand("SortBankMaster", dal.con);
          cmd.Parameters.Add("@BankName", SqlDbType.NVarChar).Value = Bank_Name;
          cmd.CommandType = CommandType.StoredProcedure;
  
          return cmd.ExecuteReader();                        // Error
      }
      catch (Exception ex)
      {
          throw ex;
      }
  }
  </code></pre>
  
  <p>UI :</p>
  
  <pre><code>public void FillSortBank()
  {
      try
      {
          DataSet ds = new DataSet();
          bol.Bank_Name = txtsort.Text;
          ds = bol.SortBank();
          DGVBank.DataSource = ds.Tables[0];
      }
      catch (Exception ex)
      {
          MessageBox.Show(ex.Message);
      }
  }
  </code></pre>
  
  <p>This is my DAL :</p>
  
  <pre><code>public DataSet DBread(String Squery)
  {
          DataSet DSResult = new DataSet();
  
          try
          {
              if (con.State == ConnectionState.Closed)
              {
                  con.Open();
              }
  
              da = new SqlDataAdapter(Squery, con);
  
              da.Fill(DSResult);
  
              Console.WriteLine();
  
              return DSResult;
          }
          catch (Exception ex)
          {
              //UnhandledExceptionHandler();
              //return e.ToString();
              throw ex;
              //return DSResult;
          }
      }
  </code></pre>
  
  <p>Thanks to all....</p>