Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Waynest

    Configuring AspNetWindowsTokenRoleProvider

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

    Date format of parameters in query designer

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

    Avoid reload of images in gridview

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

    Avoid reload of images in gridview

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

    Retrieve image data & save as jpeg

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

    Ajax Gridview

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

    Left Align Cursor in Gridview Template Field

    That's extremely useful, thanks :)
  8. Waynest

    Left Align Cursor in Gridview Template Field

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

    WHERE clause problem with input parameters

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

    WHERE clause problem with input parameters

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

    WHERE clause problem with input parameters

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

    How to create MIME content in XML

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

    Export to XML making use of DTD

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

    response.redirect & page_load event

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

    Force login after browser closed

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

    Behaviour of Edit Row in GridView

    asp.net 2, SQL 2000 Ive used the 'enable edit' feature of the smart tag in a gridview control. The row of my grid has 12 columns & only one is editable - a price field which is a money datatype. When in edit mode the column becomes much too wide and appears in this format 0.0000 When not in...
  17. Waynest

    Make button visibbe if gridview contains > 0 rows

    Hi Nice easy question I hope I want to make a button visible or not depending if there are any rows in a gridview. I've got the following bit of code in page load but it only works on the second refresh of the screen for some reason. Needs to go in different event maybe? if...
  18. Waynest

    RS - parameter causing report not to run

    Good point, I've wasted a few hours on parameter settings not being overwritten in the past but always seem to have forgotten it does that by the next time it happens. I've discovered the report behaves as it should when run from the report manager but not when it's embedded in a web page...
  19. Waynest

    RS - parameter causing report not to run

    Hi I've got a report which has been working ok However, I need to capture some text input from the user running the report to display on the report itself. When I introduce a text report parameter the report stops returning any data. Its the ony parameter, not linked to datasets. Same...
  20. Waynest

    GridView Conditional Formatting

    Hi I have the following code in Page Load event to show overdue lines in a GridView with date in red... for (int i = 0; i < GridView1.Rows.Count; i++) { if (Convert.ToDateTime(GridView1.Rows[i].Cells[7].Text)<= DateTime.Now) { GridView1.Rows[i].Cells[7].ForeColor =...

Part and Inventory Search

Back
Top