how to connect c# window application with sql database during installation on my friend's pc

try this
Adding connection string during installation[^]

The only technical thing while connecting your database to an application is the connectionString that tells your application the actually destination of the data server, from where to access the data. SQL Server is actually a server that provides you with the data from Databases and so on.

You must be able to write the correct connectionString. Data is not liable to be present on the very computer you're actually working on. It can be present on some other source. (as in your case).

Here, connectionString would work, and you can provide the server address (name) to it, and the database to connect to.

Go to: http://www.connectionstrings.com/sql-server/[^] and you can see many connectionStrings that you can use, to refer to the data source. In every instance of the connectionString, there is a section (attribute of the connectionString) titled as Server. This attribute describes where actually in the world of computers, your server is located. Write the address of the server, local or remote, in that attribute. In your case, you are going to connect using IP address (or more options can be used from the site)

http://www.connectionstrings.com/sqlconnection/connect-via-an-ip-address/[^]

Upon connecting, the application will make a request for connection to the address, and the following would go as you code it out.

Get the Connection string using UDL file

Open Notepad and save it as "ConnectionContext.udl"


Now open that file (ConnectionContext.udl) -> In provider tab select "Microsoft OLE DB Provider for SQL Server" (Not mandatory you can select your suitable provider ) -> Now click on Connection Tab -> Enter Your Server name and select your authentication mode if it is server mode enter your user id and password -> select your database -> Test Connection -> If Success closed the windows

Now open that udl file in Notepad you can see the connection string


If your two PCs are in same network / Work group then you can connect it by using windows / server authentication. but for windows you need to mention port no ( you need to add this port in firewall Outbound Rules.