CREATE PROCEDURE QX { @district NVARCHAR(50), @num int } AS BEGIN if @num=1 BEGIN SELECT * FROM [tbAppli_Info] WHERE district = @district order by [appliNum] ASC END ELSE if @num=2 BEGIN SELECT * FROM [tbAppli_Info] WHERE district = @district order by [total] ASCEND END调用方法搜索一下
调用方法: DataTable dt = new DataTable(); //建一个容器装取出的数据 SqlParameter[] sqlParams = new SqlParameter[1]; //声明一个只能装一个元素的SqlParameter列表 sqlParams[0] = new SqlParameter("@district", SqlDbType.NVarChar); //传入参数 sqlParams[0].Value = "你自定义的值"; dt = SqlHelper.ExecuteDataTable(CommandType.StoredProcedure, "存储过程名", sqlParams); //SqlHelper为自定义数据库操作类(你也可以自己写连接数据库的代码)
CREATE PROCEDURE QX
{
@district NVARCHAR(50),
@num int
}
AS
BEGIN
if @num=1
BEGIN
SELECT * FROM [tbAppli_Info] WHERE district = @district order by [appliNum] ASC
END
ELSE
if @num=2
BEGIN
SELECT * FROM [tbAppli_Info] WHERE district = @district order by [total] ASCEND
END调用方法搜索一下
DataTable dt = new DataTable(); //建一个容器装取出的数据
SqlParameter[] sqlParams = new SqlParameter[1]; //声明一个只能装一个元素的SqlParameter列表
sqlParams[0] = new SqlParameter("@district", SqlDbType.NVarChar); //传入参数
sqlParams[0].Value = "你自定义的值";
dt = SqlHelper.ExecuteDataTable(CommandType.StoredProcedure, "存储过程名", sqlParams); //SqlHelper为自定义数据库操作类(你也可以自己写连接数据库的代码)