I have a database which is in another machine of my office network. How can i access that database from my program running on my machine(which is also in that network).

Just name the server in your data source connection string:

"Data Source=SERVER_NAME_GOES_HERE;Initial Catalog=DATABASE_NAME_GOES_HERE; ..."

You can use a UNC or mapped drive letter just like your local C:\ hard drive.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.