C# Database Programming for Beginners | Part 4 - Insert and Update Data Using Controls

In the final video of this series, we implement INSERT and UPDATE SQL statements in our C# code.

We also use ListBox, TextBox, and Button controls to display and manipulate data.

[zhrgci]

Starts with: well that was easy
me: *dying inside*

[Thunderbuck]

FANTASTIC tutorial! I've puttered around in code for years and know enough about relational databases to break them spectacularly. Great material on the need for associative tables and what they do, and how to handle db operations in the UI.


Even liked the goof-ups (and I made a couple myself following the tutorial); great examples of how easy it can be to go wrong.

[wormlord]

Thanks!! I just landed a fucking sick internship thanks to you. All the old people think I'm a computer wizard. I'm a computer squire.

[bito]

Great video, really useful. At 10:18, Line 83 changes from command.ExecuteNonQuery() to command.ExecuteScalar(). Looks like the video was cut, no explanation on the change - Why did you change it?

[egorputintsev]

Thank you, you saved me, the best lessons I saw, clear and simple. Enjoyed it. Thanks again from snowy russian syberia ;)

[albertorlinski]

Very clear and in a good quality tutorial. A piece of good work, thx.

[rupeshvaingankar]

Gr8 Sir, Nyc Series ... Enjoyed it !! :)

[danieljoldenkamp]

Very Awesome and helpful! Thanks and keep up the great work!

[vitalydushko]

Thanks to author a lot. For anybody who is going to make it with WPF instead of WindowsForms, here is the difference:
listRecipes.DisplayMemberPath = "Name"; // Instead of DisplayMember
listRecipes.SelectedValuePath = "Id"; // Instead of ValueMember
listRecipes.ItemsSource = recipeTable.DefaultView; // just adress to DefaultView property not just to the Table
I faced that When I was doing the exercise on WPF, maybe it will save the time for somebody

[benyamindashtestani]

Hi. it was a great video
i have a question
if i published the form i made this way and send it to my friend can he use it without needing to change the code for connecting to his own server?

[drbikang]

I have "An exception of type
In my case, a line should be added... in

private void sender, EventArgs e)
{
lstRecipes.ValueMember = "Id"; // This line added
PopulateIngreInRecipe();
}

Thank you! Great Video!

[guzzar]

Very good tutorial, I just have one question. Why do the new Input data (we Input while Runtime to database) evaporate after Re-Start?

[johnchuang]

Thanks for doing these videos,
Really helps a lot !!

[mazkaibil]

Awesome vid! I was wondering if you can make a video with calculations. For example, making an invoice with tables from SQL to calculate subtotal, Tax, and Invoice Total! :)You're the best!

[FarazNaeinian]

Thank you for your great tutorial, keep on the good work (;

[usedbandage]

Could anyone give a more in-depth explanation on using command.ExecuteScalar() vs command.ExecuteNonquery()? Change happens at 10:18.

[anggafs]

would like to like these video 100 times

[waljib]

great videos - I have a question.  How do you navigate from 1 form to another.

[numananjum]

how would you create employee attandance system with database including other daily basis information about employee . where you have to update each row including employee hours etc on daily basis.
would you create a table for each employee? and how would you reset all records on last day of
Super series btw.
subscribing...

[antoniown]

I hope somebody can help me with this but I can't seem to auto update the lstIngredients box depending with what I click? For example, If I run the application, I see stuff in the lstIngredients listbox but when I click another item it doesn't update to what should be on there. This happens around 6:57