how to use sql along with vb.net

I am doing this for the first time, how do I use SQL via vb.net to insert, update and delete data in the database. Do I need to set up anything before I can use SQL? If I shift my executable app to a different computer do I need to install SQL in that com开发者_Python百科puter as well?

There are a number of tutorials which can get you started.

As for running the applications on a different computer, it depends on where the database is located. Generally the database and the application are two separate things, the latter is simply accessing the former. Can the other target computer also access the database? Will the database be installed on a server accessible to the target machine? As long as it can see the database and its config file is correct, it should work fine.

This question is pretty broad. It's like asking "How do I drive a vehicle?" There are many different types of vehicles: boats, cars, rockets, airplanes, skateboards, etc. To tell you how to drive a vehicle we need to know what type of vehicle you want (or at least whether or not it's a land vehicle, water vehicle, etc). Likewise, there are many different ways to "use SQL via vb.net". Do you want to do Web development, standard Windows apps, console apps, WPF?

The best starting point is probably to learn pure ADO.NET since all of the other methods are built on top of it. Learn the basics before getting into LINQ, Entity Framework, etc.

I'd start here: http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx