C# SQLite insert, update, delete data | Source Code
HTML-код
- Опубликовано: 5 сен 2024
- 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...
website - www.codegenlab.com
Please Subscribe for more Videos.
The best C# SQLite video I've seen (and I've been watching a lot!). Direct to the point. Thank you!
THANK!!! YOU!!!!!!!!!!!!!! то, что нужно... почему-то больше таких видео нет.... есть хрень не конкретная.....
GREAT Instructional Video! Very Helpful!!
Very good.
Could you provide the source code again please?
Thanks for this video, its very helpful.
You saved my ass!!! You awesome!
that is very cool video thx brother
Gracias Bro!! you rock!!
Thank you man!!!
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?
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?
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
Me sirvio mucho, muchas gracias
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
thanks!
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
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?
Хорошее видео, но возникала проблема - когда заношу данные выдаёт почему-то ошибку: unknown error
Insufficient parameters supplied to the command. Думаю проблема как-то индивидуально связана с моей бд, можно ли связаться и получить консультацию?
Can you publish it?
Bonjour
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 !!
W
Да неинтересно это, я тоже так могу... Но мне надо другое...