<?xml version="1.0"?>
<doc>
<assembly>
<name>Microsoft.ApplicationBlocks.Data</name>
</assembly>
<members>
<member name="T:Microsoft.ApplicationBlocks.Data.SqlHelper">
<summary>
The SqlHelper class is intended to encapsulate high performance, scalable best practices for
common uses of SqlClient
</summary>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.AttachParameters(System.Data.SqlClient.SqlCommand,System.Data.SqlClient.SqlParameter[])">
<summary>
This method is used to attach array of SqlParameters to a SqlCommand.
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.
</summary>
<param name="command">The command to which the parameters will be added</param>
<param name="commandParameters">An array of SqlParameters to be added to command</param>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(System.Data.SqlClient.SqlParameter[],System.Data.DataRow)">
<summary>
This method assigns dataRow column values to an array of SqlParameters
</summary>
<param name="commandParameters">Array of SqlParameters to be assigned values</param>
<param name="dataRow">The dataRow used to hold the stored procedure's parameter values</param>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(System.Data.SqlClient.SqlParameter[],System.Object[])">
<summary>
This method assigns an array of values to an array of SqlParameters
</summary>
<param name="commandParameters">Array of SqlParameters to be assigned values</param>
<param name="parameterValues">Array of objects holding the values to be assigned</param>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.PrepareCommand(System.Data.SqlClient.SqlCommand,System.Data.SqlClient.SqlConnection,System.Data.SqlClient.SqlTransaction,System.Data.CommandType,System.String,System.Data.SqlClient.SqlParameter[],System.Boolean@)">
<summary>
This method opens (if necessary) and assigns a connection, transaction, command type and parameters
to the provided command
</summary>
<param name="command">The SqlCommand to be prepared</param>
<param name="connection">A valid SqlConnection, on which to execute this command</param>
<param name="transaction">A valid SqlTransaction, or 'null'</param>
<param name="commandType">The CommandType (stored procedure, text, etc.)</param>
<param name="commandText">The stored procedure name or T-SQL command</param>
<param name="commandParameters">An array of SqlParameters to be associated with the command or 'null' if no parameters are required</param>
<param name="mustCloseConnection"><c>true</c> if the connection was opened by the method, otherwose is false.</param>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.String,System.Data.CommandType,System.String)">
<summary>
Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in
the connection string
</summary>
<remarks>
e.g.:
int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders");
</remarks>
<param name="connectionString">A valid connection string for a SqlConnection</param>
<param name="commandType">The CommandType (stored procedure, text, etc.)</param>
<param name="commandText">The stored procedure name or T-SQL command</param>
<returns>An int representing the number of rows affected by the command</returns>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.String,System.Data.CommandType,System.String,System.Data.SqlClient.SqlParameter[])">
<summary>
Execute a SqlCommand (that returns no resultset) against the database specified in the connection string
using the provided parameters
</summary>
<remarks>
e.g.:
int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
</remarks>
<param name="connectionString">A valid connection string for a SqlConnection</param>
<param name="commandType">The CommandType (stored procedure, text, etc.)</param>
<param name="commandText">The stored procedure name or T-SQL command</param>
<param name="commandParameters">An array of SqlParamters used to execute the command</param>
<returns>An int representing the number of rows affected by the command</returns>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.String,System.String,System.Object[])">
<summary>
Execute a stored procedure via a SqlCommand (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 is called), and assign the values based on parameter order.
</summary>
<remarks>
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);
</remarks>
<param name="connectionString">A valid connection string for a SqlConnection</param>
<param name="spName">The name of the stored prcedure</param>
<param name="parameterValues">An array of objects to be assigned as the input values of the stored procedure</param>
<returns>An int representing the number of rows affected by the command</returns>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.Data.SqlClient.SqlConnection,System.Data.CommandType,System.String)">
<summary>
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlConnection.
</summary>
<remarks>
e.g.:
int result = ExecuteNonQuery(conn, CommandType.StoredProcedure, "PublishOrders");
</remarks>
<param name="connection">A valid SqlConnection</param>
<param name="commandType">The CommandType (stored procedure, text, etc.)</param>
<param name="commandText">The stored procedure name or T-SQL command</param>
<returns>An int representing the number of rows affected by the command</returns>
</member>
<member name="M:Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(System.Data.SqlClient.SqlConnection,System.Data.CommandType,System.String,System.Data.SqlClient.SqlParameter[])">
<summary>
Execute a SqlCommand (that returns no resultset) against the specified SqlConnection
没有合适的资源?快使用搜索试试~ 我知道了~
ASP.NET 分页 二 支持 排序
共23个文件
cs:7个
dll:3个
csproj:2个
需积分: 0 3 下载量 68 浏览量
2008-12-05
13:10:46
上传
评论
收藏 56KB ZIP 举报
温馨提示
private void BindGrid(int pageNumber) { SqlDataReader dr = null; try { dr = SqlHelper.ExecuteReader(conStr, spName, new object[]{Tables, PK, Sort, pageNumber, PageSize, Fields, Filter, Group}); DataGrid1.DataSource = dr; DataGrid1.DataBind(); } catch (Exception ex) { throw(ex); } finally { if (dr!=null) dr.Close(); } } //Handle Paging private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) { DataGrid1.CurrentPageIndex = e.NewPageIndex ; BindGrid(e.NewPageIndex ); }
资源详情
资源评论
资源推荐
收起资源包目录
PagingTest.zip (23个子文件)
PagingTest.sln 1KB
PagingConsoleTest
Paging.cs 3KB
bin
Debug
Release
PagingTest.exe 32KB
Microsoft.ApplicationBlocks.Data.xml 85KB
Microsoft.ApplicationBlocks.Data.dll 32KB
PageResponseTestCollection.cs 52KB
PageResponseTest.cs 1KB
PagingConsoleTest.csproj.user 2KB
PagingConsoleTest.csproj 4KB
AssemblyInfo.cs 2KB
PagingWebTest
WebForm1.aspx.cs 3KB
Global.asax.cs 1KB
Global.asax 80B
bin
PagingWebTest.dll 20KB
Microsoft.ApplicationBlocks.Data.xml 85KB
Microsoft.ApplicationBlocks.Data.dll 32KB
Web.config 4KB
PagingWebTest.csproj.webinfo 124B
WebForm1.aspx 919B
PagingWebTest.csproj 6KB
WebForm1.aspx.resx 5KB
Global.asax.resx 2KB
AssemblyInfo.cs 3KB
共 23 条
- 1
whiskerzhao
- 粉丝: 2
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0