How to Create Student Database Management Systems using SQLite in Visual Basic.Net - Full Tutorial

hi is a visual basic student record management system developed using SQLite let me show you guys how this works so here we enter student details rather than the student number and a Costco you can just pick any of those and the name of the student I see is Peter Parker gender is male age is a 23 and address is baby number 17 wine world writes postcode of Parker and add mass mass business biology and physics hey that's Bacchus great then all we just need to do is to click on end result I'm right there that's the that's the table okay so you can even click on the transcript a day that's it that's what we get that this transcript which you can also print out if you want yeah that's it okay close that so and the other thing you can do is you can research if you want or delete whatever you want to delete in there we set over exit so what I'm gonna do now is I'm gonna take you straight into visual basic development environment I will put one of these together so let's do that now guys hi and welcome to visual basic tutorial of student database management system using SQLite I'm gonna start by clicking on create new project okay I'm going to select this basic and select windows forms application let's give this project a name it's gonna be VB underscore student and the school has ql light despoil a database but let's save it right away save okay guys my form is ready so what I'm going to do is to change background color of this font to spin a bit powder blue so let's come right down here in this part of you somewhere here right there then the next thing is come straight to the tool box I need a panel that is my panel right here and I'm gonna change the color of this your first panel I'm gonna change that to candidate river unless copied is Basin panel I'll click the old BAM copy and I wouldn't change the color of the copy the one to pull that blue and drag it in reduce the size of this copied in under struggle paste right in the middle there okay I will now copy this itself across so let's put this one there I'm also gonna cop it just below my day okay just enhance the whole appearance and I will then get back to you guys okay this is how it looks like now what you see is very one here this very panel I'm gonna add a data grid so let's see Diablo click on data balloon and just draw okay so let's train the back call out this data griddle to powder blue concentrated of properties that brown color how that blue see web yeah we go and the other Tina I'm gonna need ease me some buttons let's grab some buttons yeah just like that let's check the properties about their button I'm going to chain that to the background I'm going to change it to candidate blue that will be forever brother let's see dude increase the font size and just copy it across all right let's pick that ball the middle and tough 14 dear deserts so I resent I might as well just change the name of that very bottom to the Texan Nature can exit and the name would be and exit there we go now copy that across right click and drag nice for there maybe one and two now let's change the details this one solar sail student results Ricci and student healing students results right and it takes me to the student results to keep them yeah this one is going to be transcribed [Music] [Music] scribbs and changee or the name to transcript so I'm gonna speed up or get back to you guys okay now let's enter some labels here and text box text box right then I'm going to need one combo box right there okay get it somewhere scope it is a course select it all sweetie I'm gonna increase the size the font size and this combo box right I'm gonna make that it's before 14 as well okay as for the text and label I need this once here then I'm gonna leave I suppose what I need ATM what and here let me add we have odd rich text box there so I'm going to enhance the look of this interface and I will then get back to you okay like here we have student here and the text box itself is now going to be known as txt student melody just like that why the next one here is going to be now we cause students to break the code box is going to be known as cosgood okay so I'm going to speed that up and get back to you guys okay guys this is how it looks now but I'm going to move this aside here and notice in a little bit because really needed this course which subjects the students and here on the DG and winter odd where art some shin Se SLS climbing a drab Estrada panel and I'm going to change the color to blue now I'm going to grab three of these hold on to control one gravitas right after and check these friends this is where we'll have our braids so in here we can grab one of its just paste it in there and just change that to maybe find our results find our results ranking just leave that there okay now what we want to do is yeah that'll be all that'll be tall maybe just increase the size of the final result [Music] yeah okay all right good I need to write some quotes mean starts with the exit that appear can be exit and right inside the exit see I'm going to declare variable by setting I exit did I exit as dialogue result and press ENTER I exit equals message box that show and that will confirm if you want to exit what this enter the SIS to dn't record okay now the next thing is I'm gonna add a message box I come here of message box button okay dot yes No right and OMA message box icon dots let's say information you can always use question press enter now I'm gonna use an if statement to validate a selection made by the end user if I exit equal dialog result ah yes then application without exit right there so that's my exit taking care of now let's come back Union take care of the reset right click or double-click on the resets the you could okay let's declare up there once a dim txt has control right now let's use the follow for each Lexi in need of control this is what I want you to do okay if type off to be T X T n me dot controls if TT lexi is okay is six boats right then I say txt that and to do for play around okay okay let's say THC dots and text them that's takes it was day okay okay um this is not gonna work because I just remember the all of the text box are actually inside the final panel to right here so I'm gonna change that instead of me that means you become panel and out of control yeah have a good look at it now let's write and see how it does been work okay flaky never go that's fine alright I'm just gonna add this remote to it so what is the name what is the main point that what copy that go right in here double click and just paste that Aditi that's clear okay so that although that lines of code for play now let's add here let's add some object for the print yes of those ones get those out of the way gonna meet trains bring document is gonna wanna print preview and shoot right so the print preview let's see the document to be document one okay now what else do I need okay let's take care of the print function you see this one I'm gonna double click on that alright in then just you know call the preview print preview somewhere here print preview dialog dot show the zoo don't show dialog one but this should be trained through dialogue okay that's fine now see these documents so double click on double documents I'm going to now say he does graphics right and Google wanted to draw and add centers in the RT transcript dot text Norma the fonts that I tend to use I'm gonna make that let's go for it area and we say comma 12 comma 12 and phone style let's see dot to be regular okay and here the brush is I'm going to be I said brush this kind of a block , meal plans that will be zero Mobe zero zero okay does coordinate weirder to be so the prince is fully taking care of whoever look good look at these lines of codes all right okay let's try out the prints I'm just gonna enter walk over there click on print they'll go look at that okay print is taking care of Claire as fine that's it yeah now one thing I like to achieve is see these text box in all of these I will only like them to just accept numbers only does this one's an age will be number only right and we just come in here okay let's make mobile phone number only as well let's go straight to the properties here events so I'm gonna go for key press on capers yeah okay percept empty okay he first so let's just say [Music] there we go so just using one event to group all of those numbers together I'm now going to say if ascii so as K stands for American Standard Code for information interchange ask adult teacher okay it's less than an equals to 8 then I want the following to happen I say if ASCII again with ASCII less than 48 or ASCII or ASCII resident 50 as a 57 so in that case what happened assistant to do is a that handle it was true hopefully does take care of anyone infringes and your corrupted so let's see okay I'm going to use on spring keyboard to check okay so that is working but we can enter numbers in there cannot enter neither and here the value so that's fine okay so close that clear right so we've taken care of that now the most important bit okay please to create the database now it'll create a database soon using SQLite browser let's see it's coming out there does I help my SQL like brother you guys can always compete you can always download it online and install it I will include a link way to where you can get the the application itself and get its installed now a spirit a new database I mean you knew did is okay don't you use these following names and I'm gonna give it a name let's just call it student student yet as far and I'm going to save it inside my project for thyself so let's search for that right here as much project folder so I'm gonna click on save okay the editing here Israeli salmon gilded prepare the tabular name I will just call it student now the next thing I want to do is you wanna click on add field fill down the false one I want to add students student ID understood an ID just gonna make that text rate that my primary key and okay create another one but the other one is gonna cost good flew by first name [Music] let's do that again - applause good okay not to text in action here it's gonna be first name that it's Texas well I don't know the one then the next one let's just problem I'm gonna grab the mobile number okay let's just say do we really need mobile no student IDs oh okay that's before oddness so we can just finish up Martin and the next one is very nice right and that darkness there have business and London in business I shall biology okay I'm gonna click on OK from now so that kind of movies okay yeah we'll just reduce it we can see what we opted okay let's select and go to modify to G they say now the next one the next one is going to be chemistry that's what Emma's room [Music] that's computing without English there will have physics Jesus [Music] now we need total total it's Paul right they're finally ranking the piece of ranking now Kim is gonna be Tex the rest of them are just numbers okay that is fine so that's my database to attend and click on ok and if you want to modify you can just click on modify select it and modify that's fine anyway right the database is completely let's see you can just excessive yeah okay I'm gonna close that ok let's have a look at the database right there as the database is created but it's not populated though now the next thing I like to do is let me exit out of here and is if you don't have SQL installed on your program you go to tools let's do the face go to tools here and we need not Park a manager and just like that click on that click on the package manager okay we this shows up okay manage package for solution so in there I need SQL lights so let's search for SQL us like everything okay this is this has about two points 38 million download and this is about three points 53 million download with a click on this one this must be very popular select that then the next in is repair the name of my file so I wanna check that once that is checked everything is checked now I just click on install here and that is it is installed ok same is about make changes to the solution click on OK here and click on OK this from you see that installing the system data SQL alright ok we're done now so I'm gonna close that I don't need it anymore so back to my project so let's double click on the form itself never click on the form and right pop you have any photos photos to write above above public I say import system dot okay there will be data and that will be dot SQL SQL SQL light still you and that's all there is to that so I've imported SQLite on board okay now guys that will be imported SQLite I'm now going to go to mine put a fun load right here so what I intend to do on the form load is to connect to my SQL so I'm gonna say Dean ornate as sq as new sq lights connection that will be for connection SQLite connection connection should be the assembly there we go double-click on it yeah as it have imported when I intend to use so I'm now going to say dot okay open a bracket and I now need to use data source is inside now let's just go for where my data is of good old foot go to the area we are saved my data you say is safe right inside my project calls VB student SQLite database we don't click on that and right there does the student data okay now we'll come up here you see the name of my project right click on it and I've done copy address as text yeah I've copy that address come back in here and I'm gonna paste that there now the name of my projects as we all know his course students as the name of the database some input backslash here and then enter students dot d B that's all ok I've imported the the table now the next thing I would do is let's open it up say it's very poor name dot open and type parentheses I would also declare another variable this variable will be for the SQL command itself Samuel call that SQL command so that would be the name of my variable okay and I'm smallest like an object I'm gonna say as new SQL SQL command there we go so double-click on that and this SQL command what I want you to do is to connect this small connect so I'm gonna say copy that SQL command do this for me dots connection grant also connection for this my variable called connect there that is that done now whatever takes I have as well I want the SQL command towards context let's say is equals as follows select all from my database call students okay now the next thing is I want you to read so I'm gonna call that SQL reader that's another variable read so did a scale read us as SQL that would be data need the other good it's real and I will now say this data reader should do the following ask you a light command but I declare here that as kids reader okay now let's do one more time the next thing is a lar need the data data table so let's I'm gonna call that SQL data data table okay so that is my variable let me just call it DT DT SQL DT I will stands for my data table and when I say ask me data as new data table just like we have in the other one okay so we have the connection part to feed you have these acute or no data table all right so which now say data table I would like you to load as follows okay I want you to load the reader open a bracket and what do you want me to do load up the reader so test you tell SQL read right yeah it should load up with the now that we've loaded of the read okay okay all of those ones are done so the next thing is less close-up as to your reader dot please now also close my connector here just because I hear that close yeah now finally by day to grill if you guys can still remember with degree v1 dot data source right here and the data source equals SQL DT this one data table and they will go does it now if I run it now you guys from see anything because I have an entire any record on my SQL so let's open them up on the Brad let's open up the browser will open it here that's it let's go to to browse student to deny the gospel CC are the Costco name to Montana redness on the 78th nurse business 90 biology chemistry and just populate that sexy computing English physics okay okay let's run the system now and see how it works there we go guys you can see all of the information on the data grid view and that is that of Tony Montana and some other candidate that event idea details alright so now that we have we've got the data preview working the next in our lights abilities we whatever information is entered in here I would like to be able to click on student result and populate that and the data reveal and also to be able to click on the transcripts you see whatever we want then the leads I would only need to walk on those three buttons now okay okay before we continue with the coding let's rearrange this interface I'm gonna select this three you just move it this way yes throughout these write about depth and maybe bring this in a little bit here maybe this let's move this so Tim does the thing that would do and these two [Music] okay that's fine then the next day I'm going to do is to double click on the form and let's add something to that there are very cool box from Oakland right here right inside from her the wonderful combo box will be as follows so let's say combo [Music] and that will be here cause good [Music] items okay let's get the attendants cc0 eight seven that would be the cost code for the combo box I think I'm gonna add a little bit more less at about five more [Music] okay so let's just change that around this would be one [Music] and maybe kid total lv7 seven different calls per day right now okay the next thing is less coming to student risotto click on that and inside the student results I'm going to declare an array so I'm just gonna call it R equals 15 let me declare that as an integer right okay for this array let's say R 0 array number 0 that would be equal to by quadrant I wanna make that txt oddness dot X I'm using by value just in case it is not indented in here the value will default to 0 so on things just copy are they the same thing for the other second subjects and yoga the other seven subjects are now taking care of now the next thing I like to do is you can write down here out of all of these values so let's say i r8 8/8 and zero plus r1 correct that well I just wanna just hope you dance plus an one [Music] paste paste and paste let's change the numbers around then this would be one [Music] to [Music] three it's there were six and seven so that's seven and we have six year but so that we would be added up together average so let's enter a bracket here and here divided by eight because we have its subject in total the nesting is going to be let's go for array number eight a real name no changes to man and just give it up this day alright so the other thing I'm going to now do is to outsiders eraser let's say average average of text equals array number eight okay so that is fun because we are an advocate then let's say to tell still total total school bloodstains equals I remember now I did okay the next thing I'd like to do in here is to is to allocate whatever ranking let's say if terrain I'm his lathe Ovilus is greater than is greater than 700 then let's say if is greater than and equal to 7 under it then what I want this system to do is see XT ranking dot X equals that will be first class right else we'll copy that let's say L speech let's use a nested if-else if-else issues from instead of master days okay that still gives else Eve a space letting it know disciplining as conceived if is less than 6 yes 600 greater than equals to 600 dots would be 2 1 and the same thing for this floppy that's only for 500 - ready - to change a decimal as well this one - but / - 2 and finally no not really if is for Android 400 will be third class [Music] and [Music] about 300 300 300 with the certificate of our education [Music] let's see if it is less than they said less than equals to three 200 with less than an equals to 200 and that will be fail okay okay the next thing I'd like to do now that will have Nissim board I will now like to add mine the location of mine did B so first of all let's just comment it out so that is no error right this is just to determine whatever great great the candidate the student have so let's come right down here now I'm going to declare as follows as a team as mean [Music] pesky lights the skew lights connection right here and this l-squared sqlite to mention is going to be right inside here let's find a location of mine a safe data source where my data database is actually officially located let's find that all right so let's plumbing air right here that's my file and that's my database so now hold on to your shift key right click and right-click on your database unless select copy pods there we go now come back here and just paste then the right click and paste er that you see that paste that is the part that is my part right there scared of this yeah that's the part under the database itself everything is copied that's easy ok the next thing we want to do is let's say connect mine connect dots that is supposed to be mine an instance connect out open now let's declare another pair of edges are available is going to be known as SQL command as mean as q-l light SQLite SQLite to my right there dopinder an SQLite command is claimed to be equals to rescue lights man dots next I don't want you to I just want this so glad of that okay equals say that's a net that collection equals net right dance down I'm going to now use this SQL command don't command tags and what takes violence like hits to you to insert inset into student that is my database now all right through let's enter the fields so the first field is going to be student ID and let's enter column day then followed by cos cos port yeah and the other fields there we go now what I want to do here now is gonna come right here let's say we have the following value and those values are gonna put them all inside or as well as should be inside I say abs record so the very first record that would be student ID is everyone so the second record clock eleven you saw me just copy this the clone idea number two number three another three beautiful [Music] six seven okay so eight and just bring me down just bring you down from here right [Music] eleven - have up to 15 that I intend to to use oh my parameters will be up to 15 so that is fun so let's close this year right so right underneath you and I want the SQL command itself to add the following parameters so they say dot parameters dot add good value there we go what you want me to add value I want you to add the very first that there one record one comma and the record one is what Rama is going to be txt okay let's get student ID student ID dot Thanks so I've just added a very first one so now we'll copy this just repeat and add 15 our 14 of those now just change the names around and the next one is going to be post food see in the Crossgate gospel attacks now followed by first name [Music] we have sworn in lips and so on so let's be down all right this is how it looks like now and I've also changing I've also joined the members okay now one other thing that we need to do is we need to then close it say and I that close what has the we need to do let's say this yeah SQL command dot as cute as photos right there is a cute and query and the parentheses now finally I wouldn't like to call let me invoke my form as a me doubts at debate and I said me not activate I'm actually talking to the form yourself there we go supposin add a message box here just to validate the father's something this is Latin dancing messy box that's show before so I can then say student record update it [Music] right Here Come students who has the name bread and yet a team Liz Arden order this item out of her happy today and does seem to be message box but then that's okay and one more come on I see I said box icon built information the okay does it say let's have a good look at it before I continue diverse correct so I'm going to now run it it's just like these other lines of code for the students results here that we just calculate to whatever power you have okay say see that if I decide to comment this out the sacrament is acute out look I was gonna happen this right now delgo I've already entered some other data's and the database itself but let's enter something here I just want you guys to see what's gonna happen when you have a course code select and the name of the student this is Sally Sally the stylist yeah female [Music] page one and verse 15 [Music] okay food mobile phone Sally and spoke okay [Music] aaseesh [Music] right so if I click on student results what you will see is used get the total average and the ranking there we go look at that Sally's actually 2 to 62% overall there okay so I should be able to click on this and we see the record day there are solids record right there alright so let me show you guys this I'll show you this transcript then I will uncheck this so that we can add it to database okay now we can then add it to the database all right well first in first let me show you the lines of code for the transcript okay let's double click on the transcript and right there here are the lines of code for the transcript I just have to speed them up because of time yeah it's very simple have a look at that all you need to do is call the objet and are pained then enter whatever you want to enter okay I have some lines yeah let me just increase the seconds and here I have a tab tab and the name of the object intend to call yeah that's it that's all about this transcript now there's something I need to show you guys right up here before in the disapproval so right up here if you look at this select from student or the by descending order I've now added an ID to my database so let me show you guys the database right here let's open up the database students there we go there we'll select that and let's go to modify inside modify are added an ideal student ID another student ID is now my primary key okay it's not it's not a big deal as what you doesn't take care of all it just need to do this add a new field ID is ID d they'll go okay you can also just select and just move up filled up that was what I did they so I'm going to delete that yeah okay that's easy so that's my it's now my primary key okay so let's go back to my program so I just minimize this alright if I run the program this is what you guys you see right there you can see my table is actually in descending order okay and if I decide to take that out let's assume our come in here and get rid of this let's just painted atom commend this out run it again this is what you guys you see let's see there we go you can see it is now in ascending order okay not ascending or descending order all right so one more thing to do is just take care of these delete so let's take care of The Glades then we run the program Komachi me a double click on delete alright these are the lines of code for deletes the variable was declared on this variable is assigned the data type of an integer and in there but then assign my day to review okay and there then the SQL command is delete from the students and whatever is the live show deleted from the students we then check the ID okay if the ID actually large days then the system will get it executed and that's all there is to it now then call the form to activate that means just refresh and that's all there is to it so let's try it out now so I'm gonna run it enter some data into it before we try out the delete there let's enter some data here so the student IDs when doing s whatever does student ID then you select course code student name this is Felix Felix Felix Wally schirra is a male student and age is 21 I pressed number 13 daily close right poor scored by number and what about okay that's it and there so I just need to do is click on student I'm right there guys okay there we go all right we can publish it here the transcript okay this seems to be true you may have to delete some of those and right in here let me show you the database there we go guys look at that look at that that it's beautiful gasps Phil looks details day you see that guy's exactly was under strange Frankie right okay that's fine so let's try out our delete let's look for whatever name to get rid of here there's posing on of the real dope hey let's get rid of Sally right there and come to come to delete right here let's click on delete and right there guys let's see there we go Sally is out of the same you can see okay now let's check the database to verify flawless today so come on and let's come in a file while they select the data browse to them and their think yeah there goes Sally's gone we are flexing else and Sally is done all right and a crying giant to become a member of the channel there are a lot of benefit to be gained if you're a member of this channel so with that I'm gonna call it the end of this tutorial please subscribe and like you guys have a nice day bye bye for now

Channel: DJ Oamen

Views: 12,141

Rating: 4.8947368 out of 5

Keywords: Create a Student Database Management Systems using Sqlite in Visual Basic.Net, Student Database Management Systems using Sqlite in Visual Basic.Net, Database Management Systems using Sqlite in Visual Basic.Net, Database Systems using Sqlite in Visual Basic.Net, Visual Basic.Net Database Management Systems using Sqlite, Visual Basic.Net Database Systems with Sqlite, Visual Basic.Net Database with using Sqlite, Anthony Joshua, Old Town Road, Nas

Id: ld9M0bQmHDY

Length: 68min 20sec (4100 seconds)

Published: Sat Jan 19 2019