Display SQL database for authenticated users

Question

Hi I was trying to get SQL database names once after logging in. how do i achieve it in windows form C#? i have windows form with 3 fields 1) IP address 2) user name 3) Password once after filling the above form it should redirect to another form where in it should display all the authenticated database name for that entered user.

Abhay Shanker · Answer

Try as below protected void Connect(object sender EventArgs e) { String connString = string.Format(Data Source={0};User ID={1};Password={2} txtInstance.Text txtUserName.Text txtPassword.Text); using (SqlConnection con = new SqlConnection(connString)) { con.Open(); DataTable dtDatabases = con.GetSchema(Databases); con.Close(); ddlDatabases.DataSource = dtDatabases; ddlDatabases.DataTextField = database_name; ddlDatabases.DataValueField = dbid; ddlDatabases.DataBind(); } }

Ravi Kumar · Answer

try the fallowing you give the connection string in app.config value=Server=192.168.1.1;Database=dbname;UId=sa;Password=password; /> the fallowing code you write in *.cs SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings[UniqueName]);

Ranjit Powar · Answer

check this http://www.c-sharpcorner.com/Blogs/15749/take-sql-sever-database-backup-from-winform.aspx