system.data.sqlite example code?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

system.data.sqlite example code?

Don Goyette
Hi All,
 
I was wondering if anyone knows of a good websites or forums that have good
articles and/or tutorials (with example code) on how to use
system.data.sqlite with C#, .NET framework, running in Visual Studio 2012
Pro?  And with a variety of data sources to get the initial data for
populating the database tables (ie. CSV, Excel, existing related SQL/SQLite
tables, XML, etc.
 
I'm open as to data display choices (Windows Forms or WPF) and controls
(List, Tree, Grid).  I learn best by seeing the code, versus reading long
papers or books.
 
Thanks in advance!
 
-Don
 
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: system.data.sqlite example code?

Adam DeVita
From this URL
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/
The basics of how to set your project and include/reference the Dlls
are there. You should be able to adapt to your IDE.  (I currently use
VS2010 for C# sqlite projects.)

and this one
http://www.devart.com/dotconnect/sqlite/docs/Devart.Data.SQLite~Devart.Data.SQLite.SQLiteConnection.html

The examples are shorter and more to the point.


"Good" is subjective. For people with experience in sqlite or
databases but are new to the C# api, I felt this was helpful to get me
started.

There are many ways to import spread sheets in various formats.  If
you have your IDE configured one can do inserts from within Visual
Studio.  You could also do it using the standard command line tool.
You could write a small program to do it.  This list has some lengthy
discussions of the hazards and trials of CSV formal.  (I personally
favour TAB delimited text files for plane text over CSV because my
users would never use a horizontal tab, but will put quotes and commas
in the names of things.)  I think that the discussion of importing
data is a separate discussion from 'give some references to good
examples of using the API'.  Sometimes I just use the spread sheet to
write the insert queries, if it is reasonable to do so. (Such as I can
reasonably review it all to know the data is clean and safe.)

WPF trees, grids etc. you should determine if the thing needs to be
static or dynamic.  Having done it, that type of code has several
examples online and is more of a Windows Forms of WPF code discussion
compared to sqlite. If you have a predefined db where the columns of
your grid are not dynamic then there are lots of examples online.

regards,
Adam


On Sun, Jan 27, 2013 at 9:50 AM, Don Goyette <[hidden email]> wrote:

> Hi All,
>
> I was wondering if anyone knows of a good websites or forums that have good
> articles and/or tutorials (with example code) on how to use
> system.data.sqlite with C#, .NET framework, running in Visual Studio 2012
> Pro?  And with a variety of data sources to get the initial data for
> populating the database tables (ie. CSV, Excel, existing related SQL/SQLite
> tables, XML, etc.
>
> I'm open as to data display choices (Windows Forms or WPF) and controls
> (List, Tree, Grid).  I learn best by seeing the code, versus reading long
> papers or books.
>
> Thanks in advance!
>
> -Don
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



--
VerifEye Technologies Inc.
905-948-0015x245
151 Whitehall Dr, Unit 2
Markham ON, L3R 9T1
Canada
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: system.data.sqlite example code?

johnalexa
In reply to this post by Don Goyette
Thanks for your post, If you want to know more about Programming or want
Programming Help
<https://www.greatassignmenthelp.com/programming-assignment-help>  , We are
here 24*7



-----
[url=https://www.greatassignmenthelp.com/programming-assignment-help]Programming Help[/url]

--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users