怎么判断连接SqlServer数据库成功 利用“Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;”连接字符串连接数据库。问题一:怎么判断连接SqlServer数据库成功,然后返回提示信息???问题二:知道数据库用户名和密码,怎么返回SqlServer中所有数据库的名称??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SqlConnection conn = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"); conn.Open(); public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { using (SqlConnection connection = new SqlConnection("")) { connection.Open(); if (connection.State == ConnectionState.Open) { //已经打开 } } }} 1、判断是否链接成功,只用try{}catch(){}来捕获异常就可以了2、SqlServer中所有数据库的名称,只有winform可以做到,web没有这样的权限,不过好像也有偏激的做法,直接去读取system.table去查找 USE masterSELECT dbid, DB_NAME(dbid) AS DB_NAMEFROM sysdatabasesORDER BY dbidGO 或者你写个查询语句啊,还可以连接服务器测试一下啊Tools-connect to database try{SqlConnection conn = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"); conn.Open();}catch{//连接失败} SqlConnection conn = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"); try { conn.Open(); } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); }连接失败会异常,捕捉并处理连接master数据库,查询SysDatabases表,就能查询所有数据库protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=master;User Id=sa;Password=111;"); try { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT Name FROM SysDatabases ORDER BY Name", conn); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } GridView1.DataSource = dt; GridView1.DataBind(); } 通过系统库master去查找所有的库select name from sysdatabases 1、if (connection.State == ConnectionState.Open)2、select name from sysdatabases 就是用在“WInform”里的 try {链接正确 } catch (Exception ex) { 链接错误 } 你只要执行select @@version之类的语句就行了,这就证明sql server系统连接成功 楼主,试试这个,我一直这样用:private SqlConnection connection; public SqlConnection Connection { get { string connectionString = "server=.;database=DB;uid=SA;pwd=123456"; if (connection == null) { connection = new SqlConnection(connectionString); connection.Open();//这里就是打开了,说明连接上了 } else if (connection.State == System.Data.ConnectionState.Closed) { connection.Open(); //这里就是打开了,说明连接上了 } else if (connection.State == System.Data.ConnectionState.Broken) { connection.Close(); connection.Open();//这里就是打开了,说明连接上了 } return connection; //不管什么情况,这里总是返回一个打开的连接 } } web.config <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />在.CS里面 SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;try{ con.open(); response.write("<script>alert('数据库连接陈功')</script>"); try{ string sql="select name from sysdatabases"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataTable dt = new DataTable(); da.fill(dt); return dt; }catch{response.write("<script>alert('数据库读取失败')</script>");}}catcah{response.write("<script>alert('数据库连接失败')</script>");} SqlConnection conn=new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword");con.open();response.write("连接成功!");con.close(); connection.State就是连接状态判断啊。if(connection.State == System.Data.ConnectionState.Open){ MessageBox.show("Success!");} vs的Tools-connect to database 试试,如果成功就可以了 TryCatch语句组合。.state属性。 急等解决的问题,高手进…… repeater后台如何数据源绑定?? 关于身份验证的问题! Asp.net中如何实现事务处理? gridview中问题? 我的datagrid绑定后,我点击某一行,并没有出现编辑状态,确切的说是没反应。我已经定义了EditCommand SelectIndexChanged 事件了。是 做过网络考试系统的请进~~ 多个OA系统之间的比较 求一个解决思路?高手请进,答者有分! 插入记录功能,返回数据库的值怎么这么多!!!初级问题——在线等 工厂模式程序集创建对象为null,请求高手帮帮忙!! 在IIS下建了2个站点,指向同一个目录,是不是会很卡?
conn.Open();
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(""))
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
//已经打开
}
}
}
}
2、SqlServer中所有数据库的名称,只有winform可以做到,web没有这样的权限,不过好像也有偏激的做法,直接去读取system.table去查找
SELECT dbid, DB_NAME(dbid) AS DB_NAME
FROM sysdatabases
ORDER BY dbid
GO
Tools-connect to database
try
{
SqlConnection conn = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");
conn.Open();
}
catch
{
//连接失败
}
SqlConnection conn = new SqlConnection("Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");
try
{
conn.Open();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
}连接失败会异常,捕捉并处理连接master数据库,查询SysDatabases表,就能查询所有数据库
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=master;User Id=sa;Password=111;");
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT Name FROM SysDatabases ORDER BY Name", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
} GridView1.DataSource = dt;
GridView1.DataBind();
}
select name from sysdatabases
2、select name from sysdatabases
就是用在“WInform”里的
{
链接正确
}
catch (Exception ex)
{
链接错误
}
public SqlConnection Connection
{
get
{
string connectionString = "server=.;database=DB;uid=SA;pwd=123456";
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();//这里就是打开了,说明连接上了
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open(); //这里就是打开了,说明连接上了
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();//这里就是打开了,说明连接上了
}
return connection; //不管什么情况,这里总是返回一个打开的连接
}
}
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />在.CS里面
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
try{
con.open();
response.write("<script>alert('数据库连接陈功')</script>");
try{
string sql="select name from sysdatabases";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable();
da.fill(dt);
return dt;
}
catch{
response.write("<script>alert('数据库读取失败')</script>");
}}
catcah{
response.write("<script>alert('数据库连接失败')</script>");
}
con.open();
response.write("连接成功!");
con.close();
if(connection.State == System.Data.ConnectionState.Open)
{
MessageBox.show("Success!");
}
Catch
语句组合。.state属性。