The 3 type field displasy ,any schme display ,but The any loan creating one scheme select ,the scheme select dissuedate creating and partiqular duedate creating...... scheme A select loan creating (set perioddays 250)(scheme B is period days 100) .The any type scheme select the combobox and one year closing people display the query
example: ********Alter PROCEDURE sp_fillng
(
@vScheme varchar (50),
@vStatus varchar(50)
)
AS
begin
select vLoan_No as LoanNumber,vParty_Id as CustomerName ,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster
WHERE vScheme =@vScheme and ? and vStatus='N'
********************************************************************
vScheme
********
MONTHLY
Monthly
Monthly
SCHEME A
SCHEME B
Monthly
SCHEME A
Monthly
Monthly
SCHEME A
SCHEME A
SCHEME A
SCHEME A
SCHEME A
dissue date
***********
13-Feb-13 12:15:38 PM
13-Feb-13 2:26:25 PM
13-Feb-13 3:05:06 PM
14-Feb-13 10:45:43 AM
14-Feb-13 11:56:27 AM
14-Feb-13 12:58:03 PM
20-Feb-13 11:43:27 AM
19-Feb-13 11:43:27 AM
01-Jan-13 11:48:38 AM
01-Jan-13 3:17:08 PM
21-Feb-13 4:52:49 PM
22-Feb-13 6:22:33 PM
23-Feb-13 2:11:44 PM
23-Feb-13 2:28:00 PM
due date
***********
13-Feb-13 12:15:38 PM
13-Feb-13 2:26:25 PM
13-Feb-13 3:05:06 PM
14-Feb-13 10:45:43 AM
18-Feb-13 11:56:27 AM
14-Feb-13 12:58:03 PM
20-May-13 11:43:27 AM
20-Mar-13 11:43:27 AM
21-Feb-13 11:48:38 AM
21-Feb-13 3:17:08 PM
21-Feb-14 4:52:49 PM
22-Feb-14 6:22:33 PM
23-Feb-14 2:11:44 PM
23-Feb-14 2:28:00 PM
23-Feb-14 2:32:02 PM
26-Feb-14 3:58:05 PM
26-Feb-14 4:03:39 PM