C#+SQL2000 存储过程的问题

[shaolilove]

//方法
public void Hsearch(string column,string key,DataGridView dgv)
{
SqlConnection con = this.Getcon();
con.Open();
SqlCommand com = new SqlCommand("proc_Hsearch",con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@column", SqlDbType.VarChar, 20).Value = column;
com.Parameters.Add("@key", SqlDbType.VarChar, 20).Value = key;
SqlDataAdapter sa = new SqlDataAdapter(com);
DataSet ds = new DataSet();
sa.Fill(ds,"BM_Info"); //老是报错提示 必须声明变量 '@key'。
DataTable dt=ds.Tables[0];
dgv.DataSource = dt;
}
//SQL命令

CREATE PROCEDURE proc_Hsearch
(@column varchar(20),
@key varchar(20))
AS
begin
declare @sql varchar(100)
set @sql='select * from BM_Info where '+quotename(@column)+'=@key'
exec (@sql)
end

GO


请帮忙解决一下，在线等，谢谢啦！

[herty]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author:		He Lei
-- Create date: 2008/12/22
-- Description:	Select ToInviteFriends By  IsRegistered And SendMailCount
-- =============================================
ALTER PROCEDURE [dbo].[MyCitySP_GetToInviteFriends]			      
				 @IsRegistered bit=0
				,@SendMailCount int = 0
	
AS
BEGIN

	SELECT TOP 1  *  FROM [MyCity].[dbo].[ToInviteFriends] WHERE [IsRegistered] = @IsRegistered  AND
    [SendMailCount] = @SendMailCount
                                                              
END

格式不对 这样写

[herty]

ALTER 改 CREATE

[猿敲月下码]

存储过程改下试试：

CREATE PROCEDURE proc_Hsearch 
@column varchar(20), 
@key varchar(20) 
AS 
--这里面直接写你的SQL句子
GO 

[lovehongyun]

CREATE PROCEDURE proc_Hsearch 
(
@column varchar(20), 
@key varchar(20)
) 
AS 
begin 
declare @sql varchar(100) 
set @sql='select * from BM_Info where '+quotename(@column_)+'=@key_' 
exec sp_executesql @sql, N'@column_ varchar(20),@key_ int',
@column,@key
end 

要用sp_executesql 你可以查一下sql的联机帮助.
我手改的.没经过测试

[shaolilove]

不好意思，楼上的 ，已经结贴了，还是谢谢你的回答