【转】 http://hi.baidu.com/zck98530/blog/item/cbd82ef58240d525bd3109d4.html
今天在完成一个小功能的时候要用到一个存储过程,把执行的结果返到一个数据里,不多说了,把代码放上来,其实很简单的.
存储过程
create proc pro_ShowCommend
as
SELECT [user].Us_id, [user].Us_name, [user].Us_purl, [user].Us_sex, [user].Us_height,
[user].Us_monthlyPay, [user].Us_WorkArea, [user].Us_occupation,
[user].Us_learning, [user].Us_FriendArea, [user].us_marriage, [user].Us_sensibility,
user_group.Ug_photo, Commend.Co_ida,Commend.Co_ifok,datediff(day,getdate(),DateAdd(day,Commend.Co_day,Commend.co_passTime)) as chaday,datepart(year,getdate())-datepart(year,[user].us_birthday) as us_age
FROM Commend INNER JOIN
[user] ON Commend.Us_id = [user].Us_id INNER JOIN
user_group ON [user].Ug_IDA = user_group.Ug_IDA
WHERE (Commend.Co_ifok = 1)
程序代码(.CS)
private DataSet GetDataSet()
{
SqlConnection conn=DBWork.GetConn();
SqlCommand cmd=new SqlCommand("pro_showcommend",conn);
cmd.CommandType=CommandType.StoredProcedure;
DataSet ds=new DataSet();
conn.Open();
SqlDataAdapter da=new SqlDataAdapter();
da.SelectCommand=cmd;
da.Fill(ds,"testcommend");
conn.Close();
return ds;
}