Results 1 to 5 of 5

Thread: [RESOLVED] vb net 2010 how to read a single string from a sqlite3 database file

Threaded View

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Apr 2011
    Posts
    20

    Resolved [RESOLVED] vb net 2010 how to read a single string from a sqlite3 database file

    After looking everywhere i always come up with the same problem, or its in the wrong programming language or its a broken link.
    so i turn to here hoping someone can help me a little bit.

    what i try to do is the following.

    1. open a local sqlite3 database only for reading
    2. read a specific string in a table called "parts", in the colum named "name" find the value "scaff101" and the get the value of that record in the colum "quan"


    Code:
    (little example of the table to be more clear)
    ##################################################
    #                       Parts                    #
    ##################################################
    # key #   Name    # Type # Length # Width # Quan # 
    ##################################################
    #  1  #  scaff99  #  b1  #  100   #  50   #  30  #
    ##################################################
    #  2  #  scaff100 #  f3  #  250   #  10   #  80  #
    ##################################################
    #  3  #  scaff101 #  h9  #  125   #  25   #  90  #  <-------------
    ##################################################
    #  4  #  scaff102 #  z7  #  550   #  20   #  60  #
    ##################################################
    the only part of this table i'm intrested in is "90" so i dont need anything like writing, changing, deleting, or whatever.

    i'm happy if somebody can show me in the right direction or a little example code to get me started.
    i have the "sqlite-netFx40-setup-bundle-x86-2010-1.0.92.0" installed to have access to the system.data.sqlite.dll and system.data.sqlite.linq.dll
    but on sqlite website i could not find any usefull starting information for a beginner with databasesand i really dont need that much i think

    thank you for your time
    Last edited by The_Lone_Wolf; Apr 8th, 2014 at 04:16 PM. Reason: edited some typos regarding naming of table and column

Tags for this 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
  •  



Click Here to Expand Forum to Full Width