急：C# 登陆到Sql Server 提供用户名，密码，服务器名，怎么做，在线等待，解决立刻给分

Question

请问各位大虾：C# 登陆到Sql Server  提供用户名，密码，服务器名，怎么做，在线等待，解决立刻给分
具体地说就是做一个像sql2000登陆界面一样的东东，功能也一样咯
请高手指点啊！

Answer 1

public bool LoginDtBs(string username,string pwd)
        {
            userstr = "User ID=" + username + ";Pwd=" + pwd + ";";
            SqlConnection conn = new SqlConnection(userstr);
            try
            {
                conn.Open();
            }
            catch (Exception e)
            {
                msg = e.Message;
                return false;
            }
            finally
            {
                conn.Close();
            }
            return true;
        }

Answer 2

public bool LoginDtBs(string ServerName, string DataBaseName, string username,string pwd)
        {
            userstr = "User ID=" + username + ";Pwd=" + pwd + ";Initial Catalog=" + DataBaseName + ";Data Source=" + ServerName;
            SqlConnection conn = new SqlConnection(userstr);
            try
            {
                conn.Open();
            }
            catch (Exception e)
            {
                msg = e.Message;
                return false;
            }
            finally
            {
                conn.Close();
            }
            return true;
        }

Answer 3

那个你就做一个窗体，窗体里放几个控件输入 ServerName,DataBase,UserName,Password就行啦。
然后把这几个组成条连接数据字符串就可以啦。

Answer 4

各位啊，看样子你们没理解我的意思
不过我自己解决啦
private string CreateConnectionString()
        {
            if (cbAuthType.SelectedIndex == 1)
            {
                connectionString = string.Empty;
                connectionString += "Data Source=";
                connectionString += txtServer.Text.Trim() + "; ";
                connectionString += "Initial Catalog=master;";
                connectionString += "User Id=";
                connectionString += txtUserName.Text.Trim() + "; ";
                connectionString += "Password=";
                connectionString += txtPassWord.Text.Trim() + "; ";
            }
            else
            {
                connectionString = string.Empty;
                connectionString += "Data Source=" + txtServer.Text.Trim() + ";";
                connectionString += "Initial Catalog=master;Integrated Security=SSPI";
            }
            return connectionString;
        }