how to bind the asp.net dropdownlist items to the datatable columns of sql server?
<p>Below is my code...</p>

<pre><code>SqlCommand da = new SqlCommand("select time_stamp,'" + DropDownArray[i].SelectedItem.ToString() + "' from data_104 where time_stamp between '" + FromTime_DropDown.SelectedValue.ToString() + "' and '" + ToTime_DropDownList.SelectedValue.ToString() + "' order by time_stamp", con);
SqlDataReader dr = da.ExecuteReader();
Individual_Chart.Visible = true;
Individual_Chart.DataSource = dr;
Individual_Chart.Series[i].XValueMember = "time_stamp";
Individual_Chart.Series[i].YValueMembers = DropDownArray[i].SelectedItem.ToString();
Individual_Chart.DataBind();
con.Close();
</code></pre>

<p>even though dropdown item name and column name of table are same i'm getting the error that the selected item not found. ex: "PV Voltage not found"</p>
