I've got the scroll bar working through thr CSS. Thanks for all your help.:thumbsup:

This is certainly a good suggestion; however, I would still be inerested in a scroll bar. ;)

Here is one I did for freight_cost: You will need the second example. -- max cost SELECT MAX(Freight_Cost) FROM Product_Freight_Cost -- 2nd max cost SELECT MAX(Freight_Cost) FROM Product_Freight_Cost WHERE Freight_Cost NOT IN (SELECT MAX(Freight_Cost) FROM Product_Freight_Cost)

I've added the AutoCompletExtender using a webservice to a textbox and all is well, except, the list is long (maybe 20,000 records from a dataset). How can I add a scroll bar and limit the number of suggestions? I tried adding the following

except when I tried to drag the scroll bar, it triggered the onlick event. Any help would be greatly appreciated. #AutoComplete { width: inherit; overflow: scroll; height: 200px; } Visual studio 2008 AjaxControlToolKit 3.5 C# Web Page Sql Dataset

I have a datalist which includes an embedded dropdownlist. The datalist is similar to a simple shopping cart. The dropdownlist is the qty required. I've been able to set the extend price etc, but I'm also trying to set the selected qty of this dropdownlist. It doesn't seem to like any embedded <%# eval()%> in the html. The qty is updated in the database and is returned. This is the html: =================================================================== <asp:DropDownList ID="ddlQty" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlQty_Changed" > <asp:listitem runat="server" value="1" Selected='<%# Eval("itemqty")==1 %>' /> <asp:listitem runat="server" value="2" Selected='<%# Eval("itemqty")==2 %>' /> <asp:listitem runat="server" value="3" Selected='<%# Eval("itemqty")==3 %>' /> <asp:listitem runat="server" value="4" Selected='<%# Eval("itemqty")==4 %>' /> <asp:listitem runat="server" value="5" Selected='<%# Eval("itemqty")==5 %>' /> asp:DropDownList ==================================================================== Error: Databinding expressions are only supported on objects that have a DataBinding event. System.Web.UI.WebControls.ListItem does not have a DataBinding event. Any ideas?:confused: For referenc, my initial C# question was on 11/5/2009. Used C# to update the selected value while looping thru the dataset and the datalist.:thumbsup:

modified on Thursday, November 12, 2009 3:29 PM

[Message Deleted]

I edited the xml, which solved the problem. Your the best. Thank You very much. :thumbsup:

I'm using a stored procedure (proc) for the SqlDataSource1 of my local report (rdlc). I've changed my proc to include an additional field. When I try to edit my local report to add the new field, it does not show up in the dataset or fields under the expression buider. How do I get the dataset to recognize my new field. :~

When I try that I can't find the "e.item" in: DropDownList ddQty = (DropDownList)e.Item.FindControl("ddlQty"); Fixed it: protected void ddlQty_Changed(object sender, EventArgs e) { foreach (DataListItem item in DataList1.Items) { Label TotPrice = (Label)item.FindControl("lblTotalPrice"); Label PriceEA = (Label)item.FindControl("lblPrice"); DropDownList ddlist = (DropDownList)item.FindControl("ddlQty"); if (ddlist.SelectedValue != null && ddlist.SelectedValue.ToString() != "") { string price = PriceEA.Text.Replace("$", ""); Double dblPrice = Convert.ToDouble(price); Double ProdQty = Convert.ToDouble(ddlist.SelectedValue.ToString()); Double ExtPrice = (dblPrice * ProdQty); TotPrice.Text = String.Format("${0:0,0}", ExtPrice.ToString()); } } } Thanks for all the help

modified on Tuesday, November 10, 2009 3:55 PM

I'm trying to add code to get the qty when it is changed. I added an event to the Dropdownlist "ddlQty" called OnSelectedIndexChanged="ddlQty_Changed" and started to add the following: protected void ddlQty_Changed(object sender, DataListItemEventArgs e) { DropDownList ddQty = (DropDownList)e.Item.FindControl("ddlQty"); if (ddQty.SelectedValue != null && ddQty.SelectedValue.ToString() != "") { Double ProdQty = Convert.ToDouble(ddQty.SelectedValue.ToString()); } } When I run this I get the error: No overload for 'ddlQty_Changed' matches delegate 'System.EventHandler'

I have a datalist with an embedded dropdownlist. How can I fire an event from the dropdownlist and caclulate the results for a label in the datalist? The datalist is similar to a shopping cart. The fore mentioned dropdownlist is the qty for each item. The total price is calculted using the qty and another field "PriceEach". Most of the data is retrieved from a sql stored produre. I wrote the following Item_Bound function to set the totalprice at the page_load. protected void Item_Bound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DropDownList ddlist = (DropDownList)e.Item.FindControl("ddlQty"); Label TotPrice = (Label)e.Item.FindControl("lblTotalPrice"); Label PriceEA = (Label)e.Item.FindControl("lblPrice"); if (PriceEA.Text != null && PriceEA.Text.ToString() != "") { string price = PriceEA.Text.Replace("$", ""); Double dblPrice = Convert.ToDouble(price); Double ProdQty = Convert.ToDouble(ddlist.SelectedValue.ToString()); Double ExtPrice = (dblPrice * ProdQty); TotPrice.Text = ExtPrice.ToString(); } } } :~