Hi guys
I have 1 dropdown for District and 2nd Dropdown
for Blocks.... based on selection of District..their blocks will appear .
So on the selection of Block from 2nd dropdown I have to show data of this query:
select distinct [scheme_type] ,[scheme_subtype] ,[max_value] from [oap].[dbo].[Sub_scheme_total]
where [District_Name] ='pune' and [Block_Name]='karvernagar'
I have another table i.e master..it has column i.e Noofscheme .....has value 2 or 3.
So on Noofscheme basis i have to implement above query.
SELECT [State_Code]
,[StateCensus]
,[District_Code]
,[District_Name]
,[DistrictCensusCode]
,[S_D_Code]
,[NoOfscheme]
from [MASTER]
Go to the complete details ...