[RESOLVED] Database for desktop application - Page 2-VBForums
Page 2 of 2 FirstFirst 12
Results 41 to 45 of 45

Thread: [RESOLVED] Database for desktop application

  1. #41
    Frenzied Member
    Join Date
    May 2014
    Location
    Central Europe
    Posts
    1,047

    Re: Database for desktop application

    pal, you should be working with parameters. i thought we told you this.
    your code should look something like this:
    Code:
    SQLCommand.commandtext = "Select * from db where dte >= @dt"
    SQLCommand.Parameters.AddwithValue("@dt",dt)
    (untested, please investigate)

  2. #42

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2004
    Location
    India
    Posts
    437

    Re: Database for desktop application

    Thanks and I will remember that now.

  3. #43

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2004
    Location
    India
    Posts
    437

    Question Re: Database for desktop application

    Quote Originally Posted by digitalShaman View Post
    pal, you should be working with parameters. i thought we told you this.
    your code should look something like this:
    Code:
    SQLCommand.commandtext = "Select * from db where dte >= @dt"
    SQLCommand.Parameters.AddwithValue("@dt",dt)
    (untested, please investigate)
    If I want database to be accessed by either multiple threads in the application or different part of program at same time then do I need to enable connection pooling. Plus what is the benefit of uisng in memory database. I could not understand the documentation.

    Thank you

  4. #44
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    30,249

    Re: [RESOLVED] Database for desktop application

    do I need to enable connection pooling
    No... it just happens. It's handled for you by ADO.NET... you don't need to really do anything other than just use ADO.NET.

    Which documentation are your referring to?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  5. #45

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2004
    Location
    India
    Posts
    437

    Post Re: [RESOLVED] Database for desktop application

    Quote Originally Posted by techgnome View Post
    No... it just happens. It's handled for you by ADO.NET... you don't need to really do anything other than just use ADO.NET.

    Which documentation are your referring to?

    -tg
    I am referring to Sqlite documentation. When should i use inmemory db?

Page 2 of 2 FirstFirst 12

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.