I am making a form for search report or display status of information from database and this report is binding to Datagrid.
I have eight to ten dropdown list box and 4 to 5 have checkbox and radion button also. When I selected some them my parameter must go to sql queries and output I want display into datagrid. I am trying to such type of form. But I am getting confused how developed such type of form. All output must be display into datagrid. With following features..
1) Compare to values
2) Greater than or less than
3) Sometime compare year
4) Sometime compare with district or city name
5) Compare district with year and values greater than or less than
6) Compare villages or Gram Panchayat with year and values greater than or less than
7) And so on…..
Please suggest how develop such type of form and how pass a parameter to store procedure, because some parameter will pass value or some of parameter pass a null values also
Any there site or website such type form are using and developed by them so I can use them or type to make such type of form.
I will appreciate if help me. It is very urgent...