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 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; }

Iftikar Hussain · Answer

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

DISSUE DATE ONE YEAR ADDING

Answers (4)