I have developed a simple C# program in Visual Studio 2010 which has a database which is on my PC, everything is working fine.
But now I want to put this database on another PC or say on vmware, then I want to connect to it from my PC.
How could I achieve this please explain
To achieve what you want to do there are 2 step to follow:
1) Configure the network options in VMware: Documentation - Tutorial
2) Change your connection string accordingly: Here is a link if you need help