CRUD Operation in C# With SQL Database | Insert, Update, Delete, Search Using ConnectionString

[@lahirurashmika2033]

You are my time saver, thank you, I got stuck for more than 5 hours doing that based on the guide of the institute in the final project. Thanks a million!!!

[@sarahsarahhh2144]

Thank you very much. I have been searching for a video concerning this topic and I just found it and It's really simple and easy to understand. Thank you alot

[@sudeshejayasinghe8937]

thank you so much! I couldn't find how to do this in all over the internet.

[@harshanierandika5920]

thnk u very much.u r solve my problem.thnk u again and again.

[@SwiftLearn]

You are most welcome.

[@rowshanali3136]

Your video is really awesome. its all in one and helps me a lot. thanks for uploading this helpful tutorials. one thing is if you include different types of control it would be more batter. after all one of the best.

[@datacustodian]

Awesome, just what I was looking for.

[@SwiftLearn]

glad to see your comment. you are very kinf . please keep connected.

[@atlantisuds6625]

Thank You. This video help me alot. I was finishing my task with this tutorial. Its simple and easy to understand

[@zubaerhossain3203]

Thank You Very Much ,,We want more Tutorial like this.

[@SwiftLearn]

Keep connected....

[@vector_vector__]

@@SwiftLearn what if i add Datagridveiw to the design and connect to database does that work ?

[@ilhamsikumbang8146]

awesome, thank you for the tutorial!!

[@SwiftLearn]

You are very kind. Thanks for your comment. Please keep connected.

[@AdiTimes00]

very useful video thank you😊

[@SwiftLearn]

Glad it was helpful! Please keep in touch!

[@globalinvest9275]

Excellent tutorial. if its added image also than it would be more batter.

[@shungari_remix_hub]

Thanks a lot... It helped a lot

[@SwiftLearn]

Glad it helped. Please keep connected!

[@Shmevin]

wow thanks for the clear expiation

[@SwiftLearn]

Glad it was helpful! Please keep connected!!!

[@infosandfacts7536]

Good Job. Thanks from Germany!

[@thanetnt6269]

2022:Thanks Love your contents very details from good man,keep it up bro

[@etcreations2057]

Thank yo....so much bro..👍👌🏼👌🏼👌🏼. Helpful for me

[@SwiftLearn]

Always welcome. keep connected

[@DukehsuPh]

In the video at 09:29, there is a small issue with the SQL update method. If there are multiple rows of data, all of the data may be updated. ``` SqlCommand cmd = new SqlCommand("Update StudentInformation set Name=@name, Age=@age, Coures=@coures WHERE id = " + textboxId.Text , conn); ``` I added WHERE. hope it can help you😃

[@SwiftLearn]

Sure.

[@harshadevaka6788]

was very helpful.thank you♥♥♥

[@1ntegro]

Awesome, helped a lot

[@SwiftLearn]

Glad it helped!

[@rodrigolnl]

You missed the part about how to run SQL server to begin with, and if someone is looking for CRUD, he is probably newbie and it is a hell of a job to configure the server with visual studio.

[@mohamedkunle528]

U right

[@kenballard2039]

I'm having this issue now. And I have no idea how to get around it.

[@SwapnilSaheb101]

​@@kenballard2039 which problem facing?

[@SagarShirke09]

Not that hard

[@wafaza7934]

your are great man very easy and clear explanation thank you so much

[@preethamm.n1161]

Thank u bro awesome 💞🌹

[@SwiftLearn]

Thank you too. Please keep connected.

[@tz_ytacc]

Much respect from me💪!

[@SwiftLearn]

thanks for this comment. you are really great. please keep connected.

[@tz_ytacc]

@@SwiftLearn Thank you too, you're awesome!

[@haniffauzan422]

Thank you very much for the tutorial

[@SwiftLearn]

You are welcome! keep connected.

[@brendaguimaraes1887]

exelente!!!!!!! MUITO OBRIGADA, salvou minha nota 🤩🙌

[@VlogsofJo]

Getting error at cmd.executenonquery();

[@duasanaulhaq6767]

