DISSUE DATE ONE YEAR ADDING

Question

In this sitvation query crating mistke form in combobox display any type scheme display but scheme dissue (date 5-8-13)+one year adding how can creating procedure

Iftikar Hussain · Answer

why you have declared DateTime selects; is a datetime what exactly you wanted to do? Regards Iftikar

JAYESH AJ · Answer

pis Ans

JAYESH AJ · Answer

Alter PROCEDURE sp_fillng ( @vScheme varchar(50) @dDue_Date datetime @selects varchar(50) ) AS begin select vLoan_No As LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_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; }

Iftikar Hussain · Answer

Hi Not clear about your query. Please provide more details. Regards Iftikar