TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
JAYESH AJ
NA
97
29.8k
Query analizer(8-2013)
Aug 8 2013 12:11 AM
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
Reply
Answers (
5
)
how to display images in grid view
String/StringBuilder