今天学会了简单的 ``创建存储过程``并调用

在SQL执行

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

 

ALTER     proc Sp_GetUp_picid
(
 @filepicid int
)as
 select top 1 filepicid from fileupload where filepicid<@filepicid
  and fileboxname=(select fileboxname from fileupload where filepicid=@filepicid)
      order by filepicid desc

 

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

 

在数据操作类里面调用存储过程

 #region 实现上一页存储过程
    /// <summary>
    /// 实现上一页存储过程
    /// </summary>
    /// <param name="picid"></param>
    /// <returns></returns>
    public int GetUppicid(int picid)
    {
        int result = 0;
        sqlcom = new SqlCommand();
        sqlcom.Connection = sqlcon;
        sqlcom.CommandText = "Sp_GetUp_picid";
        sqlcom.CommandType = CommandType.StoredProcedure;
        try
        {
            sqlcom.Parameters.Add("@filepicid", SqlDbType.Int);
            sqlcom.Parameters["@filepicid"].Value = picid;
            object apicid = sqlcom.ExecuteScalar();
            if (apicid != null)
            {
                result = Convert.ToInt32(apicid);
            }
            else
            {
                result = 0;
            }
            return result;
        }
        catch
        {
            return result;
        }
        finally
        {
            sqlcon.Close();
        }
    }
    #endregion

 

在页面CS里面调用数据库存储过程的操作类

  //上一页
        linkdata linkdata = new linkdata();
        int filepicid = linkdata.GetUppicid(int.Parse(Getid()));
        if (filepicid == 0)
        {
            Page.RegisterClientScriptBlock("alert", "<script>alert('已经是最后一张图了');history.go(-1);</script>");
        }
        else
        {

            Response.Redirect("showpic.aspx?FilePicid=" + filepicid.ToString() + "&index=" + Convert.ToString(GetPageindex()-1));
        }