查询的存储过程怎么用啊?

[chgjz]

我写好了存储过程:
CREATE PROCEDURE findbook
@id int
AS
BEGIN
SET NOCOUNT ON;
SELECT getimage,bookname,author,zaiyao,tuijian,isonframe,ischeap,oldprice,nowprice
from book join images
on book.bookid=images.bookid
where classid=@id
END
GO
在VS2005中怎么用啊?
public void find(int id)
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(common.Class1.con);
SqlCommand com = new SqlCommand("find", conn);
com.CommandType = CommandType.StoredProcedure;
~~~~~~~~~(这怎么写啊?)
}

[liuyun1987]

SqlConnection conn = new SqlConnection (@"server = (local); user=sa;password=000000;" + "Database = jsjxywz"); 
conn.Open(); 
SqlCommand com = new SqlCommand("SBLX_update",conn); 
com.CommandType = CommandType.StoredProcedure; 
com.Parameters.Add("@MC",SqlDbType.VarChar); 
com.Parameters.Add("@KJ",SqlDbType.Float); 
string mc = "china"; 
float kj = 3.4f; 
com.Parameters["@MC"].Value = mc; 
com.Parameters["@KJ"].Value = kj; 
SqlDataReader dr = com.ExecuteReader(); 
dr.Close(); 
conn.Close(); 

[chgjz]

我列出的怎么写啊???你定义个MC,KJ 是干嘛的??我的不需要这样赋值吧??

[conan304]

或者直接用sqldatareader也可以

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";//数据库连接字符串
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "findbook";//存储过程名
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int, 4).Value = 1; //自己赋值吧
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
//....
conn.Close();