display on grid from combox selected values(add collection)

 private void button1_Click(object sender, EventArgs e)
        {
            decimal start;
            decimal last;

            if (comboBox1.SelectedText == "0")
            {
                start = 0;
                last = 5000;

            }
          

            else if (comboBox1.SelectedText == "1")
             {
                 start = 5000;
                 last = 10000;

             }

            else if (comboBox1.SelectedText == "2")
            {
                start = 10000;
                last = 25000;

            }
sp*

Alter PROCEDURE sp_loans            
 (           
 @dcLoan_Amt decimal(18,2)           
            
 )           
AS           
 begin           
            
-- declare @sqlQuery nvarchar(4000);           
-- set @sqlQuery='              
             
     
     
 select  vLoan_No as LoanNumber ,vParty_Id as CustomerName,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster           
where dcLoan_Amt=@dcLoan_Amt      
     
     
--     
-- select  vLoan_No as LoanNumber ,vParty_Id as CustomerName,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster           
--where dcLoan_Amt  between 5000 and  10000  
     
     
--  '           
--   +@vScheme           
--              
-- exec sp_executesql @sqlQuery             
--            
--           
-- RETURN              
end 




BL
***

    public DataTable fnLoanAmountDisplay(decimal dcLoan_Amt)
      {
            DataTable dt = new DataTable();
            dt = objLoanEntryDL.fnLoanAmountDisplay(dcLoan_Amt);
            return dt;
        }


DL
*****

 public DataTable fnLoanAmountDisplay(decimal dcLoan_Amt)
        {
            Connection con = new Connection();
            con.OpenConnection();
            SqlDataAdapter da = new SqlDataAdapter();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con.conSql;
            cmd.CommandText = "sp_loans ";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@dcLoan_Amt", dcLoan_Amt);
            DataTable dt = new DataTable();
            da.SelectCommand = cmd;
            da.Fill(dt);
            con.CloseConnection();
            return dt;


        }