private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=PCName;Initial Catalog=DBName;Integrated Security=True");
//conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
MessageBox.Show("测试连接成功！", "提示！");

}
else
{
MessageBox.Show("连接不成功！","提示！");
}

}

private void button3_Click(object sender, EventArgs e)
{
string PCName = this.texPCName.Text.Trim();
string DBName = this.texDBName.Text.Trim();
}
谁能教一下思路吗?

没人帮帮忙吗?

呵呵，写的不太清楚。
能说清楚点最好！

就是写代码连接数据库...但计算机名和数据库名都是前台手动输入的....然后在代码判断输入的计算名和数据库名是不否正确,是否连接成功......就是这样的.....

我等了好久好久啊...
string PCName = this.texPCName.Text.Trim();
string DBName = this.texDBName.Text.Trim();
string myconn ="Data Source=192.168.1.1;Initial Catalog=BlueHill;Integrated Security=True";
SqlConnection conn = new SqlConnection(myconn);
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
MessageBox.Show("测试连接成功！", "提示！");

}
else
{
MessageBox.Show("连接不成功！","提示！");
}

}
运行到conn.Open();的时候会出现异常现象这样的错误,要怎样处理?
还有我要读取PCName和DBName
Date Source=PCName;Initial Catalog=DBName;Integrated Security=True;这样写有错...那要怎样写..

请教高手啊

你应该把button3_Click事件里的{
string PCName = this.texPCName.Text.Trim();
string DBName = this.texDBName.Text.Trim();
}

放到button2_Click事件里。

string myconn ="Data Source=PCName;Initial Catalog=DBName;Integrated Security=True";


你试试看

因为你没有指定数据库名字!
改成
Initial Catalog=BlueHill

uid=sa;pwd=sa;database=msdb


其实判断连接成功与否可以用异常处理方式来处理!
try{
conn.Open();
Response.write("连接成功")
}
catch(SqlException sql_visble)
{
Response.write("连接失败")
Response.write("也许因为以下原因连接失败:"+sql_visble)

}
finally
{
conn.close()
}

SqlConnection conn = new SqlConnection("Data Source=PCName;Initial Catalog=DBName;Integrated Security=True");这句好象有点问题，而且你string PCName，string DBName声明在Button3_Click事件里那么在Button2_Click肯定不能用（作用域的问题）,应该声明成类的成员变量，再说连接数据库代码PCName和DBName都是变量，你如果这样写那么你输入的任何值都没用，那个地方Data Source永远=PCName这个值而不是此变量内的值
LZ把两个变量声明成成员变量再按下面的写法再试试
SqlConnection conn = new SqlConnection("Data Source=" + PCName + ";Initial Catalog= " + DBName + ";Integrated Security=True");
如果上面代码不行那么建议LZ
SqlConnection conn = new SqlConnection("server = " + PCName + "; uid = sa; pwd = 你数据库的密码; database = " + DBName +"")

[此贴子已经被作者于2007-4-26 2:37:46编辑过]

谢谢了..现在懂了