<p><font face="Verdana">--T-SQL不带参数<br />if exists(select * from sysobjects where name='SelectStu')<br />drop proc SelectStu<br />GO<br />create proc SelectStu<br />as<br />select * from student<br />GO</font></p><p><br /><font face="Verdana">--c#<br />SqlCommand cmd = new SqlCommand("SelectStu",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> SqlDataReader dr = cmd.ExecuteReader();<br /> while(dr.Read())<br /> {<br /> Console.WriteLine(dr["LoginId"]);<br /> }</font></p><p><font face="Verdana"> </font></p><p><font face="Verdana">--T-SQL 带一个参数<br />if exists(select * from sysobjects where name='SelectStu')<br />drop proc SelectStu<br />GO<br />create proc SelectStu<br />@name varchar(50)<br />as<br />select * from student where loginid=@name<br />GO</font></p><p><br /><font face="Verdana">--C#<br />SqlCommand cmd = new SqlCommand("SelectStu",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> cmd.Parameters.Add("@name", "LiDifei");<br /> SqlDataReader dr = cmd.ExecuteReader();<br /> while(dr.Read())<br /> {<br /> Console.WriteLine(dr["LoginId"]);<br /> }</font></p><p><br /><font face="Verdana">--T-SQL 有返回值<br />if exists(select * from sysobjects where name='SelectStu')<br />drop proc SelectStu<br />GO<br />create proc SelectStu<br />@name varchar(50),<br />@id int output<br />as<br />select @id=studentid from student where loginid=@name<br />return @id<br />GO</font></p><p><br /><font face="Verdana">--C#<br />SqlCommand cmd = new SqlCommand("SelectStu",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> cmd.Parameters.Add("@name", "LiDifei");<br /> cmd.Parameters.Add("@id",SqlDbType.Int);<br /> cmd.Parameters["@id"].Direction = ParameterDirection.Output;<br /> cmd.ExecuteScalar();<br /> Console.WriteLine(cmd.Parameters["@id"].Value);</font></p><p><font face="Verdana"> </font></p><p><br /><font face="Verdana">-------------------------------------------------------------------------------------</font></p><p><font face="Verdana"> </font></p><p><font face="Verdana">//以前写过的一个调用存储过程的方法</font></p><p><font face="Verdana"> public static int regInsert(string Pwd, int Friend, string NickName, int FaceID, string Sex, int Age, string Name, int starId, int BloodTypeId)<br /> {<br /> try<br /> {<br /> SqlConnection conn = createConnection();<br /> conn.Open();<br /> SqlCommand cmd = new SqlCommand("proc_reg", conn);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> <b><span style="color: #ff0000">cmd.Parameters.Add("@id",SqlDbType.Int);<br /> 如果是id是字符型的话,必须把输出长度写上,输入参数可以不用写长度,但是输出参数必须写上长度.</span></b></font><br /><font face="Verdana"><span style="color: #ff0000"><strong> cmd.Parameters.Add("@id",SqlDbType.navchar,50);</strong></span><br /> cmd.Parameters["@id"].Direction = ParameterDirection.Output;<br /> cmd.Parameters.AddWithValue("@LoginPwd",Pwd);<br /> cmd.Parameters.AddWithValue("@FriendshipPolicyId",Friend);<br /> cmd.Parameters.AddWithValue("@NickName",NickName);<br /> cmd.Parameters.AddWithValue("@FaceID",FaceID);<br /> cmd.Parameters.AddWithValue("@Sex",Sex);<br /> cmd.Parameters.AddWithValue("@Age",Age);<br /> cmd.Parameters.AddWithValue("@Name",Name);<br /> cmd.Parameters.AddWithValue("@starId",starId);<br /> cmd.Parameters.AddWithValue("@BloodTypeId", BloodTypeId);</font></p><p><font face="Verdana"> <br /> <br /> cmd.ExecuteNonQuery();<br /> return (int)cmd.Parameters["@id"].Value;<br /> <br /> <br /> }<br /> catch (SqlException ex)<br /> {<br /> Console.WriteLine(ex.Message);<br /> }<br /> return 0;<br /> <br /> }</font></p><p><font face="Verdana"> </font></p><p><br /><font face="Verdana">------------------------------------------------------------------------------- </font></p><p><font face="Verdana">//从网上摘抄<br /> <br />string ConnectionString = "server=.;database=PubData;uid=sa;pwd=123456";<br /> using (SqlConnection Conn = new SqlConnection(ConnectionString))<br /> { <br /> <br /> SqlCommand CMD = new SqlCommand();<br /> CMD.CommandType = CommandType.StoredProcedure;<br /> CMD.Connection = Conn;<br /> //没有输入参数调用有返回参数<br /> //存储过程如下<br /> //------------------------------------<br /> //--用途:得到最大ID <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_GetMaxId<br /> //AS<br /> //DECLARE @TempID int<br /> //SELECT @TempID = max([BaseDataID])+1 FROM SysBaseData<br /> //IF @TempID IS NULL<br /> // RETURN 1<br /> //ELSE<br /> // RETURN @TempID</font></p><p><font face="Verdana"> CMD.CommandText = "SysBaseData_GetMaxId";<br /> Conn.Open();<br /> CMD.Parameters.Add(new SqlParameter("ReturnValue",<br /> SqlDbType.Int, 4, ParameterDirection.ReturnValue,<br /> false, 0, 0, string.Empty, DataRowVersion.Default, null));<br /> CMD.ExecuteScalar();<br /> Response.Write("没有输入参数调用有返回参数:"+CMD.Parameters["ReturnValue"].Value);<br /> Response.Write("<br>");</font></p><p><font face="Verdana"> //有一个传入参数和返回参数<br /> //------------------------------------<br /> //--用途:是否已经存在 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_Exists<br /> //@BaseDataID int<br /> //AS<br /> // DECLARE @TempID int<br /> // SELECT @TempID = count(1) FROM SysBaseData WHERE [BaseDataID] = @BaseDataID<br /> // IF @TempID = 0<br /> // RETURN 0<br /> // ELSE<br /> // RETURN 1</font></p><p><font face="Verdana"> CMD.CommandText = "SysBaseData_Exists";<br /> SqlParameter[] parameters = { new SqlParameter("@BaseDataID", SqlDbType.Int) };<br /> parameters[0].Value = 22;<br /> CMD.Parameters.Add(parameters[0]);<br /> CMD.Parameters.Add(new SqlParameter("ReturnValue",SqlDbType.Int, 4, ParameterDirection.ReturnValue,false, 0, 0, string.Empty, DataRowVersion.Default, null));<br /> int j = CMD.ExecuteNonQuery();<br /> Response.Write("有一个传入参数和返回参数:"+CMD.Parameters["ReturnValue"].Value);<br /> Response.Write("<br>");<br /> CMD.Parameters.Clear();</font></p><p><font face="Verdana"> //有一个传入参数没有返回值<br /> //------------------------------------<br /> //--用途:删除一条记录 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_Delete<br /> //@BaseDataID int<br /> // AS <br /> // DELETE SysBaseData<br /> // WHERE [BaseDataID] = @BaseDataID<br /> CMD.CommandText = "SysBaseData_Delete";<br /> SqlParameter[] parameters2 = { new SqlParameter("@BaseDataID",SqlDbType.Int) };<br /> parameters2[0].Value = 29;<br /> CMD.Parameters.Add(parameters2[0]);<br /> int k = CMD.ExecuteNonQuery();<br /> Response.Write("有一个传入参数没有返回值:" + k);<br /> CMD.Parameters.Clear();<br /> Response.Write("<br>");</font></p><p><font face="Verdana"> //有多个转入参数没有近回值<br /> //------------------------------------<br /> //--用途:修改一条记录 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_Update<br /> //@BaseDataID int,<br /> //@BaseDataCode char(10),<br /> //@BaseDataName varchar(30),<br /> //@ParentCode char(10),<br /> //@Description varchar(100),<br /> //@LevelType int,<br /> //@VaildType char(1),<br /> //@PathCode varchar(100),<br /> //@SerialNumberID int,<br /> //@msrepl_tran_version uniqueidentifier<br /> // AS <br /> // UPDATE SysBaseData SET <br /> // [BaseDataCode] = @BaseDataCode,[BaseDataName] = @BaseDataName,[ParentCode] = @ParentCode,[Description] = @Description,[LevelType] = @LevelType,[VaildType] = @VaildType,[PathCode] = @PathCode,[SerialNumberID] = @SerialNumberID,[msrepl_tran_version] = @msrepl_tran_version<br /> // WHERE [BaseDataID] = @BaseDataID<br /> CMD.CommandText = "SysBaseData_Update";<br /> SqlParameter[] parameters3 = { <br /> new SqlParameter("@BaseDataID",SqlDbType.Int),<br /> new SqlParameter("@BaseDataCode",SqlDbType.VarChar),<br /> new SqlParameter("@BaseDataName",SqlDbType.VarChar),<br /> new SqlParameter("@ParentCode",SqlDbType.VarChar),<br /> new SqlParameter("@Description",SqlDbType.VarChar),<br /> new SqlParameter("@LevelType",SqlDbType.Int),<br /> new SqlParameter("@VaildType",SqlDbType.VarChar),<br /> new SqlParameter("@PathCode",SqlDbType.VarChar),<br /> new SqlParameter("@SerialNumberID",SqlDbType.Int)<br /> };<br /> parameters3[0].Value = 28;<br /> parameters3[1].Value = "DCCK02";<br /> parameters3[2].Value = "中秋节0";<br /> parameters3[3].Value = "DCCK";<br /> parameters3[4].Value = "";<br /> parameters3[5].Value = 3;<br /> parameters3[6].Value = "0";<br /> parameters3[7].Value = "";<br /> parameters3[8].Value = 0;<br /> foreach(SqlParameter parameter in parameters3)<br /> {<br /> CMD.Parameters.Add(parameter);<br /> }<br /> int m = CMD.ExecuteNonQuery();<br /> Response.Write("有多个转入参数没有近回值:" + m);<br /> CMD.Parameters.Clear();<br /> Response.Write("<br>");</font></p><p><br /><font face="Verdana"> //没有输入参数获得数据集<br /> //------------------------------------<br /> //--用途:查询记录信息 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE UP_SysBaseData_GetList<br /> // AS <br /> // SELECT <br /> // [BaseDataID],[BaseDataCode],[BaseDataName],[ParentCode],[Description],[LevelType],[VaildType],[PathCode],[SerialNumberID],[msrepl_tran_version]<br /> // FROM SysBaseData<br /> CMD.CommandText = "UP_SysBaseData_GetList";<br /> SqlDataAdapter DA = new SqlDataAdapter();<br /> DA.SelectCommand = CMD;<br /> DataSet DS = new DataSet();<br /> int n = DA.Fill(DS);<br /> Response.Write("没有输入参数获得数据集:" + n);<br /> Response.Write("<br>");<br /> //GridView1.DataSource = DS;<br /> //GridView1.DataBind();</font></p><p><font face="Verdana"> //有输入输出参数获得数据集<br /> //-- =============================================<br /> //-- Author: <Author,,Name><br /> //-- Create date: <Create Date,,><br /> //-- Description: <Description,,><br /> //-- =============================================<br /> //ALTER PROCEDURE [dbo].[UP_GetRecordByPage]<br /> // @PageSize int,<br /> // @PageIndex int,<br /> // @NCount int output<br /> //AS<br /> //declare @StarRow int<br /> //declare @EndRow int<br /> //select @NCount=count(BaseDataID) from SysBaseData<br /> //BEGIN<br /> // SET NOCOUNT ON;<br /> // with SysDataBaseList as <br /> // (<br /> // select row_number() over(order by BaseDataID desc) as rownumbers,<br /> // BaseDataID,BaseDataName,ParentCode <br /> // from SysBaseData<br /> // )<br /> // select * from SysDataBaseList where rownumbers between (@PageIndex-1)*@PageSize+1 and (@PageIndex-1)*@PageSize+@PageSize</font></p><p><font face="Verdana"> //END<br /> CMD.CommandText = "UP_GetRecordByPage";<br /> SqlDataAdapter DA2 = new SqlDataAdapter();<br /> SqlParameter[] parameters4 = {<br /> new SqlParameter("@PageSize",SqlDbType.Int),<br /> new SqlParameter("@PageIndex",SqlDbType.Int),<br /> new SqlParameter("@NCount",SqlDbType.Int, 4, ParameterDirection.Output,false, 0, 0, string.Empty, DataRowVersion.Default, null)<br /> };<br /> parameters4[0].Value = 5;<br /> parameters4[1].Value = 2;</font></p><p><font face="Verdana"> foreach (SqlParameter parameter in parameters4)<br /> {<br /> CMD.Parameters.Add(parameter);<br /> }<br /> DA2.SelectCommand = CMD;<br /> DataSet DS2 = new DataSet();<br /> int n2 = DA2.Fill(DS2);<br /> Response.Write("有输入输出参数获得数据集:" + n2 + "一共" + CMD.Parameters[2].Value + "行");<br /> GridView1.DataSource = DS2;<br /> GridView1.DataBind();<br /> }</font></p> Loading... <p><font face="Verdana">--T-SQL不带参数<br />if exists(select * from sysobjects where name='SelectStu')<br />drop proc SelectStu<br />GO<br />create proc SelectStu<br />as<br />select * from student<br />GO</font></p><p><br /><font face="Verdana">--c#<br />SqlCommand cmd = new SqlCommand("SelectStu",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> SqlDataReader dr = cmd.ExecuteReader();<br /> while(dr.Read())<br /> {<br /> Console.WriteLine(dr["LoginId"]);<br /> }</font></p><p><font face="Verdana"> </font></p><p><font face="Verdana">--T-SQL 带一个参数<br />if exists(select * from sysobjects where name='SelectStu')<br />drop proc SelectStu<br />GO<br />create proc SelectStu<br />@name varchar(50)<br />as<br />select * from student where loginid=@name<br />GO</font></p><p><br /><font face="Verdana">--C#<br />SqlCommand cmd = new SqlCommand("SelectStu",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> cmd.Parameters.Add("@name", "LiDifei");<br /> SqlDataReader dr = cmd.ExecuteReader();<br /> while(dr.Read())<br /> {<br /> Console.WriteLine(dr["LoginId"]);<br /> }</font></p><p><br /><font face="Verdana">--T-SQL 有返回值<br />if exists(select * from sysobjects where name='SelectStu')<br />drop proc SelectStu<br />GO<br />create proc SelectStu<br />@name varchar(50),<br />@id int output<br />as<br />select @id=studentid from student where loginid=@name<br />return @id<br />GO</font></p><p><br /><font face="Verdana">--C#<br />SqlCommand cmd = new SqlCommand("SelectStu",con);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> cmd.Parameters.Add("@name", "LiDifei");<br /> cmd.Parameters.Add("@id",SqlDbType.Int);<br /> cmd.Parameters["@id"].Direction = ParameterDirection.Output;<br /> cmd.ExecuteScalar();<br /> Console.WriteLine(cmd.Parameters["@id"].Value);</font></p><p><font face="Verdana"> </font></p><p><br /><font face="Verdana">-------------------------------------------------------------------------------------</font></p><p><font face="Verdana"> </font></p><p><font face="Verdana">//以前写过的一个调用存储过程的方法</font></p><p><font face="Verdana"> public static int regInsert(string Pwd, int Friend, string NickName, int FaceID, string Sex, int Age, string Name, int starId, int BloodTypeId)<br /> {<br /> try<br /> {<br /> SqlConnection conn = createConnection();<br /> conn.Open();<br /> SqlCommand cmd = new SqlCommand("proc_reg", conn);<br /> cmd.CommandType = CommandType.StoredProcedure;<br /> <b><span style="color: #ff0000">cmd.Parameters.Add("@id",SqlDbType.Int);<br /> 如果是id是字符型的话,必须把输出长度写上,输入参数可以不用写长度,但是输出参数必须写上长度.</span></b></font><br /><font face="Verdana"><span style="color: #ff0000"><strong> cmd.Parameters.Add("@id",SqlDbType.navchar,50);</strong></span><br /> cmd.Parameters["@id"].Direction = ParameterDirection.Output;<br /> cmd.Parameters.AddWithValue("@LoginPwd",Pwd);<br /> cmd.Parameters.AddWithValue("@FriendshipPolicyId",Friend);<br /> cmd.Parameters.AddWithValue("@NickName",NickName);<br /> cmd.Parameters.AddWithValue("@FaceID",FaceID);<br /> cmd.Parameters.AddWithValue("@Sex",Sex);<br /> cmd.Parameters.AddWithValue("@Age",Age);<br /> cmd.Parameters.AddWithValue("@Name",Name);<br /> cmd.Parameters.AddWithValue("@starId",starId);<br /> cmd.Parameters.AddWithValue("@BloodTypeId", BloodTypeId);</font></p><p><font face="Verdana"> <br /> <br /> cmd.ExecuteNonQuery();<br /> return (int)cmd.Parameters["@id"].Value;<br /> <br /> <br /> }<br /> catch (SqlException ex)<br /> {<br /> Console.WriteLine(ex.Message);<br /> }<br /> return 0;<br /> <br /> }</font></p><p><font face="Verdana"> </font></p><p><br /><font face="Verdana">------------------------------------------------------------------------------- </font></p><p><font face="Verdana">//从网上摘抄<br /> <br />string ConnectionString = "server=.;database=PubData;uid=sa;pwd=123456";<br /> using (SqlConnection Conn = new SqlConnection(ConnectionString))<br /> { <br /> <br /> SqlCommand CMD = new SqlCommand();<br /> CMD.CommandType = CommandType.StoredProcedure;<br /> CMD.Connection = Conn;<br /> //没有输入参数调用有返回参数<br /> //存储过程如下<br /> //------------------------------------<br /> //--用途:得到最大ID <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_GetMaxId<br /> //AS<br /> //DECLARE @TempID int<br /> //SELECT @TempID = max([BaseDataID])+1 FROM SysBaseData<br /> //IF @TempID IS NULL<br /> // RETURN 1<br /> //ELSE<br /> // RETURN @TempID</font></p><p><font face="Verdana"> CMD.CommandText = "SysBaseData_GetMaxId";<br /> Conn.Open();<br /> CMD.Parameters.Add(new SqlParameter("ReturnValue",<br /> SqlDbType.Int, 4, ParameterDirection.ReturnValue,<br /> false, 0, 0, string.Empty, DataRowVersion.Default, null));<br /> CMD.ExecuteScalar();<br /> Response.Write("没有输入参数调用有返回参数:"+CMD.Parameters["ReturnValue"].Value);<br /> Response.Write("<br>");</font></p><p><font face="Verdana"> //有一个传入参数和返回参数<br /> //------------------------------------<br /> //--用途:是否已经存在 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_Exists<br /> //@BaseDataID int<br /> //AS<br /> // DECLARE @TempID int<br /> // SELECT @TempID = count(1) FROM SysBaseData WHERE [BaseDataID] = @BaseDataID<br /> // IF @TempID = 0<br /> // RETURN 0<br /> // ELSE<br /> // RETURN 1</font></p><p><font face="Verdana"> CMD.CommandText = "SysBaseData_Exists";<br /> SqlParameter[] parameters = { new SqlParameter("@BaseDataID", SqlDbType.Int) };<br /> parameters[0].Value = 22;<br /> CMD.Parameters.Add(parameters[0]);<br /> CMD.Parameters.Add(new SqlParameter("ReturnValue",SqlDbType.Int, 4, ParameterDirection.ReturnValue,false, 0, 0, string.Empty, DataRowVersion.Default, null));<br /> int j = CMD.ExecuteNonQuery();<br /> Response.Write("有一个传入参数和返回参数:"+CMD.Parameters["ReturnValue"].Value);<br /> Response.Write("<br>");<br /> CMD.Parameters.Clear();</font></p><p><font face="Verdana"> //有一个传入参数没有返回值<br /> //------------------------------------<br /> //--用途:删除一条记录 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_Delete<br /> //@BaseDataID int<br /> // AS <br /> // DELETE SysBaseData<br /> // WHERE [BaseDataID] = @BaseDataID<br /> CMD.CommandText = "SysBaseData_Delete";<br /> SqlParameter[] parameters2 = { new SqlParameter("@BaseDataID",SqlDbType.Int) };<br /> parameters2[0].Value = 29;<br /> CMD.Parameters.Add(parameters2[0]);<br /> int k = CMD.ExecuteNonQuery();<br /> Response.Write("有一个传入参数没有返回值:" + k);<br /> CMD.Parameters.Clear();<br /> Response.Write("<br>");</font></p><p><font face="Verdana"> //有多个转入参数没有近回值<br /> //------------------------------------<br /> //--用途:修改一条记录 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE SysBaseData_Update<br /> //@BaseDataID int,<br /> //@BaseDataCode char(10),<br /> //@BaseDataName varchar(30),<br /> //@ParentCode char(10),<br /> //@Description varchar(100),<br /> //@LevelType int,<br /> //@VaildType char(1),<br /> //@PathCode varchar(100),<br /> //@SerialNumberID int,<br /> //@msrepl_tran_version uniqueidentifier<br /> // AS <br /> // UPDATE SysBaseData SET <br /> // [BaseDataCode] = @BaseDataCode,[BaseDataName] = @BaseDataName,[ParentCode] = @ParentCode,[Description] = @Description,[LevelType] = @LevelType,[VaildType] = @VaildType,[PathCode] = @PathCode,[SerialNumberID] = @SerialNumberID,[msrepl_tran_version] = @msrepl_tran_version<br /> // WHERE [BaseDataID] = @BaseDataID<br /> CMD.CommandText = "SysBaseData_Update";<br /> SqlParameter[] parameters3 = { <br /> new SqlParameter("@BaseDataID",SqlDbType.Int),<br /> new SqlParameter("@BaseDataCode",SqlDbType.VarChar),<br /> new SqlParameter("@BaseDataName",SqlDbType.VarChar),<br /> new SqlParameter("@ParentCode",SqlDbType.VarChar),<br /> new SqlParameter("@Description",SqlDbType.VarChar),<br /> new SqlParameter("@LevelType",SqlDbType.Int),<br /> new SqlParameter("@VaildType",SqlDbType.VarChar),<br /> new SqlParameter("@PathCode",SqlDbType.VarChar),<br /> new SqlParameter("@SerialNumberID",SqlDbType.Int)<br /> };<br /> parameters3[0].Value = 28;<br /> parameters3[1].Value = "DCCK02";<br /> parameters3[2].Value = "中秋节0";<br /> parameters3[3].Value = "DCCK";<br /> parameters3[4].Value = "";<br /> parameters3[5].Value = 3;<br /> parameters3[6].Value = "0";<br /> parameters3[7].Value = "";<br /> parameters3[8].Value = 0;<br /> foreach(SqlParameter parameter in parameters3)<br /> {<br /> CMD.Parameters.Add(parameter);<br /> }<br /> int m = CMD.ExecuteNonQuery();<br /> Response.Write("有多个转入参数没有近回值:" + m);<br /> CMD.Parameters.Clear();<br /> Response.Write("<br>");</font></p><p><br /><font face="Verdana"> //没有输入参数获得数据集<br /> //------------------------------------<br /> //--用途:查询记录信息 <br /> //--项目名称:<br /> //--说明:<br /> //--时间:2007-12-6 17:15:27<br /> //------------------------------------<br /> //ALTER PROCEDURE UP_SysBaseData_GetList<br /> // AS <br /> // SELECT <br /> // [BaseDataID],[BaseDataCode],[BaseDataName],[ParentCode],[Description],[LevelType],[VaildType],[PathCode],[SerialNumberID],[msrepl_tran_version]<br /> // FROM SysBaseData<br /> CMD.CommandText = "UP_SysBaseData_GetList";<br /> SqlDataAdapter DA = new SqlDataAdapter();<br /> DA.SelectCommand = CMD;<br /> DataSet DS = new DataSet();<br /> int n = DA.Fill(DS);<br /> Response.Write("没有输入参数获得数据集:" + n);<br /> Response.Write("<br>");<br /> //GridView1.DataSource = DS;<br /> //GridView1.DataBind();</font></p><p><font face="Verdana"> //有输入输出参数获得数据集<br /> //-- =============================================<br /> //-- Author: <Author,,Name><br /> //-- Create date: <Create Date,,><br /> //-- Description: <Description,,><br /> //-- =============================================<br /> //ALTER PROCEDURE [dbo].[UP_GetRecordByPage]<br /> // @PageSize int,<br /> // @PageIndex int,<br /> // @NCount int output<br /> //AS<br /> //declare @StarRow int<br /> //declare @EndRow int<br /> //select @NCount=count(BaseDataID) from SysBaseData<br /> //BEGIN<br /> // SET NOCOUNT ON;<br /> // with SysDataBaseList as <br /> // (<br /> // select row_number() over(order by BaseDataID desc) as rownumbers,<br /> // BaseDataID,BaseDataName,ParentCode <br /> // from SysBaseData<br /> // )<br /> // select * from SysDataBaseList where rownumbers between (@PageIndex-1)*@PageSize+1 and (@PageIndex-1)*@PageSize+@PageSize</font></p><p><font face="Verdana"> //END<br /> CMD.CommandText = "UP_GetRecordByPage";<br /> SqlDataAdapter DA2 = new SqlDataAdapter();<br /> SqlParameter[] parameters4 = {<br /> new SqlParameter("@PageSize",SqlDbType.Int),<br /> new SqlParameter("@PageIndex",SqlDbType.Int),<br /> new SqlParameter("@NCount",SqlDbType.Int, 4, ParameterDirection.Output,false, 0, 0, string.Empty, DataRowVersion.Default, null)<br /> };<br /> parameters4[0].Value = 5;<br /> parameters4[1].Value = 2;</font></p><p><font face="Verdana"> foreach (SqlParameter parameter in parameters4)<br /> {<br /> CMD.Parameters.Add(parameter);<br /> }<br /> DA2.SelectCommand = CMD;<br /> DataSet DS2 = new DataSet();<br /> int n2 = DA2.Fill(DS2);<br /> Response.Write("有输入输出参数获得数据集:" + n2 + "一共" + CMD.Parameters[2].Value + "行");<br /> GridView1.DataSource = DS2;<br /> GridView1.DataBind();<br /> }</font></p> 最后修改:2009 年 08 月 16 日 © 允许规范转载 打赏 赞赏作者 支付宝微信 赞 支持就是力量