VS中的问题高手指教~~
我有个KTV数据库创建了一个存储过程如下：alter PROC proc_song
@current int=1,
@pagesize int=8,
@singercity int,
@sex char(2)
AS
select top (@pagesize) simage from singer where singerid
not in(select top ((@current-1)* @pagesize) singerid from singer order by sname)
and singercity=@singercity and sex=@sex order by sname
go
在winform中怎么样为存储过程传参呢？？
DBHelper.connection.Open();
SqlCommand command = new SqlCommand("proc_song", DBHelper.connection);
SqlDataReader dr = command.ExecuteReader();
command.CommandType = CommandType.StoredProcedure;
SqlParameter[] par = new SqlParameter[]
{
new SqlParameter("@current",1),
new SqlParameter("@pagesize",8),
new SqlParameter("@singercity",1),
new SqlParameter("@sex","男"),
};
这样写提示我为给@singercity传参
高手指点下~~
--------------------编程问答-------------------- 不会存储过程阿
--------------------编程问答--------------------
SqlDataReader dr = command.ExecuteReader(); 这句应该在最后执行。
--------------------编程问答--------------------
还需要给command设置你定义的参数 SqlParameter[] par = new SqlParameter[]
--------------------编程问答--------------------
我已经给存储过程的变量进行赋值了 new了4个对象~
--------------------编程问答--------------------
补充：.NET技术 , C#
