Hi I am using a ajax auto complete feature in my web application. There are 3 textboxes in a page and added AutoCompleteExtender to each one.. when user start typing letters in first text box it gets list from database and displays as a list. like that when user type some thing in second text box it should display a list by sending the first text box value as parameter to webservice method to get values from database. How can we pass the first text box value as a parameter to the webservice when user is in 2nd textbox.. am using C# and asp.net.. Advanced thanks

still confusing.. How to store(session or any string variable) and assign to to fileupload control...

but how to assign string value to fileupload control... I tried but got error messages... pls see my previous post...

How to save and assign to the fileupload control? am trying to assign the path like this FileUpload1.PostedFile.FileName = "Path"; but getting error "Property or indexer 'System.Web.UI.WebControls.FileUpload.FileName' cannot be assigned to -- it is read only. any idea??

I tried like this but not working. Just I placed scriptmanager and updatepanel on the page and kept the fileupload control inside updatepanel... Have I followed correctly???

Hi, I am using fileupload control in asp.net. am selecting the file using browse button of file upload control. But due to postback event of any other control on the page the content(file path) of the fileupload textbox gets cleared... Viewstate is enabled to this control. How to solve this problem??? am using vs 2008 and c#...

thanks. working fine..

yes I gave the same... pls check in the code once again.... but button_click event is not firing if we don't select anything from ddl... only the issue is its not displaying error message....

Hi, I am facing a problem with the validator. Required field validator is not displaying error message for the control dropdown. am binding dropdown with the datatable. and set the initial value property as "select product" in the required field validatior.If i didnot select any thing from ddl and click button its not showing any error message...below is my code. // Binding the dropdonwn with the data table DataTable datatable = GetDataFromDB("SP_GetProducts", "All"); DropDownList2.DataSource = datatable; DropDownList2.DataTextField = "Product Name"; DropDownList2.DataValueField = "Product ID"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "Select Product"); <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" Height="22px" Width="234px"> </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="DropDownList2" Display="None" ErrorMessage="Please select the product" InitialValue="Select Product" ValidationGroup="Calculation" >*</asp:RequiredFieldValidator> <asp:Button ID="Button1" runat="server" Text="Calculate" Height="22px" onclick="Button1_Click" ValidationGroup="Calculation" /> can any one tell me where I was wrong...

scroll bar is coming automatically when items are more...

when the dropdownlist gets too many items in it the user cannot select the bottom ones (the bottom goes below the screen area).   How do i put the scrollbar in the dropdownlist?

correct...

thanks for your suggestion. I have hundreds of products in the table. Is there any possibility to have scroll bar in the dropdonwnlist.

Hi, Is it possible to bind all the columns in a data table to a dropdownlist? ex, I have the below table, I want to bind all the columns except ProductID column to a dropdownlist and when user select product from the list   I need to get the productID.Can any one suggest me.. If not possible in dropdown is there any alternative method to meet my requirement? am using vs2008 asp.net and C# ProductID   Product Name     Version     Platform 111           Madeira           2.0         windows 222           Amazon              1.1         windows 333           Madeira3           2.1            Lynux

Got the solution.. below query will be workout             DELETE T1      FROM BugsDB_DefectVolume T1, BugsDB_DefectVolume T2      WHERE T1.[Product ID] = T2.[Product ID]      and T1.BugDate = T2.BugDate and T1.Timestamps < T2.Timestamps

it will not work out. but the example and query you sent in the previous reply is working fine even we executed query many times. delete from @t where timestamps in(select MIN(timestamps) from @tgroup by bugdate having (COUNT(timestamps)>1)).. As you   have used having clause I think we need to put the same thing in my query. I tired but getting syntax errors... Can you think once again...

but have one problem. if there are duplicate records that first time its working fine but when we execute second time all records were deleted from the table. I think we need to put a check some where in the logic.

I know the logic for how to get duplicate rows but I need to delete them. Below is the table and my logic for getting duplicate records with old timestamp. But I need to delete these records. Can you help by doing little modification in my code. ProductID   BugDate     Bug     Timestamp 111           2009-04-12     1     2009-12-08 12:18:07.453 111           2009-04-14     2     2009-12-08 12:18:07.453 111           2009-04-19     1     2009-12-08 12:18:07.453 111           2009-04-12     1     2009-12-08 12:29:07.453 111           2009-04-14     3     2009-12-08 12:29:07.453 111           2009-04-19     2     2009-12-08 12:29:07.453 SELECT [Product ID],BugDate,Bug,[Timestamp] FROM BugsDB_DefectVolume, (    SELECT [Product ID] AS B, MIN([Timestamp]) AS S    FROM BugsDB_DefectVolume    GROUP BY [Product ID]) X WHERE [Timestamp] = X.S and [Product ID]='111'

Hi, How to remove the duplicate records with the old timestamp. Below is the table, contains 2 columns Bugdate and timestamp. I wanted to remove the duplicate records with the old time stamp. ie first three records. It would be pleasure if any one send me the query. BugDate----     Timestamp     4/14/2009     12/8/2009 12:54.611 4/19/2009     12/8/2009 12:54.611 4/26/2009     12/8/2009 12:54.611 4/14/2009     12/8/2009 12:58.623 4/19/2009     12/8/2009 12:58.623 4/26/2009     12/8/2009 12:58.623 Thanks.

Yes its working fine but only the problem is when date is 01/01/2012 its giving the weeknumber as 157. this is wrong. it should be 158. To achieve this where can I do the modification in my existing query???