Yusufozgen
New Member
Good day I was wondering if anybody could help me. I'm busy working on my 3rd year project and i have to do some king of reporting. I am currently using asp.net chart controls to display my reports. The problem is i have to filter the chart data according to selected values in the dropdown list. The code I currently have is:\[code\]Protected Overrides Sub OnLoad(ByVal e As EventArgs) MyBase.OnLoad(e) If Not IsPostBack Then SqlDataSource1.SelectCommand = "SELECT PaperNumber, Mark FROM mark Where PaperDate = '" & DropDownList1.SelectedValue & "'Group By PaperDate" & " And Subjects = " & DropDownList2.SelectedValue End If DataBind()\[/code\]When i run the project the moment I change the value in the dropdown list it displays nothing. The dropdown list is set to auto postbackIf you could please telling what I am doing wrong