C# With SQL | Insert Update Delete and Search(CRUD) in C# with SQL Using ConnectionString

welcome to my channel swift law on this tutorial I'll show how to insert update delete charts in SQL Server database using connection sting [Music] start Visual Studio click on file new project yes windows for application location see my test project folder name the application I just put the application name is test crude test crude under scruff click on OK ok this is the form different form form 1 now I'm going to design this form with 3 textbox control and 4 button control to perform insert update delete charge separation first of all I'm going to add some level control to define the textbox ok now first level is ID and name and is that level control it's looking very smaller so make it bigger so that it's looking perfectly okay now in the header I just write insert update delete charge and ask well okay title size font size is 20 and font bold is true okay now I'm gonna add text box from the tool box to add text box go to the tool box and just Jack the text box from that tool works to you in his for application and font size is podding okay I just call him face to be do same time I just added three text box tigress want I groups to type of three tactics for and about own control the button this button is far from the insert operation I'll insert data and SQL using connection sting okay the back color of this problem is yes in and the bottom back color yes now there are the bottom click event yes add servers were to go to menu click on server Explorer there's no yes service added now just right click and add connection sorry I am just adding creating and ask us about database if you have already created database then you can just connect now I'm just select the server name and database name I just peered at the database name my task DB click on OK and now I'm gonna add a table right-click on a new table ID ID is data type integer and name and worker is float is it were float will allow this Mel okay now ID is primary key say the name of the stability user tip I'll insert and update delete all the personal phone in user tab table now there is no record in this table with a form and button click event now SQL connection right now I'm gonna connect with database using connection string okay SQL condition corn equal to new SQL connection you should add namespace you need system to data data SQL client is the let me stress is added now or you will get the connection listing to get the connection string in first of all just select the database and go to the property window and you can see the connection is string data choose just coffee the connection string and faced it in the SQL connection double Cartesian yes invested that this is the connection listing now it's connected with my database now I am gonna perform the insert operation in that case SQL command CMD equal to new SQL command here at the SQL command to perform insert operation and ask yourself a delta P this is simple SQL command is insert into my table name is user tip and value is column name column are ID name is the first column is ID second column is name at that of ID at the rate of name and at that is from her I get it ID name is ID from technical name from tigress to and a sperm tax box TV in that case I have to declare the text box CMD dot parameter dot add weight value I at the end of ID ID from text box one you know that the ID is integer datatype yes the ID is in degenerative so I simply text box is the string type in that case Barker time unit case he should convert it to integer integer dot far text box 1 dot txt but name is distinct type so no need to convert it to integer or anything just name is textbox to dot txt I just call this to reducing time you can hopefully you can further understand it okay the age is the flow data type in that case you should convert it to double because it will allow decimal ok textbook 3 dot text finally so first of all we should open the connection SQL connection con dot open just to write condo to head low and ok now CM d dot execute non quitting executed on query used to insert update delete in SQL Server using connection listing finally after submitting after inserting a record it will display a masses to display the masses just right message box not show masses box dot show successfully inserted what messes you are writing here after inserting record it will display the masses successfully saved just be bug yes now ID one name Michael is 25 sir successfully saved yes now check the data be stable just execute yes one my Killa is 25 is added now I'm gonna add a baton got to update record in SQL Server database using connection lasting change the text of this burden update go to the event click event double click you can get a quickly given by double-clicking since the backer of this part of update a bit ready okay now I just copied the connection if you used if you put this connection out of the even then no need to call in its event okay now SQL command I am just writing update command in this pattern in this click event ok update command is just update user tab is active table name update is a tip yes said name equal to name at the WL Diggler later and is equal to at that of is why our ID equal to at the rate of ID I just think like variable color you see MV dot parameter dot ad with value just coffee from the Bob event simple okay everything is it just change the masses after far from the update of Russian it will display a successfully updated execute debug okay ID 1 now the name Michael age is 25 I will change it the name from Michael to Shahrukh Khan and it is 55 it successfully updated okay now just execute you can see yes it's updated the record is successfully updated now IDs primary key and primary key can not be operated cannot update primary key column you can update another column according to the primary column and I'm going to add another button control to perform delete operation change the test of this button delete and since the back color I go to the click event I will perform the delete operation using ask connection string okay as well I just call it as the connection correction is string and then now SQL command CMD equal to new SQL command I am just writing the SQL command command is delete is active is at the base table name delete user tip fire this is very simple ir ID equal to at the rate of ID so we have to declare only ID c md dot parameters dotted with value at that of ID equal to integer dot first tigris 1 dot txt ok done now just CM c md dot execute non query finally will display the masses message box not show successfully we made it close the connection Condor close okay now just debug no display an error oh sorry i forget to put the semicolon ok done now there is a record wash Shahrukh Khan is available now just put one click delete successfully related and the record is delighted execute yes there is no record it was a single record and I'll also deleted it and now it's needed ok now I'm going to add some record to check whether the button is working well or not yes one term 70 is added to team Hardy it's also successfully saved okay now just execute yes Tom and team are added now I'm going to update one Tom - Michael successfully updated and the second record to team 30 I just delayed the record - and update the first record see yes it's updated okay now I'm going to add another button control too far from the charts operation look to load data in grid be dead a great view from a specified database okay change the button back color now go to the click event yes as well coffee the connection is staying I just used the contrasting in yet event because if someone see one event then you cannot know hey you cannot get the connection string from where I call the connection listing that's why okay now just to write the comment to load that in debt agreed pee in that case my command is select a star prom user tape yes command is done now just SQL data doctor use SQL data after di equal to new SQL data after caller CMD okay now data table DT declare a data table new data table okay now feel their D I mean SQL command in DT D a dot field did you finally data greedy you oh I didn't add a data grid payment form so first of all I have to add the directly in the for Windows for application and data give me to display the data from database just drag the data grid view control from the toolbox to and drop it to your form now just to write that I give you one dot data tude okay okay not done now just execute debug yes just click on charts there is only one record and it displayed in the grid view now I'm going to add another record - Tom is 70 insert another record click on charts yes it's added the name is C John is 25 and sir yes the record is also inserted now I'm gonna okay now I'm gonna show you how to use claws to charge data in datagridview in that case I am just using a higher cloth for ID equal to at the rate of I T in that case you should declare the ID at the dividing and so as usual seem did your parameter dotted with hello and there at that of ID what I integer dot first tigress wand or text ID will get from the tiger so on okay yes - yes displayed second display third what I am testing

Channel: Swift Learn

Views: 43,461

Keywords: swift learn, crud c# sql server, sql server, c# tutorial, insert update delete in c# using sql server, crud in c#.net, crud in c#, insert update delete and view in sql server using c#, insert update delete in sql using sql server, insert in sql using c#, update in sql using c#, delete in sql c#, search data from sql using c#, insert, update, delete, view, c# crud sql server, c# crud, crud, visual studio code, crud c#

Id: aer8S1fFbNc

Length: 17min 2sec (1022 seconds)

Published: Fri Feb 08 2019