|
-
Apr 8th, 2014, 02:31 PM
#1
Thread Starter
Junior Member
[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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|