Binding/Rebinding data to chart for asp.net 3.5

[sureshg03]

Dear All,

I m using two radio buttons,

The binding of the data to chart switches according to the radio button selection, but it shows only the data that is selected for the first radio button

Regards
Suresh G

[danasegarane]

Post your code

[sureshg03]

Private Sub BindData(ByVal ChartName As Chart, ByVal sQry As String, ByVal sTableName As String)
Conn = New SqlConnection
Conn.ConnectionString = ConfigurationManager.ConnectionStrings("Conn").ConnectionString
Conn.Open()

DA = New SqlDataAdapter
sqlCmd.Connection = Conn
sqlCmd.CommandText = sQry
sqlCmd.CommandType = CommandType.Text
DA.SelectCommand = sqlCmd

If DS.Tables(sTableName) IsNot Nothing Then
DS.Tables.Remove(sTableName)
End If
DA.Fill(DS, sTableName)

ChartName.DataSource = DS.Tables(sTableName)
ChartName.DataBind()
End Sub

[danasegarane]

Where do distinct between the checkboxes ?

[sureshg03]

The string sQry is passed according to the selection of Radio Button

[gep13]

Have you set a breakpoint in your code to verify that sQry is what you think it is each time?

Gary

[danasegarane]

Did you debug it ? Are you getting the valid data in the new ds ?