Link to home
Start Free TrialLog in
Avatar of Zac123
Zac123Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Good tutorials for Visual Basic

Hello, i'm trying to learn the basics of VB.
I have installed Visual Studio 2019
I have installed MySQL server and created a test db with a table and column.
I have connected the studio to MySQL successfully
I'd like to master creating a form and inserting, updating and displaying the contents of the db table.

I'm struggling to find a decent video tutorial of this. like how to program the save button and insert it into the db.

All the videos i find are either in very bad English or they describe very different methods from each other so i'm not sure which one i should be following.

can someone point me towards some good material please?
thanks
zac
Avatar of gr8gonzo
gr8gonzo
Flag of United States of America image

My own personal advice is to not invest your time into VB.NET. Microsoft recently announced that while it would still be supported in .NET 5, they weren't going to be growing the VB language anymore.

While everyone has different takes on it, you'll notice that you'll find far more support for C# in terms of community and code snippets, and Microsoft continues to add new features to C# all the time.

So if you're at the beginning and learning a .NET language, you'll probably get more value our of learning C#.
In terms of the .NET connector for MySQL, you'll find different methods because they have different scenarios that they address. Sometimes you want an ad hoc / freeform query. Other times you want a prepared statement. Other times you might want a bulk insert. There are different techniques for different situations - I would generally recommend using prepared statements.
Avatar of Zac123

ASKER

Ahh ok this is useful info thanks.  Ill look up prepared statements.
Tbh i only decided on VB because people said to me that it was a little easier to learn but i think youre right. Ill start looking into C#
Thank you
In addition to the above mentioned comments, I would strongly recommend looking at:
https://docs.microsoft.com/en-us/learn/ for beginner tutorials (some advanced tutorials are there as well)
and
For detailed documentation, visit: https://docs.microsoft.com/en-us/
Both the links will require you to pick up an area, for example for Desktop app development, you have to go to: https://docs.microsoft.com/en-us/windows/apps/ for web development, https://docs.microsoft.com/en-us/aspnet/

Also, if you are trying to master CRUD operations with database, I would recommend you have a look at:
1. LINQ - ​https://docs.microsoft.com/en-us/dotnet/standard/using-linq
2. Entity Framework - ​https://docs.microsoft.com/en-us/ef/​​​

All in all, if you are starting out, these are great starting points. Once you have understood the basic concepts, you can choose advanced training content within Learn / Docs or can find some external resource.
Well, that's debatable. To be honest, I think people believe that the word "Basic" in the name means it's easier to learn. I used to think that and I actually grew up learning C and VB 3.0 classic (before .NET). Back then, VB was definitely easier to learn than C.

These days, I personally think C# is actually a little easier to learn. That's my opinion but I'll say that C# also has the advantage of having a syntax that is a lot like some other popular languages. It's sort of like learning Spanish and being able to read a little bit of Portuguese and Italian, making it easier to learn those other languages, too.

Meanwhile, VB is more like English. The only comparable languages are other versions of English (e.g. British vs. American English). For example, the more practical use of knowing VB would be knowing how to program in VBA (the macro language in MS Office).

So while there is still some value in VB, I personally think C# will take you much farther.
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial