C#连接sql server2005数据库-蒲公英云

C#连接sql server2005数据库

小咪咪 2022-09-17 11:27 338阅读 0赞

网上关于C#连接sal server2005的资料不多，也不全面，对于一个初学者来说要花很长时间看懂。本人经过查找资料和自己的总结，来分享下成果：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace WebTest2.webRoot
{
    public partial class JDBC : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //建立数据库连接字符串
            string connectionString = "server=localhost;database=test;uid=sa;pwd=123";
            //将连接字符串传入SqlConnection对象的构造函数中
            SqlConnection mySqlConnection = new SqlConnection(connectionString);
            try
            {
                //打开连接
                mySqlConnection.Open();
                //利用label控件显示mySqlConnection对象的ConnectionString属性
                lblInfo.Text = "mySqlConnection对象的ConnectionString属性为：" +
                mySqlConnection.ConnectionString;
                lblInfo1.Text += "mySqlConnection对象的ConnectionTimeout属性为" +
                mySqlConnection.ConnectionTimeout;
                lblInfo2.Text += "mySqlConnection对象的Database属性为" +
                mySqlConnection.Database;
                lblInfo3.Text += "mySqlConnection对象的DataSource属性为" +
                mySqlConnection.DataSource;
                lblInfo4.Text += "mySqlConnection对象的PacketSize属性为" +
                mySqlConnection.PacketSize;
                lblInfo5.Text += "mySqlConnection对象的ServerVersion属性为" +
                mySqlConnection.ServerVersion;
                lblInfo6.Text += "mySqlConnection对象的当前状态为" +
                mySqlConnection.State;
            }
            catch (Exception err)
            {
                lblInfo7.Text = "读取数据库出错";
                lblInfo8.Text += err.Message;
            }
            finally
            {
                //关闭与数据库的连接
                mySqlConnection.Close();
                lblInfo9.Text += "关闭连接后的mySqlConnection对象的状态为";
                lblInfo10.Text += mySqlConnection.State.ToString();
            }
        }
    }
}