Recent content by tahirk

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...

Cheers Mark, I'll give that a method a go and see how I get on.

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 +...

Found a good resource: http://blogs.msdn.com/khen1234/archive/2005/05/11/416392.aspx Looks like exactly what I need.

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

*oops: somevalue = myvalue, above code was hacked together quickly as an example*

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...