vaquas khan

vaquas khan

  • NA
  • 45
  • 0

problem with all data from database when i click Checkbox

Feb 7 2010 5:40 AM
hi everyone,
i have  a aspx page which contains 2 dropdownlist  control and 1 checkbox . one Button..to filter data and display reports..
i use sql server views to displya the report in crystal report...

i want to when user checked the checkbox then two dropdownlist would be  disable.....report display all records from database...other wise user select the value of dropdownlist and filter record display in crystalreport according to those selected value of dropdownlist ....

how can i implement these case.....please help me

my views is given below..........EmployeeDetails

SELECT      dbo.Employee.FirstName, dbo.Employee.LastName, dbo.Employee.EmployeeID, dbo.Area.Addressline1, dbo.Area.Addressline2, 
                      dbo.Area.City, dbo.Area.Country, dbo.Area.Street, dbo.Area.ZipCode, dbo.SalaryDetails.SalaryType, dbo.SalaryDetails.BasicSalary, 
                      dbo.SalaryDetails.StartDate
FROM         dbo.Area INNER JOIN
                      dbo.Employee ON dbo.Area.EmployeeID = dbo.Employee.EmployeeID INNER JOIN
                      dbo.SalaryDetails ON dbo.Area.AreaCode = dbo.SalaryDetails.AreaCode



Answers (2)