title: Populate new chart on ReportViewer1 with SQL query information
body: <p>I am completely new to Charts in asp.net so bear with me, I have been reading multiple multiple webpages on how bind data to the charts but I still can not get anything to show up. </p>
  
  <p>I know this probably isnt the first instance of this question, but I cant figure this out to save my life. Im hoping with a little nudge I wont need any help on this topic after this.</p>
  
  <p>Say I have a dropdown and this drop down has two items in it. On Dropdown_IndexChange it will change the data source of chart1 that is located in ReportViewer (The database is going to be local). </p>
  
  <p>Index 0 creates a bar chart with the SQL Command: 
  "SELECT [SWversion:], [Batt_Wifi:], [Batt_Standby:], [Batt_OnCall:] FROM Amaze"</p>
  
  <p>where SWVersion are the names of the series and the other 3 are the data.</p>
  
  <p>Index 1 creates a line chart with the sql command:
  "SELECT [SWversion:], [Wifi_Pref_IC:], [Wifi_Pref_NC:], [Wifi_Only_IC:], [Wifi_Only_NC:] FROM Amaze"</p>
  
  <p>SWVersion works the same way here as well. </p>
  
  <p>How can I get these charts to show up and how can I attach SWVersion names to the series.</p>
  
  <p>The code I am trying to work with is this:</p>
  
  <pre><code>    Chart1.DataSource = Nothing
      Chart1.Visible = True
      Dim newsqlcommand As String = "SELECT [Batt_Wifi:], [Batt_Standby:], [Batt_OnCall:] FROM Amaze"
      Using con As New System.Data.SqlClient.SqlConnection(connexstring)
          con.Open()      
          Dim myCommand = New SqlDataAdapter(newsqlcommand, con)
          Dim ds = New DataSet()
          myCommand.Fill(ds)
          Chart1.DataSource = myCommand
          con.Close()
          con.Dispose()
      End Using
      Chart1.DataBind()
  </code></pre>
  
  <p>I know this is only one of the SQL Commands but Im still trying to figure out how it works. I don't recieve an error, but with this I can't even get a chart to draw.</p>
  
  <p>Thanks for any and all help </p>