Managed to find a solution, the new build of the Ajax Control Toolkit includes the updated AutoCompleteExtender control.
I used the OnClientItemSelected event with some Javascript code to capture the selected value and then I am able to process some business logic based on this value i.e update...
Hi,
I am using Visual Studio 2008 with the latest Ajax Control Toolkit, in particular the AutoCompleteExtender control.
I have successfully setup the AutoCompleteExtender to use a Web Service which queries an SQL 2005 database to retreive results. The Web Service is generic across several...
Had a good read up on RegEx for SQL Server and ended up implementing some custom CLR code on our SQL2k5 box that proved useful for other projects.
For my requirement I found this to be best (and simplest) solution:
SELECT DISTINCT column1 FROM mytable
WHERE column LIKE '[' + @startrange +...
Cheers mate, yeah I was thinking about regex but wasn't sure about using in SQL, I should have taken a look as I am sure it will be far more flexible and elegant for my future needs.
T
Lol, I worked out the answer after typing out this post!
Here is my solution (simplest one's as always):
select somevalue from mytable where myvalue in
(select distinct myvalue from mytable where myvalue >= ('' + @rangestart + '%')
and myvalue <= ('' + @rangeend + '%')) -- selecting...
Hi hope someone can give me some pointers on an issue I have been having with a stored procedure requirement.
I have developed a custom user control (C#/ASP.NET 3.5) which calls a stored procedure on my departments development SQL 2005 Server.
The stored procedure is proving a little difficult...
Thanks jmeckley,
Textbook error on my part! I had some left over code from testing still sitting in my page_load event handler. I forgot to remove the code and do a type conversion on an ArrayList containing objects (the getcheckboxvalue() method wasn't handling the conversion a I had commented...
Hi,
Probably something very simple that I have missed. I am in the process of converting an old ASP application to ASP.NET 2.0.
The code-behind is done in C# and so far I have had no problems however I have created a webform that contains several textboxes, drop down lists and checkboxes. I...
Nevermind, answered my own questions.
Found an much simpler logging tool called NLog (http://www.nlog-project.org/) - very easy to implement (similar to log4net) and much easier to implement across your project from classes to web apps etc.
Adios,
Fz
Hi,
I am currently developing a simple ASP.NET 2.0/C# web application.
I have created a class library where I will store all my business logic and data access, security etc. For the logging I have decided to use log4net as it's readily available and tried and tested.
I am a little confused...
So there is no easy way of finding out what the next increment value is before doing an insert?
I will try out the suggestions and see how I get on.
Cheers,
Fz
Hi,
I am currently developing a C#/ASP.NET web application that hooks into an MSSQL 2005 Express database (will be using 2005 enterprise in the live environment).
The database uses several tables with simple index columns which auto increment (the reason I went for simple integer index values...
Hi,
Need some advice/help regarding a BizTalk error we have been experiencing for the past month now - I am at my wits end.
We have a Windows 2000 Server (SP4) hosting Microsoft BizTalk 2002 Server. The BT server serve's messaging for a bespoke .NET application, receiving messages via a...
The server that your publishing the files to is probably caching the DLL's so it will need a restart however if its a live server then this will obviously have to be checked as the last thing you want to do is restart IIS on a public server!
As for the conversion issues, I found my share and in...
Hi,
Need some advice on how to resolve an issue I am experiencing at the moment.
I am currently working the .NET 2.0 SQLMembershipProvider model. I have some helper methods that retrieve the user password from the SQL database and then based on what the code finds in the web.config...
Thanks,
Makes it clear now. Will this work with a dynamic form?
At the moment I have a function that generates the form programmatically each time the user double-clicks a file name (only one form per file).
I am assuming I simply need to display the form and get my second thread to do the...
Thanks for the info.
I am using Visual Studio 2003, i.e. .NET 1.1. I would use Visual Stdio 2005 however I am not able to do this for the current project so thats out of the question (BackgroundWorker has its own limitations as well).
As I stated, there is no interaction between the thread...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.