C# SQLite insert, update, delete data | Source Code
Vložit
- čas přidán 11. 01. 2021
- In this tutorial, I am going to show you, How to Create sqlite database, and Insert, Update, delete data to the database in c#.
Source code - codegenlab.com/downloads/c-sh...
website - www.codegenlab.com
Please Subscribe for more Videos. - Věda a technologie
The best C# SQLite video I've seen (and I've been watching a lot!). Direct to the point. Thank you!
GREAT Instructional Video! Very Helpful!!
THANK!!! YOU!!!!!!!!!!!!!! то, что нужно... почему-то больше таких видео нет.... есть хрень не конкретная.....
Gracias Bro!! you rock!!
Thanks for this video, its very helpful.
Me sirvio mucho, muchas gracias
You saved my ass!!! You awesome!
Thank you man!!!
that is very cool video thx brother
thanks!
so when u close and run program again, all of the data is deleted? Wasn't it supposed to stay in data grid view all the time?
Хорошее видео, но возникала проблема - когда заношу данные выдаёт почему-то ошибку: unknown error
Insufficient parameters supplied to the command. Думаю проблема как-то индивидуально связана с моей бд, можно ли связаться и получить консультацию?
No se si a alguien mas le pase pero cuando abro el archivo de mi base de datos con SqLiteStudio la base de datos esta vacía.
Es decir no hay ningun dato. En la aplicación de .Net aparecen pero cuando le doy recompilar solución los datos desaparecen es decir no se estan guardando los datos en el archivo sino que solo se quedan en memoria
¿Ha podido resolver este problema?
Do you have source code on Github? I could not get from your link since our IT blocks it. Thanks
you can download here,
drive.google.com/file/d/1OmWSPRrokA5x24fKjofYZroXKDR5uuzA/view
Hello . Thanks 🙏 . But why data of test Table doesn’t shown in Datagrideview I write the all code correctly
Hi, you need to add data to the database. did you add data?
Great tutorial 😁😁, it works perfectly but I added it to multiple forms, it doesn't work anymore, it keeps on telling me there's no such table 😭 what could be the possible cause ❓
Or can you please record different tutorials where you can the database on multiple forms
hi? SQLiteConnection con;
SQLiteCommand cmd;
is never used?
can u help me?
as what i understand, the syntax for "var" in statement "var con =new SQLiteConnection.." is not necessary for all the methods since it has declared "SQLiteConnection con" outside all the methods. I've tried delete away all the "var" and it still work just fine ! , hope the author can clarify what is the intention to used "var" . There must be some reason?
@@atreg9414 var is a shortway of instantiating something or doing a typecast without writing its file type:
Its the same as saying:
SQLiteConnection con = new SQLiteConnection();
But since that's so verbose and long you can write it instead like this.
var con = new SQLiteConnection();
See the difference?
Also you can declare a Connection using a class so instead of changing each one of them you can just access that one connection.
Also as long as you are in the same class file you can call it anywhere on that file, so no need to instantiate the connection and command everytime, what he was doing is the sake of demonstration
Can you publish it?
W
When I went to the Source code link it displayed pornography. Got about 1/2 way through. Mind boggling code and would be nice with some audio. The main thing is for you to know that Jesus loves you !!
Да неинтересно это, я тоже так могу... Но мне надо другое...