一个C#访问数据库的帮助类


using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

namespace SQLHelperClass
{

public abstract class SqlHelper
{
public static readonly string ConnectionStringMSSQL = ConfigurationManager.AppSettings["dbPath"].ToString();
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}

public static int ExecuteNonQuery(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}

public static int ExecuteNonQuery(SqlTransaction trans, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}


public static SqlDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return rdr;
}
catch
{
conn.Close();
throw;
}
}
public static DataSet ExecuteDataSet(string connectionString, string cmdText)
{
DataSet __ds = new DataSet();
try
{
SqlDataAdapter sda = new SqlDataAdapter(cmdText, connectionString);
sda.Fill(__ds);
}
catch
{
throw;
}
return __ds;
}
public static DataSet ExecuteDataSet(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
DataSet __ds = new DataSet();
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter sda = new SqlDataAdapter();
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
sda.SelectCommand = cmd;
sda.Fill(__ds);
cmd.Parameters.Clear();
return __ds;
}
catch
{
conn.Close();
throw;
}
}
public static object ExecuteScalar(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();

using (SqlConnection connection = new SqlConnection(connectionString))
{
PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
object val = cmd.ExecuteScalar();
cmd.Parameters.Clear();
return val;
}
}

public static object ExecuteScalar(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
object val = cmd.ExecuteScalar();
cmd.Parameters.Clear();
return val;
}

public static void CacheParameters(string cacheKey, params SqlParameter[] commandParameters)
{
parmCache[cacheKey] = commandParameters;
}

public static SqlParameter[] GetCachedParameters(string cacheKey)
{
SqlParameter[] cachedParms = (SqlParameter[])parmCache[cacheKey];
if (cachedParms == null)
return null;
SqlParameter[] clonedParms = new SqlParameter[cachedParms.Length];

for (int i = 0, j = cachedParms.Length; i < j; i++)
clonedParms[i] = (SqlParameter)((ICloneable)cachedParms[i]).Clone();
return clonedParms;
}

private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)
{
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (trans != null)
cmd.Transaction = trans;
cmd.CommandType = cmdType;
if (cmdParms != null)
{
foreach (SqlParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
}


}
}
## 比较全面的c#帮助 日常工作总结,加上网上收集,各式各样的几乎都能找到,所有功能性代码都是独立的之间没有联系,可以单独引用至项目,分享出来,方便大家,几乎都有注释,喜欢的请点赞,不断完善收集中... ## 样板图片操作 ![WEFE@M%}SN4_K$6H0D{6IYJ.png](http://upload-images.jianshu.io/upload_images/6855212-34f0ee0339e3cb49.png?imageMogr2/auto-orient/strip|imageView2/2/w/1240) ## 操作文档 里面包含一下操作文档,这个是用Sandcastle工具生成的。方法:四种Sandcastle方法生成c#.net帮助帮助文档,地址:http://www.cnblogs.com/anyushengcms/p/7682501.html ![H819EQUYFVA~WXK6YAQ1%6Q.png](http://upload-images.jianshu.io/upload_images/6855212-6cf5a7a2a4a75c89.png?imageMogr2/auto-orient/strip|imageView2/2/w/1240) ## 附上一些常见的帮助栏目 1. cookie操作 --------- CookieHelper.cs 2. session操作 ------- SessionHelper.cs 3. cache操作 4. ftp操作 5. http操作 ------------ HttpHelper.cs 6. json操作 ------------ JsonHelper.cs 7. xml操作 ------------- XmlHelper.cs 8. Excel操作 9. Sql操作 ------------- SqlHelper.cs 10. 型转换 ------------ Converter.cs 11. 加密解密 ------------ EncryptHelper.cs 12. 邮件发送 ------------ MailHelper.cs 13. 二维码 14. 汉字转拼音 15. 计划任务 ------------ IntervalTask.cs 16. 信息配置 ------------ Setting.cs 17. 上传下载配置文件操作 18. 视频转换 19. 图片操作 20. 验证码生成 21. String拓展 ---------- StringExtension.cs 22. 正则表达式 --------- RegexHelper.cs 23. 分页操作 24. UBB编码 25. Url重写 26. Object拓展 --------- ObjectExtension.cs 27. Stream的拓展 ------ StreamExtension.cs 28. CSV文件转换 29. Chart图形 30. H5-微信 31. PDF 32. 分词辅助 33. 序列化 34. 异步线程 35. 弹出消息 36. 文件操作 37. 日历 38. 日志 39. 时间操作 40. 时间戳 41. 条形码 42. 正则表达式 43. 汉字转拼音 44. 网站安全 45. 网络 46. 视频转换 47. 计划任务 48. 配置文件操作 49. 阿里云 50. 随机数 51. 页面辅助 52. 验证码 53. Mime 54. Net 55. NPOI 56. obj 57. Path 58. Properties 59. ResourceManager 60. URL的操作 61. VerifyCode 62. 处理多媒体的公共 63. 各种验证帮助 64. 分页 65. 计划任务 66. 配置文件操作 67. 分词辅助 68. IP辅助 69. Html操作
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值