- 浏览: 125810 次
- 性别:
- 来自: 济南
文章分类
最新评论
-
bettersun:
我用的是Ubuntu16.04,实际应用的时候稍微和文中说的 ...
转:错误:找不到或无法加载主类的问题解决-Ubuntu15.04下的JAVA路 -
justin18:
分享了~~~
無法存取 IIS Metabase(转)
MySQL的SqlHelper类VB.NET版
这是偶根据SqlHelper类VB.NET版自己改的,没有完全测试。
版权信息应该不归我,希望微软不会找我。
使用该类需要加载MySQL.Data.dll文件。
使用示例:
Dim sProc As String '存储过程名变量 Dim ds As New DataSet '数据集变量 sSQL = "SP_SELECT" '存储过程名 Dim para(1) As MySqlParameter '存储过程参数数组变量,这里长度为2 para(0) = New MySqlParameter("v_id", DbType.Int32) '第一个参数 para(1) = New MySqlParameter("v_password", DbType.String) '第二个参数 para(0).Value = 12 '赋值 para(1).Value = "123" '赋值 ds = BSHelper.ExecuteDataset(pubConst.sMySQLCon, CommandType.StoredProcedure, sProc , para) '执行
类代码:
'********************************************************************* ' Data Access Application Block for .NET ' ' BSHelper.cs ' '********************************************************************* ' ' ' '********************************************************************* Imports System Imports System.Data 'Imports System.Data.SqlClient Imports MySql.Data Imports MySql.Data.MySqlClient Imports System.Collections Namespace EnPaper.EnData '********************************************************************* ' ' The BSHelper class=intended to encapsulate high performance, scalable best practices for ' common uses of MySqlClient. ' '********************************************************************* Public NotInheritable Class BSHelper '********************************************************************* ' ' Since this class provides only static methods, make the default constructor private to prevent ' instances from being created with "new BSHelper()". ' '********************************************************************* Private Sub New() End Sub 'New '********************************************************************* ' ' This method=used to attach array of MySqlParameters to a MySqlCommand. ' ' This method will assign a value of DbNull to any parameter with a direction of ' InputOutput and a value of null. ' ' This behavior will prevent default values from being used, but ' this will be the less common case than an intended pure output parameter (derived as InputOutput) ' where the user provided no input value. ' ' param name="command" The command to which the parameters will be added ' param name="commandParameters" an array of MySqlParameters tho be added to command ' '********************************************************************* Private Shared Sub AttachParameters(ByVal command As MySqlCommand, ByVal commandParameters() As MySqlParameter) Dim p As MySqlParameter For Each p In commandParameters 'check for derived output value with no value assigned If p.Direction = ParameterDirection.InputOutput AndAlso p.Value Is Nothing Then p.Value = DBNull.Value End If command.Parameters.Add(p) Next p End Sub 'AttachParameters '********************************************************************* ' ' This method assigns an array of values to an array of MySqlParameters. ' ' param name="commandParameters" array of MySqlParameters to be assigned values ' param name="parameterValues" array of objects holding the values to be assigned ' '********************************************************************* Private Shared Sub AssignParameterValues(ByVal commandParameters() As MySqlParameter, ByVal parameterValues() As Object) If commandParameters Is Nothing OrElse parameterValues Is Nothing Then 'do nothing if we get no data Return End If If commandParameters.Length <> parameterValues.Length Then Throw New ArgumentException("Parameter count does not match Parameter Value count.") End If Dim i, j As Integer j = commandParameters.Length For i = 0 To j commandParameters(i).Value = parameterValues(i) Next End Sub 'AssignParameterValues 'iterate through the MySqlParameters, assigning the values from the corresponding position in the 'value array '********************************************************************* ' ' This method opens (if necessary) and assigns a connection, transaction, command type and parameters ' to the provided command. ' ' param name="command" the MySqlCommand to be prepared ' param name="connection" a valid MySqlConnection, on which to execute this command ' param name="transaction" a valid MySqlTransaction, or 'null' ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of MySqlParameters to be associated with the command or 'null' if no parameters are required ' '********************************************************************* Private Shared Sub PrepareCommand(ByVal command As MySqlCommand, ByVal connection As MySqlConnection, ByVal transaction As MySqlTransaction, ByVal commandType As CommandType, ByVal commandText As String, ByVal commandParameters() As MySqlParameter) 'if the provided connection=not open, we will open it If connection.State <> ConnectionState.Open Then connection.Open() End If 'associate the connection with the command command.Connection = connection 'set the command text (stored procedure name or SQL statement) command.CommandText = commandText 'if we were provided a transaction, assign it. If Not (transaction Is Nothing) Then command.Transaction = transaction End If 'set the command type command.CommandType = commandType 'attach the command parameters if they are provided If Not (commandParameters Is Nothing) Then AttachParameters(command, commandParameters) End If Return End Sub 'PrepareCommand '********************************************************************* ' ' Execute a MySqlCommand (that returns no resultset) against the database specified in the connection string ' using the provided parameters. ' ' e.g.: ' int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new MySqlParameter("@prodid", 24)); ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters used to execute the command ' returns an int representing the number of rows affected by the command ' '********************************************************************* Public Overloads Shared Function ExecuteNonQuery(ByVal connectionString As String, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) As Integer 'create & open a MySqlConnection, and dispose of it after we are done. Dim cn As New MySqlConnection(connectionString) Try cn.Open() 'call the overload that takes a connection in place of the connection string Return ExecuteNonQuery(cn, commandType, commandText, commandParameters) Finally cn.Dispose() End Try End Function 'ExecuteNonQuery '********************************************************************* ' ' Execute a stored procedure via a MySqlCommand (that returns no resultset) against the database specified in ' the connection string using the provided parameter values. This method will query the database to discover the parameters for the ' stored procedure (the first time each stored procedure=called), and assign the values based on parameter order. ' ' This method provides no access to output parameters or the stored procedure's return value parameter. ' ' e.g.: ' int result = ExecuteNonQuery(connString, "PublishOrders", 24, 36); ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="spName" the name of the stored prcedure ' param name="parameterValues" an array of objects to be assigned as the input values of the stored procedure ' returns an int representing the number of rows affected by the command ' '********************************************************************* Public Overloads Shared Function ExecuteNonQuery(ByVal connectionString As String, ByVal spName As String, ByVal ParamArray parameterValues() As Object) As Integer 'if we receive parameter values, we need to figure out where they go If Not (parameterValues Is Nothing) AndAlso parameterValues.Length > 0 Then 'pull the parameters for this stored procedure from the parameter cache (or discover them & populate the cache) Dim commandParameters As MySqlParameter() = MySqlHelperParameterCache.GetSpParameterSet(connectionString, spName) 'assign the provided values to these parameters based on parameter order AssignParameterValues(commandParameters, parameterValues) 'call the overload that takes an array of MySqlParameters Return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters) 'otherwise we can just call the SP without params Else Return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName) End If End Function 'ExecuteNonQuery '********************************************************************* ' ' Execute a MySqlCommand (that returns no resultset) against the specified MySqlConnection ' using the provided parameters. ' ' e.g.: ' int result = ExecuteNonQuery(conn, CommandType.StoredProcedure, "PublishOrders", new MySqlParameter("@prodid", 24)); ' ' param name="connection" a valid MySqlConnection ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters used to execute the command ' returns an int representing the number of rows affected by the command ' '********************************************************************* Public Overloads Shared Function ExecuteNonQuery(ByVal connection As MySqlConnection, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) As Integer 'create a command and prepare it for execution Dim cmd As New MySqlCommand PrepareCommand(cmd, connection, CType(Nothing, MySqlTransaction), commandType, commandText, commandParameters) 'finally, execute the command. Dim retval As Integer = cmd.ExecuteNonQuery() ' detach the MySqlParameters from the command object, so they can be used again. cmd.Parameters.Clear() Return retval End Function 'ExecuteNonQuery '********************************************************************* ' ' Execute a MySqlCommand (that returns a resultset) against the database specified in the connection string ' using the provided parameters. ' ' e.g.: ' DataSet ds = ExecuteDataset(connString, CommandType.StoredProcedure, "GetOrders", new MySqlParameter("@prodid", 24)); ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters used to execute the command ' returns a dataset containing the resultset generated by the command ' '********************************************************************* Public Overloads Shared Function ExecuteDataset(ByVal connectionString As String, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) As DataSet 'create & open a MySqlConnection, and dispose of it after we are done. Dim cn As New MySqlConnection(connectionString) Try cn.Open() 'call the overload that takes a connection in place of the connection string Return ExecuteDataset(cn, commandType, commandText, commandParameters) Finally cn.Dispose() End Try End Function 'ExecuteDataset '********************************************************************* ' ' Execute a stored procedure via a MySqlCommand (that returns a resultset) against the database specified in ' the connection string using the provided parameter values. This method will query the database to discover the parameters for the ' stored procedure (the first time each stored procedure=called), and assign the values based on parameter order. ' ' This method provides no access to output parameters or the stored procedure's return value parameter. ' ' e.g.: ' DataSet ds = ExecuteDataset(connString, "GetOrders", 24, 36); ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="spName" the name of the stored procedure ' param name="parameterValues" an array of objects to be assigned as the input values of the stored procedure ' returns a dataset containing the resultset generated by the command ' '********************************************************************* Public Overloads Shared Function ExecuteDataset(ByVal connectionString As String, ByVal spName As String, ByVal ParamArray parameterValues() As Object) As DataSet 'if we receive parameter values, we need to figure out where they go If Not (parameterValues Is Nothing) AndAlso parameterValues.Length > 0 Then 'pull the parameters for this stored procedure from the parameter cache (or discover them & populate the cache) Dim commandParameters As MySqlParameter() = MySqlHelperParameterCache.GetSpParameterSet(connectionString, spName) 'assign the provided values to these parameters based on parameter order AssignParameterValues(commandParameters, parameterValues) 'call the overload that takes an array of MySqlParameters Return ExecuteDataset(connectionString, CommandType.StoredProcedure, spName, commandParameters) 'otherwise we can just call the SP without params Else Return ExecuteDataset(connectionString, CommandType.StoredProcedure, spName) End If End Function 'ExecuteDataset '********************************************************************* ' ' Execute a MySqlCommand (that returns a resultset) against the specified MySqlConnection ' using the provided parameters. ' ' e.g.: ' DataSet ds = ExecuteDataset(conn, CommandType.StoredProcedure, "GetOrders", new MySqlParameter("@prodid", 24)); ' ' param name="connection" a valid MySqlConnection ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters used to execute the command ' returns a dataset containing the resultset generated by the command ' '********************************************************************* Public Overloads Shared Function ExecuteDataset(ByVal connection As MySqlConnection, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) As DataSet 'create a command and prepare it for execution Dim cmd As New MySqlCommand PrepareCommand(cmd, connection, CType(Nothing, MySqlTransaction), commandType, commandText, commandParameters) 'create the DataAdapter & DataSet Dim da As New MySqlDataAdapter(cmd) Dim ds As New DataSet 'fill the DataSet using default values for DataTable names, etc. da.Fill(ds) ' detach the MySqlParameters from the command object, so they can be used again. cmd.Parameters.Clear() 'return the dataset Return ds End Function 'ExecuteDataset '********************************************************************* ' ' Execute a MySqlCommand (that returns a 1x1 resultset) against the database specified in the connection string ' using the provided parameters. ' ' e.g.: ' int orderCount = (int)ExecuteScalar(connString, CommandType.StoredProcedure, "GetOrderCount", new MySqlParameter("@prodid", 24)); ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters used to execute the command ' returns an object containing the value in the 1x1 resultset generated by the command ' '********************************************************************* Public Overloads Shared Function ExecuteScalar(ByVal connectionString As String, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) As Object 'create & open a MySqlConnection, and dispose of it after we are done. Dim cn As New MySqlConnection(connectionString) Try cn.Open() 'call the overload that takes a connection in place of the connection string Return ExecuteScalar(cn, commandType, commandText, commandParameters) Finally cn.Dispose() End Try End Function 'ExecuteScalar '********************************************************************* ' ' Execute a stored procedure via a MySqlCommand (that returns a 1x1 resultset) against the database specified in ' the connection string using the provided parameter values. This method will query the database to discover the parameters for the ' stored procedure (the first time each stored procedure=called), and assign the values based on parameter order. ' ' This method provides no access to output parameters or the stored procedure's return value parameter. ' ' e.g.: ' int orderCount = (int)ExecuteScalar(connString, "GetOrderCount", 24, 36); ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="spName" the name of the stored procedure ' param name="parameterValues" an array of objects to be assigned as the input values of the stored procedure ' returns an object containing the value in the 1x1 resultset generated by the command ' '********************************************************************* Public Overloads Shared Function ExecuteScalar(ByVal connectionString As String, ByVal spName As String, ByVal ParamArray parameterValues() As Object) As Object 'if we receive parameter values, we need to figure out where they go If Not (parameterValues Is Nothing) AndAlso parameterValues.Length > 0 Then 'pull the parameters for this stored procedure from the parameter cache (or discover them & populate the cache) Dim commandParameters As MySqlParameter() = MySqlHelperParameterCache.GetSpParameterSet(connectionString, spName) 'assign the provided values to these parameters based on parameter order AssignParameterValues(commandParameters, parameterValues) 'call the overload that takes an array of MySqlParameters Return ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, commandParameters) 'otherwise we can just call the SP without params Else Return ExecuteScalar(connectionString, CommandType.StoredProcedure, spName) End If End Function 'ExecuteScalar '********************************************************************* ' ' Execute a MySqlCommand (that returns a 1x1 resultset) against the specified MySqlConnection ' using the provided parameters. ' ' e.g.: ' int orderCount = (int)ExecuteScalar(conn, CommandType.StoredProcedure, "GetOrderCount", new MySqlParameter("@prodid", 24)); ' ' param name="connection" a valid MySqlConnection ' param name="commandType" the CommandType (stored procedure, text, etc.) ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters used to execute the command ' returns an object containing the value in the 1x1 resultset generated by the command ' '********************************************************************* Public Overloads Shared Function ExecuteScalar(ByVal connection As MySqlConnection, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) As Object 'create a command and prepare it for execution Dim cmd As New MySqlCommand PrepareCommand(cmd, connection, CType(Nothing, MySqlTransaction), commandType, commandText, commandParameters) 'execute the command & return the results Dim retval As Object = cmd.ExecuteScalar() ' detach the MySqlParameters from the command object, so they can be used again. cmd.Parameters.Clear() Return retval End Function 'ExecuteScalar End Class 'SqlHelper '********************************************************************* ' ' MySqlHelperParameterCache provides functions to leverage a static cache of procedure parameters, and the ' ability to discover parameters for stored procedures at run-time. ' '********************************************************************* Public NotInheritable Class MySqlHelperParameterCache '********************************************************************* ' ' Since this class provides only static methods, make the default constructor private to prevent ' instances from being created with "new MySqlHelperParameterCache()". ' '********************************************************************* Private Sub New() End Sub 'New Private Shared paramCache As Hashtable = Hashtable.Synchronized(New Hashtable) '********************************************************************* ' ' resolve at run time the appropriate set of MySqlParameters for a stored procedure ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="spName" the name of the stored procedure ' param name="includeReturnValueParameter" whether or not to include their return value parameter ' '********************************************************************* Private Shared Function DiscoverSpParameterSet(ByVal connectionString As String, ByVal spName As String, ByVal includeReturnValueParameter As Boolean) As MySqlParameter() Dim cn As New MySqlConnection(connectionString) Try Dim cmd As New MySqlCommand(spName, cn) Try cn.Open() cmd.CommandType = CommandType.StoredProcedure MySqlCommandBuilder.DeriveParameters(cmd) If Not includeReturnValueParameter Then cmd.Parameters.RemoveAt(0) End If Dim discoveredParameters(cmd.Parameters.Count) As MySqlParameter cmd.Parameters.CopyTo(discoveredParameters, 0) Return discoveredParameters Finally cmd.Dispose() End Try Finally cn.Dispose() End Try End Function 'DiscoverSpParameterSet Private Shared Function CloneParameters(ByVal originalParameters() As MySqlParameter) As MySqlParameter() 'deep copy of cached MySqlParameter array Dim clonedParameters(originalParameters.Length) As MySqlParameter Dim i, j As Integer j = originalParameters.Length For i = 0 To j clonedParameters(i) = CType(CType(originalParameters(i), ICloneable).Clone(), MySqlParameter) Next Return clonedParameters End Function 'CloneParameters '********************************************************************* ' ' add parameter array to the cache ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="commandText" the stored procedure name or T-SQL command ' param name="commandParameters" an array of SqlParamters to be cached ' '********************************************************************* Public Shared Sub CacheParameterSet(ByVal connectionString As String, ByVal commandText As String, ByVal ParamArray commandParameters() As MySqlParameter) Dim hashKey As String = connectionString + ":" + commandText paramCache(hashKey) = commandParameters End Sub 'CacheParameterSet '********************************************************************* ' ' Retrieve a parameter array from the cache ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="commandText" the stored procedure name or T-SQL command ' returns an array of SqlParamters ' '********************************************************************* Public Shared Function GetCachedParameterSet(ByVal connectionString As String, ByVal commandText As String) As MySqlParameter() Dim hashKey As String = connectionString + ":" + commandText Dim cachedParameters As MySqlParameter() = CType(paramCache(hashKey), MySqlParameter()) If cachedParameters Is Nothing Then Return Nothing Else Return CloneParameters(cachedParameters) End If End Function 'GetCachedParameterSet '********************************************************************* ' ' Retrieves the set of MySqlParameters appropriate for the stored procedure ' ' This method will query the database for this information, and then store it in a cache for future requests. ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="spName" the name of the stored procedure ' returns an array of MySqlParameters ' '********************************************************************* Public Overloads Shared Function GetSpParameterSet(ByVal connectionString As String, ByVal spName As String) As MySqlParameter() Return GetSpParameterSet(connectionString, spName, False) End Function 'GetSpParameterSet '********************************************************************* ' ' Retrieves the set of MySqlParameters appropriate for the stored procedure ' ' This method will query the database for this information, and then store it in a cache for future requests. ' ' param name="connectionString" a valid connection string for a MySqlConnection ' param name="spName" the name of the stored procedure ' param name="includeReturnValueParameter" a bool value indicating whether the return value parameter should be included in the results ' returns an array of MySqlParameters ' '********************************************************************* Public Overloads Shared Function GetSpParameterSet(ByVal connectionString As String, ByVal spName As String, ByVal includeReturnValueParameter As Boolean) As MySqlParameter() Dim hashKey As String = connectionString + ":" + spName + IIf(includeReturnValueParameter, ":include ReturnValue Parameter", "") Dim cachedParameters() As MySqlParameter cachedParameters = CType(paramCache(hashKey), MySqlParameter()) If cachedParameters Is Nothing Then paramCache(hashKey) = DiscoverSpParameterSet(connectionString, spName, includeReturnValueParameter) cachedParameters = CType(paramCache(hashKey), MySqlParameter()) End If Return CloneParameters(cachedParameters) End Function 'GetSpParameterSet End Class 'MySqlHelperParameterCache End Namespace ' EnPaper.EnData
发表评论
-
控件 内容 打印
2011-10-28 17:34 806Private Sub btnPrint_Click( ... -
DataGridView控件用法合集
2011-10-19 14:53 2447DataGridView控件用法合集 ... -
無法存取 IIS Metabase(转)
2010-04-01 10:35 1433http://fangzheng336.blog.163.co ... -
学习UpdatePanel控件
2010-03-17 09:12 3575转载:http://blog.csdn.net/ILOVEMS ... -
UpdatePanel DataGrid 中按钮失效(只刷新本页)的解决办法
2010-03-09 22:23 1545UpdatePanel DataGrid 中按钮失效(只 ... -
DataGrid 非首页 只有一条数据 删除 错误 解决方法
2010-03-06 17:37 567#region----PagingのDa ... -
C#时间格式(转)
2010-03-02 10:10 1956C#时间格式 string.Format(&quo ... -
UpdatePanel 提示框
2010-02-24 12:23 857使用UpdatePanel 弹出提示框 ScriptMana ... -
ASP.NET(C#) 返回上一页(后退)(转)
2010-01-26 13:20 7101使用Request.U ... -
DataGrid 模板列 隐藏列 编辑状态 取值
2010-01-26 13:16 1536/* 当然根据你的需要,如果是在绑定时候需要得到数值显示 ... -
.NET GridView 多层表头
2010-01-26 13:14 1834.NET GridView 多层表头实现方法 效果如 ... -
.NET :无法在 Web 服务器上启动调试 错误的解决方法
2010-01-26 13:07 991VS.NET :运行调试按钮(F5)提示错误:无法 ... -
取得GridView中的文本框更新后的值(VB.NET)
2010-01-26 13:06 2977实在是郁闷,搞了好半天才搞出来,原来,就差在Page_Load ... -
SqlHelper类VB.NET版(转)
2010-01-26 13:00 1525SqlHelper类VB.NET版 Code: ... -
Content子页操作Master母板页变量
2010-01-26 12:56 1280添加@ MasterType标记到页面中,以便可以作为强类型属 ... -
Ajax中“Sys未定义”错误的解决方法汇总(转)
2010-01-26 12:52 5871今天研究AJAX的东西,遇到“Sys未定义”的错误,在网上搜 ...
相关推荐
VB.Net版的SqlHelper,希望对大家有用!
结合我帖子 VB.NET SQLHelper 类使用
VB.NET实现SqlHelper数据库操作组件,组件中包含数据库操作方法。SqlHelper用于简化你重复的去写那些数据库连接(SqlConnection),SqlCommand,SqlDataReader等等。SqlHelper 封装过后通常是只需要给方法传入一些参数...
本人平常数据库都是用SQLServer,所以特地用vb.net写了一个仅支持SQLServer的SQLHelper类以方便使用,没做修改直接上传,需要的童鞋欢迎下载,稍做修改即可适用于其他数据库:支持查询数据类命令和修改数据类命令,...
sqlhelper类 .net1.1/.net2.0 完全版 完整的版本,可以直接使用。
sqlhelper,.net1.1/.net2.0,c#
在VB.net或ASP.NET里面很好引用,把类引用进来就可以直接使用了 下面是用的部分。。。 Dim ds4 As DataSet Dim sql4 As String = "select * from table where xx='dd'" ds4 = SqlHelper.ExecuteDataset(con, ...
C#最全基类源码(包括ASP.NET类库、读取AD域里用户名或组、Common类库、DotNet基础类大全、SqlHelper基类、字符串加密)
ADO.NET中简单实用的三种方法,并将其进行封装,便于操作者进行开发与使用。
帮助类,sqlhelper ,dbhelper ,asp.net里面用到的帮助类。
SqlHelper是一个基于.NET Framework的数据库操作组件。组件中包含数据库操作方法,目前SqlHelper有很多版本,主要以微软一开始发布的SqlHelper类,后面包含进了Enterprise Library开源包中了。还有一个主要版本是...
ADO.NET自己封装SqlHelper类 1、简单封装 2、传递参数封装 3、参数可变封装
SQLHelper类(Java版), 模仿微软提供的SQLHelper类的功能,真正实现了除SQLHelper类外,外界全部可以无须引用连接数据库的类,并且无须担心数据库的连接与关闭。(内附使用说明)
微软官方C# SqlHelper类 ,内带有注释说明,供大家参考
sqlhelper类 供大家使用。。。。。。。。。。。。。。
SqlHelper asp.net开发数据帮助
Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容Sqlhelper类的的内容
微软的SQLHelper类 (含完整中文注释) c# asp.net winform
教你.net中SQLHelper类的使用