Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

C#.net Desktop Application

Posted on 2011-09-17
Last Modified: 2012-06-27
Is there any way that we can store our data to server using Desktop application in C#
Question by:savsoft
LVL 18

Expert Comment

ID: 36554618
Designing a Winform in C# and Linking It to a SQL Server Database

Author Comment

ID: 36555728
But My sql Server is on web.... i want to store data on web so cani connect desktop application to web data

Expert Comment

ID: 36555946
Remote Sql Connection is what you need. At your connectionstring you should give the Data Source your sql-server's machine ip. Do not forget to assign the default port and to enable TCP/IP Remote Connections. This may help you:



Data Source =,1433; Network Library =DBMSSOCN; Initial Catalog =myDataBase; User ID =myUsername; Password =myPassword;
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 36558287
Please help me out with any connection string and also tell me how to enable TCP/IP connection and assign default port

Accepted Solution

jdruper earned 500 total points
ID: 36560797
There are various ways to make a connection string depending on the security, the type of server, etc.
Here's a page where you can find a bunch of them http://www.connectionstrings.com/mysql#p28
To enable TCP/IP depends a lot on your server's OS but here is a basic guide. http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
LVL 83

Expert Comment

by:Dave Baldwin
ID: 36911763
Where "on the web" is your SQL Server?  Is it at a hosting company?  If it is, do they allow outside access to it?  Many hosting companies do not.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Keyboard 2 41
how to change the view engine in visual studio 2015 enterprises edition 7 102
SqlDataBase 7 53
Object Oriented Programming, C#, referencing, scoping. 13 69
Summary: Persistence is the capability of an application to store the state of objects and recover it when necessary. This article compares the two common types of serialization in aspects of data access, readability, and runtime cost. A ready-to…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question