//Get connection's status public bool isConnected() { //sqlConn is a sqlconnection object if(sqlConn.State==ConnectionState.Closed ||sqlConn.State==ConnectionState.Broken) //Connection is not available return false; else //Connection is available return true; }
{
ConnectionString = "data source="+textBox1.Text.Trim()+";initial catalog=master;persist security info=False;user id=sa;pwd="+textBox2.Text.Trim() +";";
if( conn.State == ConnectionState.Open)
conn.Close();
conn.ConnectionString = ConnectionString;
try
{
conn.Open();
MessageBox.Show("测试成功!请保存设置!","成功!");
button1.Enabled=true; }
catch(Exception err)
{
MessageBox.Show("不能联接"+err.ToString() ,"出错了!",MessageBoxButtons.OK ,MessageBoxIcon.Question );
}
finally
{
conn.Close();
}
}
}
如下: SqlConnection conn=new SqlConnection(连接字符串);
conn.Open(); ......
if(conn.State==ConnectionState.Open)
{
conn.Close();
} :)
是这个意思吗?try
{
SqlConnection conn=new SqlConnection(连接字符串);
conn.Open();
}
catch(Exception ex)
{
MessageBox.Show("数据库连接错误 :"+ex.Message,"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
} :)
try
{
Connection.Open();
//OK
}
catch(SqlException e)
{
Connection.Close();
//
}
public bool isConnected()
{
//sqlConn is a sqlconnection object
if(sqlConn.State==ConnectionState.Closed
||sqlConn.State==ConnectionState.Broken)
//Connection is not available
return false;
else
//Connection is available
return true;
}