Switch Statement is the same as If…Else Statements except that it is easier to use if you have multiple conditions.
Switch Syntax

Hi this is Vb.net connect sql server using TCP/IP before run this program you need to install a vb.net 2008 and sql server 2008 here in example code:

Hi you need to do this
click all program/ ms sql server 2008 / configuration tool then click SQL server configuration manager
select you server name then rigth click properties you need to enable a TCP and IP add then Restart

"you need to do this VB.net is computer 1 and sql server is computer 2 same both installation of sql server"

Sometimes we need to store some data or files under %appdata%. If you are using Windows 7 you can find this folder under C:\Users\Username\AppData.

AppData is a folder used to store information like cookies, Libraries, program settings, temporary files, templates, etc.

By using this folder you are certain that your settings are being protected by Windows.

To access this folder, all you have to do is use the following code:

If you are working with SQL Server Management Studio Tools and encounter the following error when modifying one of your tables:

“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”

All you have to do is unchecked the “Prevent saving changes that require the table to be re-created” under the tools menu.

Follow the screenshot below to disable it.