20160229 ADO.NET连接SQL Server数据库(SqlHelper类)

来源：互联网发布：网络创意广告分析报告编辑：程序博客网时间：2024/04/29 02:13

一、首先需要在App.config文件中添加如下红色文字

< ? xml version = "1.0" encoding = "utf-8" ? ><configuration><connectionStrings><add name = "dbConnStr" connectionString = "Data Source=.; Initial Catalog=MyTest;User ID=;Password=" / >< / connectionStrings>< / configuration>

如果是免费版的SQL Server，那么Data Source=10.205.1.16\sqlexpress（付费版的只需要填写IP地址即可）；

访问本地只需要一个.就OK了；

二、添加System.Configuration引用

添加using System.Configuration;名称空间

三、SqlHelper代码

class SqlHelper{private static string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters){using (SqlConnection conn = new SqlConnection(connStr)){conn.Open();using (SqlCommand cmd = conn.CreateCommand()){cmd.CommandText = sql;cmd.Parameters.AddRange(parameters);return cmd.ExecuteNonQuery();}}}public static object ExecuteScalar(string sql, params SqlParameter[] parameters){using (SqlConnection conn = new SqlConnection(connStr)){conn.Open();using (SqlCommand cmd = conn.CreateCommand()){cmd.CommandText = sql;cmd.Parameters.AddRange(parameters);return cmd.ExecuteScalar();}}}public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters){using (SqlConnection conn = new SqlConnection(connStr)){conn.Open();using (SqlCommand cmd = conn.CreateCommand()){cmd.CommandText = sql;cmd.Parameters.AddRange(parameters);SqlDataAdapter adapter = new SqlDataAdapter(cmd);DataSet dataset = new DataSet();adapter.Fill(dataset);return dataset.Tables[0];}}}}

1 0