DISSUE DATE ONE YEAR ADDING

why you have declared DateTime selects; is a datetime

what exactly you wanted to do?

Regards,
Iftikar

pis Ans

Alter PROCEDURE sp_fillng
(
@vScheme varchar(50),
@dDue_Date datetime,
@selects varchar(50)
)
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 dDue_Date=@selects+365 and vStatus='N'

end
***************************************
DateTime selects;
string vScheme;

private void button1_Click(object sender, EventArgs e)
{

if (cmbscheme.Text == "All")
{
selects =All;//The name 'All' does not exist in the current context
}
DataTable dt = new DataTable();
dt = objLoanEntryBL.fnfillingdueregister(vScheme, selects);
dataGridView1.DataSource = dt;
}

Hi,
        Not clear about your query. Please provide more details.

Regards,
Iftikar