Using Sqlite in C# in 30 minutes

[Music] thank you hi welcome to see Lord's Side my name is Iman javadi this subject is using sqlite in seashore for this matter open and visuals.view create a new project in language section select C sharp and inline platform section select windows and select text select Windows Form app next project name is for example people have foreign foreign [Music] and insert the people use two text box [Music] use labor name label is okay and leave a name is family and use a button for insert a person and button name is insert this box for access to these list box this box name is person yes three size four yes no I create a model for person foreign use class create a class name is person model thank you [Music] string excuse me ID and ID gets set update steering name get set Republic it's three family get set for sure name and family together use public extreme uh all family fun name gets arita Donna [Applause] and fan [Music] yes yes and carry the class form access uh database before create class uh we need install DB DB browser forestry light foreign Horizon and type DB sqlite browser [Music] sqlite browser.watch or download click on download tab and click on the standard install for 64. [Music] and download this installer and install this program when you install this program open is a program type sqlite as you like this program this name is DB browser the resources open trade a new database open for the inside Explorer copy dietary copy and paste select a name for this DB first people TV side select name for table person added field ID premiere Auto in agreement and unit integer name text add family [Music] that's yes okay where is data or insert a record uh go to capitalize data and insert a record for example insert a new record sample view command Java yes go to file and write change and find and close database yes go to visual studio click on short file and click right on people tv.tv and select including project yes delete right on [Music] kilogram and people dv.tv and select properties and click on build action and submit content [Music] four build and debug form and click on copy tool to directory and TV copy if never yes yes no I trade a class or manage sqlite and access database all right click on uh I did [Music] new item class name class is access SQ light okay yes added before programming for sqlite we need in a star uh two and three Library for this matter right click on reference manage new get package browser system and wait yes system.data that sqlite.com after you install these Library type data for example uh we use stopper and you can Entity framework and other or silicon Dapper and install yes [Music] go back to access to write date thank you using system dot data I'm using system dot data Dot sqlite and you see before programming this section I go to after country for configuration connection statement connection [Music] added name person [Music] or connections equal they are source equal DB that DB version 3 [Music] provider name equal system Dot data Dot okay SQ L client yes it's good go back to access realize data Trader function thank you static [Music] or some model at least some mother loud people use it yes and trade yeah other function topic is static wall insert person [Music] mother s static restraine hello connection extreme IDE Hua kovacapp.com people [Music] yes foreign Library connection Library contribution right get it on reference added reference comfy to reach system that configuration okay yes using system that configuration all right configuration manager died ID that connection state yeah yes and go back to load paper function using idb connection equal new SQ line connection [Music] hello action stream yes data on database pi bar result equal come that way person mother foreign [Music] yes go to insert person function using idb connection for me SQ live thank you connection load kind of interesting con dot execute insert into person name how many [Music] black hoops and Apache first yes or access to data in sqlite and go back to form one [Music] all right we hold a function for load data [Music] access xq live data that hello people yes or uh set both people in list box and uh for this matter yeah I read a new class Forum person model this time at least or some model s a lot of people and set in people yeah eight volt right huh two listings thank you this box name is Fox is every person every person that data course equal [Music] s source people alas of the person that play testers [Music] yes other function for insert report or insert a person period boy insert insert person [Music] or key [Music] taxes it's really light data that insert person um hello people function followed all people function after insert a record [Music] all right and go to four one and actually that was insert thank you although it's a person function foreign excuse me or some mother means that equal Xbox One X for name p Dot equal thanks and go to insert person function yes and go to uh for one or test this program uh click on the start foreign yes natural people or person for this matter equal to four one one that's CS hi loud people yes start yes you see data in database and I can't insert new record for example excited job and polygon insert yes you see insert error code to database and shown in this box for example there is a robot I actually got insert yes you see a new record two database are showing in this box yes thank you for seeing my education [Music]

Channel: CeLearn

Views: 2,076

Keywords:

Id: 7n8V-utMLjw

Length: 31min 1sec (1861 seconds)

Published: Wed Apr 05 2023