111,098
社区成员




//定义连接数据库字符串
private string strConn = @"Data Source=.;Initial Catalog=数据库名称;User ID=sa;Pwd=数据库登录的密码";
//data source=的值填写你数据库的地址,如果是本地就是”.“
//如果是外部地址就填写你要连接的Ip
//数据库连接Connection对象
private SqlConnection conn;
#region 创建属性
public SqlConnection Connection
{
get
{
if (conn == null)
{
conn = new SqlConnection(strConn);
}
return conn;
}
}
#endregion
#region 打开数据库
public void OpenConnection()
{
//判断connection的状态如果关闭,重新打开数据库
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
else if (Connection.State == ConnectionState.Broken)
{
Connection.Close();
Connection.Open();
}
}
#endregion
#region 关闭数据库
public void CloseConnection()
{
if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
{
Connection.Close();
}
}
#endregion
SqlConnection conn;
private void button1_Click(object sender, EventArgs e)
{
try
{
conn = new SqlConnection("server=.;database=db_22;integrated security=true");