How do I pass the value selected from the dropdownlist to my sql code in the back? Thanks
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
DataTextField="City" ataValueField="City" Height="23px" Width="164px" AutoPostBack="True"></asp:DropDownList>
private void BindGrid()
{
SqlConnection objConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
string ScheduleID = Menu1.SelectedItem.Value.ToString();
string City = "Dropdownlist value";
string sql = "SELECT Item.ItemID, Item.ItemName, Item.Image, Item.ItemDescription, PromItem.Price,";
sql = sql + " Prom.PromotionName, Prom.PromotionDescription,";
...
Go to the complete details ...