-
SQLHelper连接数据库示例类
[实例简介] 连接sql数据库 类 [核心代码]using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data.SqlClient;using System.Data; namespace Itcast.Cn{ public static class SqlHelper { private static readonly string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; //执行增删改的 public static int ExecuteNonQuery(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteNonQuery(); } } } //封装一个执行返回单个值的方法 public static object ExecuteScalar(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteScalar(); } } } //返回SqlDataReader对象的方法 public static SqlDataReader ExecuteReader(string sql, CommandType cmdType, params SqlParameter[] pms) { SqlConnection con = new SqlConnection(conStr); using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } try { con.Open(); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception) { con.Close(); con.Dispose(); throw; } } } //封装一个返回DataTable的方法 public static DataTable ExecuteDataTable(string sql, CommandType cmdType, params SqlParameter[] pms) { DataTable dt = new DataTable(); using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conStr)) { adapter.SelectCommand.CommandType = cmdType; if (pms != null) { adapter.SelectCommand.Parameters.AddRange(pms); } adapter.Fill(dt); } return dt; } //封装一个带事务的执行Sql语句的方法 public static void ExecuteNonQueryTran(List list) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = con.CreateCommand()) { con.Open(); using (SqlTransaction trans = con.BeginTransaction()) { cmd.Transaction = trans; try { foreach (var SqlObject in list) { cmd.CommandText = SqlObject.Sql; if (SqlObject.Parameters != null) { cmd.Parameters.AddRange(SqlObject.Parameters); } cmd.CommandType = SqlObject.CmdType; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } trans.Commit(); } catch (Exception) { trans.Rollback(); } } } } } } public class SqlAndParameter { public string Sql { get; set; } public SqlParameter[] Parameters { get; set; } public CommandType CmdType { get; set; } }}
- 2015-04-01下载
- 积分：1
-
V5-122a_触屏示波器UI界面例程（V1.2）
说明： 触摸屏显示，输出500Hz和600Hz正弦波，方波，一起显示。(Touch screen display, output 500 Hz and 600 Hz sine wave, square wave, together with display)
- 2019-07-07 15:04:15下载
- 积分：1
-
Blob
blob代码分析，真正的代码分析，超好的资料超详细，欢迎下载，(blob code analysis, the real code analysis, super good super-detailed information, please download,)
- 2009-12-25 22:10:13下载
- 积分：1
-
faceddetect
使用vs2012+opencv2.4.5做的人脸检测代码，可以实现对静态图像上人脸的检测(Use vs2012+ opencv2.4.5 do face detection code, you can achieve detection of static images of the human face)
- 2014-09-30 17:15:12下载
- 积分：1
-
APFC-simulink-example
功率因数校正的一些simulink仿真实例，包括单相和三相的电路拓扑，欢迎大家下载交流！(Power Factor Correction some simulink simulation examples, including single-phase and three-phase circuit topology, welcome everyone to download!)
- 2021-03-18 15:29:20下载
- 积分：1
-
demoXEPALL
MC9S12XEP100的程序，适合中低级程序员练习(MC9S12XEP100 program, suitable for junior programmers to practice)
- 2015-11-10 23:30:42下载
- 积分：1
-
在线网上书店页面和数据库连接的设计，功能过的…
在线网上书店的页面及数据库连接设计，功能较全，实现购物车及订购设置，有文档描述-Online online bookstore page and database connectivity design, function over the whole to realize shopping cart and order settings, there is a document describing
- 2022-05-23 04:33:52下载
- 积分：1
-
短路电流计算程序(1)
在Matlab上进行电力系统分析的短路电流计算C 语言程序(Short circuit current calculation for power system analysis on Matlab, C language program.)
- 2018-04-11 09:51:52下载
- 积分：1
-
斐讯R1本地升级工具包
说明： 斐讯因为停止服务了 致使斐讯r1音箱不能升级 使用这个软件就可以把斐讯r1音箱升级成最新版本3448，这个版本的音质有了很大的提升(Because the service of fisun stopped, fisun R1 speaker could not be upgraded. With this software, fisun R1 speaker can be upgraded to the latest version 3448. The sound quality of this version has been greatly improved)
- 2020-06-30 01:00:02下载
- 积分：1
-
20051018140321_Nolme_Chart_src
说明： 关于图表中的图例，有两种选择，第一，我们可以把图例整合到当前的面板中，第二，再建一个独立的对象。主要的意图是当在同一个页面使用多个图表时，能够提供一个集中在一起的图例(chart on the legend, there are two choices, first, we can integrate Legend of the current panel, the second, to build an independent nation. The main intention is that when a page with multiple charts, to provide a pool of Legend)
- 2005-10-19 10:31:41下载
- 积分：1
