SELECT Categories.*
FROM Categories
WHERE (year = @year) AND (month = @month)
ORDER BY brandname这是一条sql语句,我想把他select的值作为返回值放在一个dataset中,这个存储过程该怎么写?
FROM Categories
WHERE (year = @year) AND (month = @month)
ORDER BY brandname这是一条sql语句,我想把他select的值作为返回值放在一个dataset中,这个存储过程该怎么写?
( @year varchar(20),
@moth varchar (20))
as
SELECT Categories.*
FROM Categories
WHERE (year = @year) AND (month = @month)
ORDER BY brandname///*************************///
这两年来慢慢习惯了光说不练
///*************************///
( @year nvarchar(10),
@moth nvarchar (10))
as
SELECT Categories.*
FROM Categories
WHERE (year = @year) AND (month = @month)
ORDER BY brandname
(
@year varchar(20),
@moth varchar (20)
)
as
SELECT * FROM Categories WHERE (year = @year) AND (month = @month) ORDER BY brandnamepublic Dataset takedate(DateTime year Date)
{
.....
DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter("",)
da.Fill(ds);
return ds;
}
(
@year varchar(20),
@moth varchar (20)
)
as
SELECT * FROM Categories WHERE (year = @year) AND (month = @month)
ORDER BY brandname代码里只要执行这个存储过程就可以了啊
使用cmd.ExecuteReader绑定,也可以使用SqlDataAdapter和DataSet ,然后da.Fill(ds)
就得到了一个DataSet了啊