Results 1 to 7 of 7

Thread: Help Please!

  1. Oct 13th, 2003, 06:42 PM #1
    Rally
    Rally is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2002
    Location
    Central US
    Posts
    183

    Question Help Please!

    In my OleDbConection1 the path for my data source is set to D:
    And it will not let me change it, how can I change this so it will look in the rite place after running Setup.
    Thanks!
    Reply With Quote Reply With Quote
  2. Oct 13th, 2003, 09:52 PM #2
    Lunatic3
    Lunatic3 is offline
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    In the property of your OleDbConnection expand Dynamic Properties. There click on ... in front of Connection String and in the window that opens tick "Map property to a key ...." . It adds a key to your application configuration file writing connection string in it. When you setup your application ther will be a file called Yourapplicationname.EXE.CFG in application folder that you can edit it and set the path to your database.
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979
    Reply With Quote Reply With Quote
  3. Oct 13th, 2003, 10:33 PM #3
    Rally
    Rally is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2002
    Location
    Central US
    Posts
    183
    Thanks a lot!!!! that's what I was looking for.
    Now there is only one thing left to do and I don’t know how to do that either.
    Maybe someone will fill me in.
    All is working well other than the fact that it is going to bite to have to look thru endless records to find the entry I’m looking for.
    I need to include a search feature.
    Anyone care to take a stab at that, and tell me where to start.
    Reply With Quote Reply With Quote
  4. Oct 13th, 2003, 10:37 PM #4
    Lunatic3
    Lunatic3 is offline
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    Well, search is sometimes a complicated task. What you want to search? what fields? are they Memo fileds? You are using Access database?
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979
    Reply With Quote Reply With Quote
  6. Oct 13th, 2003, 11:55 PM #5
    Rally
    Rally is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2002
    Location
    Central US
    Posts
    183
    Yes I’m using access database there are 2 fields that I’m interested in the first will be CaseID (Key) and the other is FullName.
    The Books that I’m using don’t talk about all that, but it seems to me that they should, considering that what I’m trying to accomplish is not that uncommon (I don’t think anyway).
    Thanks for all your help so far, it really is appreciated
    Reply With Quote Reply With Quote
  7. Oct 14th, 2003, 12:02 AM #6
    hellswraith
    hellswraith is offline
    PowerPoster hellswraith's Avatar
    Join Date
    Jul 2002
    Location
    Washington St.
    Posts
    2,464
    Use an OleDBCommand object. Use a sql statement similar to this (fill in the right table name where I put in TempTable, and replace ?? with a case ID you are looking for):

    SELECT * FROM TempTable WHERE CaseID = ??

    or to search for an exact name:
    SELECT * FROM TempTable WHERE FullName = 'John Smith'

    or to search for all johns:
    SELECT * FROM TempTable WHERE FullName LIKE '%John%'
    My Site
    Reply With Quote Reply With Quote
  8. Oct 14th, 2003, 01:11 AM #7
    Rally
    Rally is offline

    Thread Starter
    Addicted Member
    Join Date
    Dec 2002
    Location
    Central US
    Posts
    183
    As much as I hate to say this but that is not going to get it.
    I played with it but the results, well never mind about that. LOL
    Would you mind to explain a little further?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width