How do I create a database login screen on c sharp?

Answer 1

Basically in order to login to a database you need a couple of inputs from user: -

Server Name

DB Name

UserName/password

All of these would be used to frame a connection string that can be used to initialise a SQLConnection object and open the DB connection.

A standard connection string would be: -

string strSQLconnection = "Data Source=dbServer;Initial Catalog=DBNAME;Integrated Security=True;uname=username;password=pwd";

-> In this case

string strSQLconnection = "Data Source=" + textbox1.text + ";Initial Catalog=" + textbox2.text + "...........

//initialize sqlconnection from the connection string.

SqlConnection sqlConnection = new SqlConnection(strSQLconnection);

//initialize the query to be fired.

SqlCommand sqlCommand = new SqlCommand("select * from table1", sqlConnection);

//open sql connection

sqlConnection.Open();