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!

  • Congratulations SkipVought 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. gazzeruk

    Insert DateTime.Now into SqlServe adds 2 days to date?

    OK... Looked at a bit further and I forgot to mention that I am converting the datetime using the function ToOADate() - which converts a .net DateTime to a double - as apparently required by sql server. I am guessing that the Date representation in the DateTime starts 2 days behind the OLE...
  2. gazzeruk

    Insert DateTime.Now into SqlServe adds 2 days to date?

    Hi, Had this years ago and can't remember how I solved it! I want to timestamp some events with my own DateTime derived time (not the auto sql TimeStamp!). When I save DateTime.Now into an sql server DateTime field - and view this field, it shows the date+2days and the correct time - why...
  3. gazzeruk

    File Open Dialog - does not open (sometimes!) in Win98

    Hi, This is not because of any wrong dll's (I think!). I have a VC++ app that works fine with common controls on NT and XP. On 98 & ME the File Open Dialog does not open. However a small test program - written in the same vc7 environment DOES open the File Open dialog. What can I be doing...
  4. gazzeruk

    Refresh button and multi-framed pages

    Hi, I've got 3 frames which when loaded in correct order i.e. top down to 3rd frame work just fine. The lower frames call methods in parent frames - so the parent frames have to be there for this. However when I click the browser refresh - the frames seem to load ad-hoc or maybe from lowest...
  5. gazzeruk

    xp page load progress still showing when page loaded!!!!

    Hi all, I have a tabbed menu implemented in a few frames. All is ok but for one item/page. This (as others do) has to gather some data from db before displaying - only the progress for this page load in xp gets to about 2 bars and then just stays there for duration of page - why!!! Other than...
  6. gazzeruk

    How to use \ create application instance level variables

    At the server you use the Response.Cookies.Add("myCookie") to add a HTTPCookie object and Request.Cookies.Get("myCookie").Value to read a cookies value. Look at the help for these objects to understand a bit more. You could either save products as an array of cookies or maybe...
  7. gazzeruk

    How to use \ create application instance level variables

    Sharing data in this way is sharing data at the server. If this is a shopping cart for your users then typically you park this data in client based cookies. Hope this helps. Gary
  8. gazzeruk

    Passing % char in the URL

    Looks like % is used with 2 following chars to define other single chars in the string i.e. %20 = a space - so what does %AF mean - nothing by the looks of it... Short of any clever explanation I would quickly parse the sql before sending to other page replacing all %'s with another unused...
  9. gazzeruk

    swap one control for another?

    I have had to do this a number of times add, edit and delete db records. As you are I use a list to select particular records. For add I pop up a simple 1 textbox form in a modalDialog and immediately receive name (key) of new record - on OK this can then be posted back and varified to be unique...
  10. gazzeruk

    process calendar days without an event

    OK - I never used the Calendar control before. Having quickly looked at it, it appears the only collection is the Control collection - so iterate through this and it might just contain all your dropdowns in the order that you inserted them - you never know! Same applies with this - copy/cast...
  11. gazzeruk

    process calendar days without an event

    If your table is a webform control Table - called myTable then its Rows collection is accessed with myTable.Rows[y] where y is the required row in the table. The cells are accessed for each row with myTable.Rows[y].Cells[x] where x is the required column. If this is not clear are you doing this...
  12. gazzeruk

    Sometimes I can debug aspx - Sometimes I can't?

    Hi, Thanks for above tips - sounds like both could be a possibility. My only slight reservation is that I am reasonably sure that when this occurs I am only working on a single project and stop debugging between fixes - however I will check this out and post a thread to indicate solved or not...
  13. gazzeruk

    Calculate no of weekdays in date range

    Hi, Following does the job - maybe not so elegant - but it works! DateTime start = new DateTime(<start date>); //see DateTime constructor for various formats of <start date> DateTime end = new DateTime(<end date>); int count = 0; for (DateTime dt=start; dt<end; dt=dt.AddDays(1))...
  14. gazzeruk

    Request value

    Hi, Forgive me for asking, but why dont you validate against your database in the aspx file using basic or c# - this has got to be easy if you already have required sql etc. in old asp file and will be much easier to maintain... Cheers,
  15. gazzeruk

    Referencing other activex controls from an activex control

    Hi, How can I reference other activex controls from an activex control all in same container. The activex's concerned don't necc. have an associated window. I am using an MFC dialog as container. Cheers,
  16. gazzeruk

    datagrid column width

    Hi, Iterate through the datagrids Items collection and each Items Cells collection - you can then set the width of each cell. If the datagrid is anything like a table (which I suspect it is) you probably only need to set the widths of the first Items cells. - set it at server...
  17. gazzeruk

    datagrid column width

    Hi, Iterate through the datagrids Items collection and each Items Cells collection - you can then set the width of each cell. If the datagrid is anything like a table (which I suspect it is) you probably only need to set the widths of the first Items cells. - set it at server...
  18. gazzeruk

    Destroy ASP.NET cookies-how?

    Hi, Doesn't Response.Cookies.Remove(&quot;mycookie&quot;) clear it! If not, try expiring the cookie at the time you want it removed. Hope this helps, Cheers.
  19. gazzeruk

    process calendar days without an event

    I think I have done something similar to this myself. You have an asp:table with each cell representing a day and also containing a dropdown. Your users select something from the dropdowns in particular cells and you want to read this selected info back at the server. You can iterate through...
  20. gazzeruk

    Sometimes I can debug aspx - Sometimes I can't?

    Hi, Does anyone know why sometimes when I place a red break point in an aspx file - it receives the usual question mark whilst the site is starting up - but does not lose the question mark when site running and consequently does not break? It seems to happen after the aspx has been worked on...

Part and Inventory Search

Back
Top