Recent content by Waynest

Ahoy shipmates I'm developing an app for internal use and I want the logins and menu control (sitemap driven) display to be determined by membership of Active Directory groups I'm familiar with forms authentication sites but this is the first AD one I've done Now, based on what I've found on...

VS 2005 Management Studio Since a pc rebuild, in the view designer, I now have to enter query parameters in american date format whereas it accepted UK format before Any ideas how to change back to uk? Thanks

yes I am using a handler to populate gridview with images, but I am not convinced the browser is caching them as the page takes a long time to load with a slow wifi connection which is what some of our shop customers are using, is anything required to activate browser caching? Would you know if...

Hi VS 2005/ SQL Server 2005 I have a page containing gridview control which shows a product thumbnail image and an order qty which the users can chage using the standard edit/update/cancel Each time the users update a quantity, all the product images are reloaded (they are stored in sql...

Hello A SQL 2000 DB of ours contains thousands of photos of our customers' shops stored in image fields Rec layout is something like rec_id, store_no, image_data We need to create a cd containing all our photos, and include store_no in the filenames Could anyone suggest a method for reading...

Hi Using Ajax, is it possible to have a gridview control which allows user to click into cells and amend values without the clunky edit/update/cancel mechanism? If so, a link to an example etc would be great, not finding anything useful myself atm Thanks

That's extremely useful, thanks :)

Hi In gridview when user clicks the update button, then clicks into a text field he wants to edit, the cursor is being positioned where he clicks inside the box. Is it possible to make the cursor be positioned at the leftmost position when the user clicks on the box? Thankyou

its smalldatetime, same as the variables I used The usual fix for param sniffing as I understand it is to transfer the values of ypur input params to local variables and use those within your query... but I'm geting the issue before my query has made it to a SP. Ive got the query up to speed...

No difference already tried that. Also tried various CONVERT things to no avail. The execution plans are very different when using hard coded values vs parameter ones, I don't get why its doing this.

Hi I have a query which takes 1 sec to return results when the WHERE clause is as follows WHERE (FT.FT_BAD_TRAN=0) AND (FB.FB_DATE BETWEEN '20080602' AND '20080608') However, the query is to become a stored procedure with input parameters. When I declare & set variables for the date...

Hello c# vs2005 / SQL 2005 We are putting together a routine to build & send xml files containing invoice data to one of our customers. The customer has specified that a pdf of each invoice be included in the xml as MIME content. We can create the pdfs easily enough, but any suggestions how...

Hi A customer of ours has specified that we must supply invoicing information to them as as XML. They have supplied a (very complex) DTD file which specifies the required format. Our data is held in SQL 2000 databases. We also have SQL 2005 and Visual Studio 2005 (we use c#) at our disposal...

asp.net 2, sql 2000 Hi Response.redirect is giving me some jip.... if (Context.User.IsInRole("Administrator")) { Response.Redirect("~/GeneralPages/StoresList.aspx",false); return; } If I set breakpoint in page load event of the page being redirected to it is never reached...

asp.net 2, sql 2000 Hi I would like to change the behaviour of my web app so that if the user closes the browser window & reopens it he has to login again. Currently his last page is displayed again which isn't the behaviour I want. Is this something I can control via web.config? TIA