C#中使用DbHelper连接SqlServer数据库

野性酷女 2023-10-19 00:17 58阅读 0赞

## 场景 ##

C\#的窗体应用中，经常要连接数据库进行相应的操作。

进行简单的数据库连接测试。

## 实现 ##

新建窗体应用，在工具箱中拖拽一个Button按钮。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

右击项目名-添加-类

DBHelper类，连接数据库工具类。

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Data.SqlClient;
    
    namespace DBDemo
    {
        public class DBHelper
        {
            private static string connString = "data source=.;initial catalog= 数据库名;userid=sa;pwd=123";
    
            //获得数据库联接
    
            public static SqlConnection GetConnection()
            {
                SqlConnection connection = new SqlConnection(connString);
                return connection;
            }
    
            //关闭数据库联接
    
            public static void CloseConnection(SqlConnection connection)
            {
                connection.Close();
            }
    
        }
    }

回到窗体中双击按钮，进入button按钮的点击事件中

private void btnTest_Click(object sender, EventArgs e)
            {
                SqlConnection connection = DBHelper.GetConnection();
                try
                {
                    connection.Open();
                    MessageBox.Show("打开数据库连接成功！");
                }
                catch(Exception ex)
                {
                    MessageBox.Show("打开数据库失败！"+ex.Message);
                }
            }

运行程序，点击按钮。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

如果连接String不对

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

### 源码下载 ###

[https://download.csdn.net/download/badao\_liumang\_qizhi/11561530][https_download.csdn.net_download_badao_liumang_qizhi_11561530]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190816085425371.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190816085447934.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190816085452293.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[https_download.csdn.net_download_badao_liumang_qizhi_11561530]: https://download.csdn.net/download/badao_liumang_qizhi/11561530