hi gderosa,
I was going through the posts and found this one of using autocomplete feature on ASP Code (or auto suggest for a text box) and I am trying to do the same. I searched and searched but could not find any yet.
Could you please share your knowledge of how you accomplished your auto-complete functionality?
Thank You
gderosa
Last Activity: Mar 17 '08, 08:08 PM
Joined: Nov 21 '06
Location:
-
Nope, this still does not solve the problem. It has been over a month that I have been trying to figure this out, and I just don't understand! I am creating a new app and am still getting the same error even though I am 100% sure I have everything setup correctly. IIS is impersonated with a superuser account. Identity impersonate is set to true in the web.config file. Here is my SQL Connection code
...Code:'Dim strConn As String
-
Extremely Unusual Connection Problem
I have an ASP.NET/VB.NET web application running on Server A (lets say Fred [http://fred/MyApplication/]) flawlessly. The web application is using impersonation to gain access to SQL Server. Server A is also known under another DNS (lets say Bob [http://bob/MyApplication]). If I access the same exact web application using Bob as the DNS instead of Fred (its on the same box, same location, etc., just different DNS) I get a periodic Login failed... -
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have been getting that dreaded error in my application:
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'.
I have had my application in the test environment, impersonating it using a superuser domain account and setting proper permissions in both IIS and setting up the user in SQL Server.
Now I moved my application to the production enviroment with the same exact settings as my test environment, and I am... -
Thanks very much, it works!Leave a comment:
-
Using Local Variables In A Stored Procedure
Hey guys I need some help with local variables, here is my current code:
...Code:CREATE PROCEDURE CreateFile AS DECLARE @notification int SET @notification = (SELECT NotificationPeriod FROM Notification Where NotificationID = 1) SET NOCOUNT ON --Populate template EXEC sp_makewebtask @outputfile = 'C:\xpsmtp\Test1.html', @query = 'SELECT ContractSequenceNumber,
-
Creating An Advanced Search
I have searched for hours regarding this but I am trying to make an advanced search page for my application that has drop downs for 'Greater Than', 'Equals', 'Less Than'. For example the search page needs to be like this:
ENDDATE: [dropdown with greater than, equals, or less than] [user enters date in this textbox]
How can I manipulate the SQL search string to change the value when the user selects a search criteria... -
Thanks for your help I actually found the code..here it is if others need it:
Code:<asp:TemplateColumn><ItemTemplate> <%#MyDataGrid.PageSize * MyDataGrid.CurrentPageIndex + Container.ItemIndex + 1 %> </ItemTemplate> </asp:TemplateColumn>
Leave a comment:
-
Great thanks very much for your help I got it to work!Leave a comment:
-
Comparing Dates In VB.NET
I searched before posting and followed instructions but it still did not work for me. I need to compare 2 dates but regardless of what the dates are they always return the same value on comparison. Here is my code:
...Code:Dim EndDate As DateTime Dim Current As DateTime = Today If DateTime.Compare(Current, EndDate) < 0 Then Label6.Text = "CONTRACT EXPIRED LESS THAN" End If -
Line Numbering In DataGrid
Hey everyone...I'm trying to figure out how to create a template column in a datagrid to automatically display the line number of the data.
EX:
Search Results
1 Bla
2 Bla2
3 Bla3
4 Bla4
5 Bla5
I dont mind if the line numbers restart if paging is implemented and the user clicks onto the next page in the datagrid.
Thanks in advance!! -
Comparing Date to SQL Server Date
Hey everyone...I need to create a job which occurs once monthly that is based on a stored procedure that contains as a rough example:
CREATE PROCEDURE CompareDate
@CurrentDate datetime
AS
SELECT * FROM Contracts WHERE EndDate LIKE (CURRENT SERVER DATE)
GO
How do I declare a parameter to automatically get the current server date in the stored procedure? Also,... -
I appreciate all of your help but I actually found code after searching for a couple of days that will accomplish what I wanted to do. Thanks again for all your help!Leave a comment:
-
Autocomplete in textbox on ASP
Hey, I've searched for a couple of days and have not found an answer. I have a textbox that needs the autocomplete/autofill feature. There are dozens of scripts out there that do this from a predefined list of values (ie: states are hard-coded in either XML or an array). I need the autocomplete to connect to a database instead of pulling the data from hard-coded values or XML. Does anyone know of such a script to do this? Keep in mind that the... -
Oops, I forgot to include the full code..here it is:
Hey everyone, I have a function that reads XML data and converts it into a string, is there anyway to convert this to read from a SQL database while keeping the same functionality? This code is part of an Autofill user control. Here is the code:
...Code:Private Function GetFilteredData(ByVal filter As String) As DataTable Dim users As String = _Leave a comment:
-
Converting XML Reader to SQL Reader
Hey everyone, I have a function that reads XML data and converts it into a string, is there anyway to convert this to read from a SQL database while keeping the same functionality? This code is part of an Autofill user control. Here is the code:
...Code:Private Function GetFilteredData(ByVal filter As String) As DataTable Dim users As String = _ "<users>" & _ "<usertable><userid>1</userid><username>John -
wow I cant believe I got it to work all it needed was a space in place of the first %:
WHERE ([last] LIKE ' ' + ? + '%')...Leave a comment:
-
I tried the LIKE '"& ? & "' and it still doesnt work, it says poorly formed expression. Thanks for your help though!...Leave a comment:
-
Thanks very much for your help but it turned out that I had to register IIS with ASP.NET 2.0....Leave a comment:
-
Help With Deployment!
I am trying to deploy an application to a test server on my company's intranet. This application runs just fine locally, and I used the 'Copy Project' option in VS 2003. I set the destination project folder to http://ncgc-webdb/NEWGDLocator2/ and selected the File Share Web Access Method. When I access the application at http://ncgc-webdb/NEWGDLocator2/WebForm1.aspx I get this error:
Server Error in '/NEWGDLocator2' Application....
No activity results to display
Leave a comment: