This is one of the best explained tuts I have seen so far. Setting up the connection was far more simple than I eread elsewhere. Reading from and writing to the database was well explained but you could have added the DELETE from database too as good measure 8-) I am also grateful you included about the file creation if one does not exist, that was something I was about to look up to help with one of my projects so you saved me a lot of time. thanks
Fantastic, got me up and running with SQLite very quickly! Agree with other comments in that you don't need to over complicate things like this. In my opinion beginners can go and research finer detail for themselves, whilst veterans already know and understand, so just showing how to do the job is enough to cover everyone's needs and we can take it from there. Cheers!
Is there a way to get this working with WinForms? This functions perfectly in the main body of a console application but for whatever reason it's not doing very well trying to tie it to event listeners on various forms. I really like the straightforward way you presented the material it is a really good starting point. Thanks in advance!
Worked well. I used this package for .NET Core instead: www.nuget.org/packages/Microsoft.Data.SQLite/1.1.1 Had to create the file with System.IO though.
What if you wanted the data that was created inside of the Sqlite GUI to be Stored inside of a datagrid, would you mind helping me out with doing that.
Hello, your tutorial is so amazing. Howerver when I release my project into an exe file and download it on another computer, it does not work anymore and it says no such database. I would be very greatful if you can tell me the solution for the problem. Thanks!
When you transfer the project to a new pc to run it (like you said the client for example) do you need to install the nuget package again like you did here?
Hello Dejvi, No you don't this is just a development dependency only required during the development process, once you compile and deploy your app everything will be included for you there, nothing required in the client side, it's not like mysql or mysql Server (which was a pain in the ass back in the days when i was using them), sqlite is serverless . Cheers :))
Hello thanks for the fast reply :) What do you mean by deploy my app? Make it an executable(like .exe) or something? How can I do that? I've only ever started and tested my projects from my IDE
Yes Deploy your application means having an executable that you can run on your client's machine, you can search the web there a lot of tools that can help you do that it's easy, and since your using sqlite it's even easier when it comes to the database stuff all you need to do is include your database file with your project assets (images, icons ..) and you're ready to go. Unfortunately i don't have windows installed at the moment i would have recorded a video for you on how to do it, but it's gonna take some while cause i need windows and VS, but you can always use google and get this stuff done :))
Why when I type public SQLiteConnection myConnection; there is an underline under SQLConnection ? I followed your instructions step by step multiple times and not sure if I missed something or not. The sqlite reference is there, the using statement is there as well. I am using VS Community 2015.
Nevermind... I uninstalled sqlite from nuget manager and installed again... not sure what happened but the first time round it must not have installed correctly. Hopefully my comment helps others, so leaving it here.
Hello, I dont know you are here or not, but When I do the results to display the results from the db to console I get System.InvalidOperationException: No current row
I'm so sorry for not replying earlier to this message i'm not logging in to this account a lot lately, If you're still having trouble with this or seeking help with anything else, please leave a reply with a code snippet or something and i'll do my best to assist you. Thank you.
SQLite is installed by right clicking on the project and adding it using the Nugnet option. Once installed you have to declare it with the 'using' at the top of your opened project page such as using System.Data.SQLite; Once you done that you should be good to go. hope this helps
@@OverSeasMedia oh hi thank you for your quick response. How do I install it? Thier site has changed and I cant find it Can you tell me or do a simple tutorial?
I m getting errors during cooding all time for some reason , then i have to define them and get set, but the last error i m getting is not even making sence .
Severity Code Description Project File Line Suppression State Error CS1061 'SQLiteconnection' does not contain a definition for 'Open' and no accessible extension method 'Open' accepting a first argument of type 'SQLiteconnection' could be found (are you missing a using directive or an assembly reference?) SQLite C:\Users\oemer\source epos\SQLite\SQLite\Database.cs 30 Active
Severity Code Description Project File Line Suppression State Error CS1503 Argument 2: cannot convert from 'SQLite.SQLiteconnection' to 'System.Data.SQLite.SQLiteConnection' SQLite C:\Users\oemer\source epos\SQLite\SQLite\Program.cs 17 Active
Thank you for not purposely over-complicating this like so many other tutorials.
Lol what's the purpose of a tutorial if you just gonna over complicate stuff :p .
Thank you for the feedback as well, much appreciated mate :)
This is one of the best explained tuts I have seen so far. Setting up the connection was far more simple than I eread elsewhere. Reading from and writing to the database was well explained but you could have added the DELETE from database too as good measure 8-) I am also grateful you included about the file creation if one does not exist, that was something I was about to look up to help with one of my projects so you saved me a lot of time. thanks
@15:40 Legend says that even to this day his database remains open..
Yeah, close(), not clone(). Good tutorial, appreciate it!
Fantastic, got me up and running with SQLite very quickly! Agree with other comments in that you don't need to over complicate things like this. In my opinion beginners can go and research finer detail for themselves, whilst veterans already know and understand, so just showing how to do the job is enough to cover everyone's needs and we can take it from there. Cheers!
Great job on the video! So many people make interacting Visual Studio with SQL so complicated, you made it super easy
Thank you mate, most people told me that I over complicated things but I'm glad this was helpful to you .
Cheers :))
really good tutorial - most of the tutorials on this topic are overly complicated, but this one is really plain and simple, thank you :)
And I am here 7 years later watching this video and thinking. Damn it's still one of the most useful tutorials on youtube on this topic.
Dude you given us the best SQLite C# video tutorial...
❤️ Thank You ❤️
I just came to see reading data code, it works like a Swiss watch! Nice video thank you! 😁😁
half a decade down the lane; and this video is just pure gold🤗
it is crazy even for me that I made this video in 2017, time really flies.
Amazing tutorial. Straight to the point. Awesome!
Thank your for the comment :)
Cheers .
Really clear, concise and useful. Thanks
Well thank you good sir for the nice comment .
Cheers :))
This helped me out a ton, thank you dude!
You're most welcome :)
Thank you for being straightforward! I was just wondering what's the syntax like if I wanted to UPDATE records in the C# application?
Thank you so much! This is very useful.
buddy that video ssaved mi life ,, grrrrrrrrreat
I am just glad it helped . Cheers mate :)
Thank you such a simple and understanding video thanks a lot
I'm glad you liked it, You're most welcome :)
thanks for in depth explanation
Is there a way to get this working with WinForms? This functions perfectly in the main body of a console application but for whatever reason it's not doing very well trying to tie it to event listeners on various forms. I really like the straightforward way you presented the material it is a really good starting point. Thanks in advance!
Sorry...in particular it works when I use it in the Program.cs just fine seems to cause a write-lock whenever I have it anywhere else
you're my hero, thank you so much!
You're most welcome .
Cheers mate :))
Great intro video. Thank you!
You're most welcome . Thank you for he feedback .
Cheers :)
Thanks alot sir, do more vids
Thanks! Very helpful!
Thanks, really useful
You're most welcome
really amazing tutorial
Thank you sir.
Worked well. I used this package for .NET Core instead:
www.nuget.org/packages/Microsoft.Data.SQLite/1.1.1
Had to create the file with System.IO though.
Thank you
Nice! How do you create a column if it doesn't exist in a database?
15:45 you mean Close() instead Clone() or ?
Thank you for a great tutorial......some lovely coding.
What if you wanted the data that was created inside of the Sqlite GUI to be Stored inside of a datagrid, would you mind helping me out with doing that.
Bro are you a god thanks
Hello, your tutorial is so amazing. Howerver when I release my project into an exe file and download it on another computer, it does not work anymore and it says no such database. I would be very greatful if you can tell me the solution for the problem. Thanks!
is there a way to make Both connection open/close/Command, public, so that you dont have to specify it on every frompages?
Muito bem explicado. Muito obrigado!
Thank you so much!
When you transfer the project to a new pc to run it (like you said the client for example) do you need to install the nuget package again like you did here?
Hello Dejvi,
No you don't this is just a development dependency only required during the development process, once you compile and deploy your app everything will be included for you there, nothing required in the client side, it's not like mysql or mysql Server (which was a pain in the ass back in the days when i was using them), sqlite is serverless .
Cheers :))
Hello thanks for the fast reply :)
What do you mean by deploy my app? Make it an executable(like .exe) or something? How can I do that?
I've only ever started and tested my projects from my IDE
Yes Deploy your application means having an executable that you can run on your client's machine, you can search the web there a lot of tools that can help you do that it's easy, and since your using sqlite it's even easier when it comes to the database stuff all you need to do is include your database file with your project assets (images, icons ..) and you're ready to go.
Unfortunately i don't have windows installed at the moment i would have recorded a video for you on how to do it, but it's gonna take some while cause i need windows and VS, but you can always use google and get this stuff done :))
Why when I type public SQLiteConnection myConnection; there is an underline under SQLConnection ? I followed your instructions step by step multiple times and not sure if I missed something or not. The sqlite reference is there, the using statement is there as well. I am using VS Community 2015.
Nevermind... I uninstalled sqlite from nuget manager and installed again... not sure what happened but the first time round it must not have installed correctly. Hopefully my comment helps others, so leaving it here.
Kevin Carbonaro thank you for taking the time to share the solution with everyone
idk if u r still here but when i hit run it comes up with
SQL logic error no sutch table: albums
guys if u dont see your .sqlite or .db file, go to the release folder instead
Thank you sir...
Hello, I dont know you are here or not, but When I do the results to display the results from the db to console I get System.InvalidOperationException: No current row
I'm so sorry for not replying earlier to this message i'm not logging in to this account a lot lately, If you're still having trouble with this or seeking help with anything else, please leave a reply with a code snippet or something and i'll do my best to assist you.
Thank you.
After installing SQLite HOW do you open it? Is there a button to somewhere to click?
SQLite is installed by right clicking on the project and adding it using the Nugnet option. Once installed you have to declare it with the 'using' at the top of your opened project page such as using System.Data.SQLite; Once you done that you should be good to go. hope this helps
its very epic!!
Nice.....
Thank you :)
Does this work with xamarin?
How to open DB BROWSER for SqLite?
You have do download and install.it it's not included
@@OverSeasMedia is that link intended or is it just a typo? How do I download it, couldn't find updated tutorials
Hey Daniel,
That's just a typo I am sorry
@@OverSeasMedia oh hi thank you for your quick response. How do I install it? Thier site has changed and I cant find it
Can you tell me or do a simple tutorial?
nice dude ,ty
I m getting errors during cooding all time for some reason , then i have to define them and get set, but the last error i m getting is not even making sence .
Severity Code Description Project File Line Suppression State
Error CS1061 'SQLiteconnection' does not contain a definition for 'Open' and no accessible extension method 'Open' accepting a first argument of type 'SQLiteconnection' could be found (are you missing a using directive or an assembly reference?) SQLite C:\Users\oemer\source
epos\SQLite\SQLite\Database.cs 30 Active
Severity Code Description Project File Line Suppression State
Error CS1503 Argument 2: cannot convert from 'SQLite.SQLiteconnection' to 'System.Data.SQLite.SQLiteConnection' SQLite C:\Users\oemer\source
epos\SQLite\SQLite\Program.cs 17 Active
@@omervolkankup3865 share your source code?
i not retrive sqlite namespace
why?
hi
i am trying to type these code, why the code show System.Data.SQLite.SQLiteException: 'SQL logic error
near "INSTER": syntax error'
do u helpt me?
change INSTER to INSERT
how you opend dbrowser
Bro, can you show how to protect a sqlite3 DB with a password? ❤️
Thank you :)
You're welcome :)
Shoutout Bryson Tiller.
using dapper it is even simpler than this :)
dude you have same voice as Cristiano Ronaldo lol !!
LMAO I just watched one of his videos cause I never heard him talk and I can confirm that your comment is accurate af 😂.
thnx
You're welcome :)
Merci
je t'en prie Didier :)
thank u for this tho
Thank !
nvm i fixed it