combo add the collection select display grid but amount

form combo and button and grid add****** (PLESE CORECT THE STORE PROCEDURE)


   public partial class frmCustomerDisplay : Form
    {
       
        public frmCustomerDisplay( )
        {
          
            InitializeComponent();
        }

        decimal dcLoan_Amt ;

        LoanEntryBL objLoanEntryBL = new LoanEntryBL();
        private void btnExit_Click(object sender, EventArgs e)
        {
            Close();
        }

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

            if (comboBox1. Text== " 0 - 5000")
            {

                start = 0;
                last = 5000;
            }
            else if (comboBox1.Text == "5000 - 10000")
            {
                start = 5000;
                last = 10000;
            }
            else if (comboBox1.Text == "10000 - 25000")
            {
                start=10000;
                last=25000;
            }
            else if(comboBox1.Text=="25000 - 100000")
            {
                start=25000;
                last=100000;
            }
              
                DataTable dt = new DataTable();
                dt = objLoanEntryBL.fnLoanAmountDisplay(dcLoan_Amt,start,last);
                dataGridView1.DataSource = dt;

                dataGridView1.Columns[0].Width = 80;
                dataGridView1.Columns[1].Width = 280;
                dataGridView1.Columns[2].Width = 71;
                dataGridView1.Columns[3].Width = 148;

        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            fndisplay(dcLoan_Amt, start, last);

        }
         
   
        private void fndisplay(decimal dcLoan_Amt, decimal start, decimal last)
        {
            DataTable dt = new DataTable();
            dt = null;
            dt = objLoanEntryBL.fnLoanAmountDisplay(dcLoan_Amt, start, last);
        }
      
    }

BL**********

    public DataTable fnLoanAmountDisplay(decimal dcLoan_Amt, decimal start, decimal last)
      {
            DataTable dt = new DataTable();
            dt = objLoanEntryDL.fnLoanAmountDisplay(dcLoan_Amt,start,last);
            return dt;
        }
 
DL***********

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


STORE PROCEDURE
********************

Alter PROCEDURE sp_loans              
 (             
 @dcLoan_Amt decimal(18,2)
,             
@start decimal ,
@last decimal     
--      
 )             
AS             
 begin         
 select  vLoan_No as LoanNumber ,vParty_Id as CustomerName,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster             
where  @dcLoan_Amt between @start and  @last
END