C#使用存储过程实例

 

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using DataAccessLayer;
using System.Data.SqlClient;

namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtPageIndex.Text.Trim().Length <= 0 || txtPageSize.Text.Trim().Length <= 0)
{
Response.Write("<script>alert('输入数据不正确!');</script>");
return;
}

//存储过程名 具体内容见本博客SQL分页库存储过程
string procName = "PROC_CommonCaseView";

//存储过程中的参数

//注意参数一定要和存储过程的一样哦，不一样会让你惊喜的
SqlParameter[] parameter = new SqlParameter[3]
{
new SqlParameter("@pageIndex", SqlDbType.Int, 32, ParameterDirection.Input, true, 0, 0, null, DataRowVersion.Default, null),
new SqlParameter("@pageSize", SqlDbType.Int, 32,ParameterDirection.Input, true, 0,0, null, DataRowVersion.Default, null),
new SqlParameter("@rowCount", SqlDbType.Int, 32,ParameterDirection.Output, true, 0,0, null, DataRowVersion.Default, null)
};

//输入参数赋值
parameter[0].Value = Convert.ToInt32(txtPageIndex.Text);
parameter[1].Value = Convert.ToInt32(txtPageSize.Text);

//SqlHelper,ClassBase在我的资源里，是两个通用数据库访问文件

DataSet dt = SqlHelper.ExecuteDataset(ClassBase.GetCon(), CommandType.StoredProcedure, procName, parameter);
//处理带输出参数的存储过程
if (parameter[2].Value != DBNull.Value)
{
lblrowcount.Text = parameter[2].Value.ToString();
}

//gvw_result 是GridView控件
gvw_result.DataSource = dt;
gvw_result.DataBind();
}
}
}