title: Direct method from Stored Procedure command text to DataSet?
body: <pre><code> private void Data_Load(object sender, EventArgs e)
          {
              CommonClass_RunProcesses Commoncls = new CommonClass_RunProcesses();
              DataSet ds = new DataSet();
              ds = Commoncls.ExecuteSQL("SELECT Sales = SUM(Sales) from Sales_1 ", 17);
              if (ds != null)
              {
                  if (ds.Tables[0].Rows.Count &gt; 0)
                  {
                      grdData_Load.DataSource = ds.Tables[0];
                      grdData_Load.AllowUserToAddRows = false;
                      grdData_Load.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
  
                  }
  </code></pre>
  
  <p>How can give StoredProc instead of SQL COMMAND all the time.
  I need to give SP name usp_SalesofEST
  ????</p>