Build a Currency Converter using C# & SQL Server | UI Design Tutorial (UI Design) 🔥 [Part 2]

This time, instead of using static data, we are going to learn more about database and how to communicate with it using the Structured Query Language (SQL). Check out the Complete C# Masterclass for the part 3 of the Currency Converter Project

This user interface tutorial is all about how to use C#, WPF, and XAML to build a Graphical User Interface. In this particular case, you will learn how to build a Currency Converter.

There are two parts to this series:

▶ In part 2, you will learn how to build the Currency Converter using SQL.
The main advantage of SQL is that it allows you to build your own database, tables, and enter data to it by using an extra GUI that we're also going to build. It is extremely useful manipulate the data, as much as to store and retrieve attributions in tables, with commands that will be used to accomplish almost everything during the working project, such as “Create,” “Insert,” “Update,” “Delete,” “Drop,” and “Select”.

Tutorials.EU offers you free video tutorials about programming and development for complete beginners up to experienced programmers.
This includes C#, Unity, Python, Android, Kotlin, Machine Learning, etc.

#CurrencyConverter #CSharp #UIDesign #UserInterfaceDesign

[kumikumi]

Thanks for such a good project. I've gained a lot of experience!

[mcnuffey]

Thank you for this Denis! Also for anyone considering buying the C# Masterclass course, do it!

It has honestly helped me so much! Although there’s a few things that I wish were included in the different sections, mostly examples of how to do certain things.
But it is hands down the best course out there that will teach you a LOT!

[dragonfalcon]

I very much appreciate the time and effort you put into this. Thank you Denis.

[christo]

Thank you for this. I am on my way through the C# Masterclass. The amount of work you put into this is very appreciated.

[jonathanqoqonga]

How awesome, telling us the code is on your site, only to find that it is not there. Great job.

[claunko]

ty Mr. Panjuta. You are an excellent tutor. I'm on 65% of your course on Udemy. It is very resourceful and thorough. Hoping, one day Ill manage to do everything with as little help as possible. Ty

[elithor]

Denis i loved your c# masterclass course it thought me better then our teacher xD, PLEASE ! make a .NET Core Course, asp, mvc, restful api, i would buy the course ! you are the best teacher i ever witnessed, your speaking your exercises, everything is so greatly presented. I like the way you speak, without rushing, and everytime seeing you smile in every intros and outros makes me smile too, just by watching your course i feel motivated and positive aura ! All the other courses of other people i saw and tutorials are so bad, everything is so rushed and boring and without explaining the details, they even sound like reading from documentation and they dont give any exercises and possible variations. But your course is the best and you explain so well! i really loved your courses ! please update more and more your c# course and maybe do .net core in future ? sorry for my english, and wish you all the best !

[tutorialsEU]

Create a program, an app, or a game from scratch with a Complete C# Masterclass
In this course, you are going to discover how to become a c# developer - one of the best programming languages on earth!

C# is one of the few programming languages which allows you to create amazing cross-platform Mobile Apps, Games, and PC Programs.

Bringing an Idea to life is one of the best feelings one can have, but the path to get there is often full of challenges. So I have created a course that makes this path as easy as possible all with the help of c# so that you become a skilled c# developer!



See you inside the course!

[mrpaulum]

Di Denis,
Great stuff! I am following the full course on Udemy and must say I'm enjoying it a lot. Thanks a ton.
I also wanted to mention that I think the link to the code points to that of part one.

[TheByteCraft]

This solution isn't correct, it is binding the ID number of the currency to its value for the calculation, in the test at 1:22:37 you convert 111 from USD to FLORINE with USD=12 and FLORINE=123 which should do 111/123 * 12 = 10.829 but you get 83.25 because it's using their IDs 3 and 4 so 111/4 * 3 = 83.25

For me I fixed it by changing the query in BindCurrency to also select Amount so "select Id, CurrencyName, Amount from Currency_Master", set Amount for the newRow and then set the SelectedValuePath on cmbFromCurrency and cmbToCurrency to be "Amount" instead of "Id" and that seems to work.

[richardchu]

Great tutorial Denis! I have also bought your udemy classes! You are great!

[kurnjeri]

for for the host in your website please. i cant find the code.

[bassilarafat]

helloO, is in nowdays we replaced the DB connection objects with EF ?

[ArMaAa]

The program does the calculation with the IDs for me, so it does it like: ID_OF_TO_currency*entered value/ID_OF_FROM_currency.. Pls help :/