Hi i have a problem, i make a form with one button and i want to make in c# (windows Aplication) the follows: when i click in button i need to connect in my SQL Server. How can i do that??:?:

Here is a snip of code from my Login screen. It has the usual Server Name, User name and Password texboxes, and a Login and Cancel button. Mine is hardcoded for a database named SAFEnet. This is using the SQLclient (SQL2005). If you are using another type DBMS, let me know, and I will show you that code.

I use a string to contain the ConnectionString value, then use the replace method to build in the parameters. The Login button calls this code:
There are other ways of handling the string, this just makes it more readable. The bottom line is that you contruct the connection string and pass it to the open procedure of the Connection object.

Note: you will want to wrap the connection in a try..catch


string ConStr = "Data Source=<SERVER>;Initial Catalog=SAFENET;USER ID=<LOGIN>;Password=<PASSWORD>";
ConStr = ConStr.Replace("<SERVER>", cbServer.Text);
ConStr = ConStr.Replace("<LOGIN>", edOperator.Text);
ConStr = ConStr.Replace("<PASSWORD>", edPassword.Text);
btnLogin.Enabled = false; // Make the Button Disabled;
btnCancelQuit.Enabled = false;
// Check these credentials
SqlConnection conn = new SqlConnection( ConStr );
This article has been dead for over six months. Start a new discussion instead.