Click here to Skip to main content
15,908,768 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
in database records as follows
C#
Minor_Code     Startdate

 PSCRB        11/05/2013
 R-AFF        12/05/2013
 PSCRB        14/05/2013
 R-AFF        15/05/2013
 PSCRB        17/05/2013
 R-AFF        18/05/2013
 PSCRB        20/05/2013
 R-AFF        21/05/2013
 PSCRB        27/05/2013
 R-AFF        28/05/2013

In design as follows
C#
PSCRB   Dropdownlist(From database Startdate are retrieved)
R-AFF   Dropdownlist(From database Startdate are retrieved)

C#
          11/05/2013
          14/05/2013
PSCRB     17/05/2013
          20/05/2013
          27/05/2013

          12/05/2013
          15/05/2013
R-AFF     18/05/2013
          21/05/2013
          28/05/2013

Correct way user has to select is RPSCRB date 11/05/2013(from the dropdownlist) and R-AFF date 12/05/2013(from the dropdownlist)

suppose if user select RPSCRB date 11/05/2013(from the dropdownlist) and R-AFF date 15/05/2013(from the dropdownlist) that time check from the database using sql server query,check the next available batch date.

for that how can i check next available batch date using sql server from the database.

rgds,
narasiman P.
Posted
Updated 2-Aug-13 22:53pm
v2

1 solution

Select Startdate From TableName where Minor_Code='R-AFF' and Startdate>'15/05/2013'
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900