Query analizer(8-2013)

pls ans sir

I HAVE THREE SCHEMES(SCHEMEA,SCHEMEB,SCHEMEC)IN COMBO BOX.WHEN I SELECT A SCHEME ,THEN CLICK SHOW BUTTON.I HAVE TO  GET DISPALY IN GRID LOAN NUMBER,CUSTOMER NAME,LOAN ISSUE DATE(MEANS SHOULD DISPLAY,LOAN PENDING DETAILS OF CUSTOMERS AFTER CLOSING DATE)CLOSING DATE MEANS 365 DAYS.THAT MEANS THE CUSTOMER WHO ARE STILL CONTINUING THIER LOAN AFTER 365 DAYS ONLY...TODAY IS THE 'CURRENT DATE'.SHOULD 'CHECK DATE', BASED ON CURRENT DATE.....MAY GET CODE IN  3 TIER...SP ALSO WE NEED...

string selects="";
DateTime dIssue_Date=new DateTime();
string vScheme="";
DateTime datet=new DateTime();
private void button1_Click(object sender, EventArgs e)
{

if (cmbscheme.Text == "SCHEME A")
{
selects = "SCHEME A";
}
DateTime datet = DateTime.Now;
DataTable dt = new DataTable();
dt = objLoanEntryDL.fnfillingdueregister(selects, dIssue_Date, datet, vScheme);
dataGridView1.DataSource = dt;
}

bl******************
public DataTable fnfillingdueregister(string selects, DateTime dIssue_Date, DateTime datet, string vScheme)
{

DataTable dt = new DataTable();
dt = objLoanEntryDL.fnfillingdueregister(selects, dIssue_Date, datet, vScheme);
return dt;

}

dl***************

 Connection con = new Connection();
            con.OpenConnection();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con.conSql;
            cmd.CommandText = "sp_fillng ";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@selects", selects);
            cmd.Parameters.AddWithValue("@dIssue_Date", dIssue_Date);
            cmd.Parameters.AddWithValue("@datet", datet);
            cmd.Parameters.AddWithValue("@vScheme", vScheme);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            con.CloseConnection();
            return dt;
sql*************
Alter PROCEDURE sp_fillng                                 
(              
  @vScheme varchar(50),                            
 @dIssue_Date datetime,                 
 
 @datet datetime('2013-08-8')

              
)                                  
AS                                   
 begin                                      
                                   
                  
                   
select  vLoan_No As LoanNumaber,dIssue_Date As Date,vParty_Id As CustomerName,dcLoan_Amt As LoanAmount,dDue_Date As DueDate from tbl_LoanMaster                          
               
WHERE vScheme=@vScheme and dIssue_Date<=@datet********????????/*****    and vStatus='N'              
         
end