same :[ how to fix it ?

[@swapnilmukkanwar5663]

you have error at insert or update or delete query

[@swapnilmukkanwar5663]

Check your code using breakpoint... as you can check where error generated.

[@qanbar-pucit8534]

This is wholesome Thanks man 🤍🤍

[@hieuanghuu4050]

thank you so much it helps me a lot

[@fastcook3270]

Thank you very match for this helpful tutorial. thank u enough my friend keep going.👍👍

[@bakihanma7705]

why mine is so complicated, in order to create a table I need to manually code it but you can casually just add table in there :O I'm using microsoft sql server and if it doesn't open my visual studio database won't connect

[@aminaali5905]

Great tutorial. great thing is define with annotation. Thanks.

[@SwiftLearn]

Thanks for your comment.

[@chuyasiy8694]

3:08 I don't have a Server Name to choose from, what should I do?

[@SwiftLearn]

try with .\sqlexpress

[@bloodflower]

Press View -> SQL Server Object Explorer. In SQL Server part you will see you local server. Select this part and press F2 to select the name. Mine is "(localdb)\MSSQLLocalDB". Enter this name in add connection form and now it would be working.

[@iddurango7044]

@@bloodflower thank you so much

[@moad83]

You're amazing, thanks.

[@eloytv8639]

its a great video really simple thank you, would you be able to upload the validation for not successfully updated because ID is primary key and primary can't be updated.

[@SwiftLearn]

You can create Unique Key instead of Primary Key to perform update operation.

[@freddyescobar96]

Simply and easy. Thanks Sir

[@SwiftLearn]

Most welcome

[@hamedghaffari8993]

thank you so much👍👍

[@SwiftLearn]

You are very kind. Keep in touch!

[@ntandomhlengi7741]

I wanted to ask, what if my primary keys are set to auto increment and I'm using insert method, do I need to insert keys manually or I skip the column?

[@SwiftLearn]

Yes, You should skip this column. It will be added incremental number automatically.

[@greatmoments7573]

Thanks for ur coopreation dear

[@cyprianfanga.750]

Thanks for the great tutorial. I am having Problem with cmd.ExecuteNonQuerry, someone please help. .. when i remove ExecuteNonQuerry , then it shows it has been inserted but actually in table there is no data updated.

[@bldrun1504]

If you want to search for something else instead of everything in the database just swap the query with your research query

[@rajdipdas316]

After click on the create new sql server giving the server name and new database name It is showing like create Database permission denied in database 'master'

[@SwiftLearn]

Create database and insert record. check it's OK or not.

[@qwerty89993]

Thank you man!

[@SwiftLearn]

Welcome. You are really kind.

[@mahmoudshafee6098]

Thank You Very Much

[@SwiftLearn]

Thanks for your comment. keep connected.

[@LuLu-ge8vl]

so helpful thanks~~

[@SwiftLearn]

Glad it was helpful! you are great! Please keep connected.

[@saayoo3479]

That what I want easy short understandable.

[@raveendrasothykeerththiga9231]

Thanks a million

[@SwiftLearn]

You are very kind. Thanks for your comment. Please keep connected.

[@zerosandones7547]

how to do crud in c# .mdf with one-to-many database?

[@HasanHayder]

its a great video really simple thank you, would you be able to upload the code by any chance?

[@SciFciSpirit]

superb, thanks

[@mohamedkunle528]

Thank u very match I can’t thank u enough my friend keep going easy to follow and all done thanks❤️❤️👍👍

[@SwiftLearn]

Thanks for your comment. you are very kind.

[@ريهامطه-ض9ز]

thanks a lot eng 😍

[@bishalpoudel3586]

Problem with cmd.ExecuteNonQuerry, someone please help. .. when i remove ExecuteNonQuerry , then it shows it has been inserted but actually in table there is no data updated

[@SwiftLearn]

Executenonquery used to perform insert update and delete operation. Use executenonquery and debug. If you get any error message just reply

[@cyprianfanga.750]

I am also having the same problem with cmd.ExecuteNonQuerry. Any help please?

[@artinmind4010]

Hi why i cant create new connection?? It has no server name option when i click the dropdown button. I am newbie sir.

[@renisrrenis9225]

great no one responded to you over 10 months...

[@arina_dievaca6302]

Same with me 😢

[@arina_dievaca6302]

No responded after 2 years? 😭

[@senshifukushima7623]

Thank you so much for this! can you perhaps make an android Xamarin version of this using c# as its language?

[@clicks_and_codes]

if i want to change value of only name or age then what i should do ?

[@mizantednioc]

Thank you. How do you check if a record already exists during the insert

[@chaithravasista1622]

That's why ID field is made as Primary key. Database cannot contain duplicate Primary key value.

[@JeffKastner]

@@chaithravasista1622 But error handling should still be there or the program would crash if someone accidentally entered the wrong value. He would want something quick and easy like so... try { cmd.Parameters.AddWithValue("@ID", int.Parse(textBox1.Text)); } catch (FormatException) { MessageBox.Show("Please enter a whole number."); } catch (OverflowException) { MessageBox.Show("The number is too big."); }

[@dragonnestseaacadimi]

do you have a toturial that can search IDnumber and it will display the picture of the student

[@SwiftLearn]

Visit this tutorial kzbin.info/www/bejne/nJvJpZWPrtiHf6c

[@furkanbrok6216]

in c#, put data from sql in one column ?

[@stoftronik]

hello, win the window (Create New SQL Server Database) is opened there is no thing in the list (Server Name). can you help please.

[@artopiiparinen1778]

Dude, that update code updates all the rows in the table, with the same values. You need to fix that with "where" statement to update only one row.

[@SwiftLearn]

definitely we should add where clause.

[@sesos1232009]

how can i add if statment in this code to show messageBox if the text Box left emty

[@rylramos9261]

Need to improve separate your form in Add, Edit then call to your main form

[@joshuaanana8673]

how do use the sql server in visula studio? anyone help me

[@alinadeem8947]

What if i dont want to hardcode DB connection string? I want user to input the DB name, user and password for db user. how do i do that?

[@andreymanlapig8584]

I keep getting exceptions from the Sqlcommand by and execute query. how do I fix this?

[@take_the_trade]

Same

[@andreymanlapig8584]

@@take_the_trade just found my problem dude haha double check if ur textbox has .text after it

[@take_the_trade]

@@andreymanlapig8584 got it ... Thanks

[@SwiftLearn]

Thanks for your help.

[@SHIVAKUMAR-mp7ux]

Sir when iam using update query it's showing database is locked massage is showing plz help me

[@davidwenemoser5857]

what if i dont want to search only on ID but leave ID open and fill in the name?

[@shivakumar-ep7gf]

Sir Can u Share Registration from Bcz I Like ur teaching sir....

[@SwiftLearn]

Yes, soon

[@kanyisankondeshe972]

Everything is well, but the data does not get updated. The table is till empty

[@nainicolas4630]

I kept having invalid column name error for the Id on the UPDATE button command

[@samsantos5670]

how about when you are not using int and you are using string how will you convert int to string so that you will not encounter unhandled exception

[@JeffKastner]

You just skip the parse command, like he has for '@Name'... since the text box input default is a string.

[@afeefafzal478]

My server names are not loading, What can i do?

[@SwiftLearn]

Type manually and connect.

[@Quick_Links]

Getting exception at con.open();

[@n1kesjk]

If i put nothing in ID and search it gives error please give the solution of that

[@SwiftLearn]

Just add code if (IDTextBox.Text !="")

[@n1kesjk]

@@SwiftLearn says error : input string was not in a correct format ,

[@zahraahassn686]

I want to search, write the letter of the name, how??????

[@marekhejnowski5266]

I love you

[@saadahaliyu6409]

Pls did not understand how you connect ur database

[@SwiftLearn]

Connect SQL server using Server Explorer in Visual Studio. you can get the connection property.

[@nataliecarr9812]

I am trying to follow your code step-by-step. I keep getting an error when I run it. the con.Open(); is what's causing the error. Any pointers? Thanks!

[@nxson8727]

do u know now what that means

[@ipkun205]

what's u'r server name, if that's backslash in y'r server name try to double it (\\), that was i think, because i have same problem before

[@rameshmadhuranga7429]

thanks a lot

[@Omarit87]

How to make database like this for mobile

[@ddaa-te6rz]

how can restart service sql

[@SwiftLearn]

right click on My PC, Click on Manage, click on service in left pane. click on Microsoft SQL Server and restart. Thanks.

[@ghazagymnastiar]

mantap

[@renisrrenis9225]

there is no data connections in my server explorer..

[@SwiftLearn]

In server explorer you will get a icon to connect to server. click on the icon and connect to the SQL server. Thanks.

[@evashex8611]

The ExecuteNonQuery ... didn't work

[@holidayhotel1523]

Thank you

[@Nisha_Sharma_862]

I need your help

[@ak47zohaibgaming46]

iska source code provide kar sakty hain?

[@nemichandchawala9903]

Syntax error show - con = Open(); This code 'Open()' 👈 the name 'Open' does not exist in this context. Solution? ??

[@mohsinbalochtech]

provie the source code plz

[@jashnkaur7856]

Can I get your email I need your help in one of my assignments?

[@SwiftLearn]

Please to see your comment that you like my tutorial. you can connect with me through facebook.com/rowshanp

[@khanara]

thanks

[@SwiftLearn]

Most welcome. Please keep connected

[@mrwhammer]

source code?

[@dula8199]

Det

[@gnomoleproso47]

too confusing

[@SwiftLearn]

Thanks for your comment. If you please write details about confusion i will try to resolve it. i will always appreciate your comment.

[@eduardwille1711]

Ey I get to be the first dislike! :D

[@SwiftLearn]

Really! Please suggest me, how to make batter for you. thanks.

[@leyoki16]

when I run the code it said that "System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'Table'.'" in line with cmd.ExecuteNonQuery();

[@SwiftLearn]

Check your SQL query.

[@chesterchester3165]

BIG SHIT! {"Input string was not in a correct format."}

[@SwiftLearn]

It means you are trying to insert string into int type. check and write accurately.

[@chesterchester3165]

@@SwiftLearn i do ths same like u in vicdo.

[@46842]

Thank you so much 👏👏👏👏👏👏

[@sometrioeng2602]

thanks