在*.aspx文件中如何使用存储过程？

[yusuan]

存储过程代码如下：

--在向MailList表添加记录时，检查是否有重复的记录存在
CREATE proc Check_MailList
@Email nvarchar(60),
@RecordCount bit OUTPUT
As
Select @RecordCount = (Select Count(Email) From MailList Where Email=@Email)
GO

在页面中要实现这样的功能，通过Email地址变量查找数据库中的记录，如果为1则显示已经有这条记录，添加失败；如果为0则添加新记录。
请问这样的功能在*.aspx文件中语句如何写？

[Oldman]

Like normal sql

[cmsoft]

SqlCommand cmd = new SqlCommand(procName,Conn);
cmd.CommandType = CommandType.StoredProcedure;

[blackcatiii]

write the codes like below (I prefer to the code-behind file .aspx.cs):

SqlConnection conn = new SqlConnection(strConnect); //get the connection object
SqlCommand cmd = new SqlCommand("Check_MailList",conn);
SqlParameter para = new SqlParameter("@Email",SqlDbType.NVarChar);
para.Value = txtMail.Text;
cmd.Parameters.Add(para);//define the parameters of the command object
para = new SqlParameter("@RecordCount",SqlDbType.Bit);
para.Direction = ParameterDirection.Output;
cmd.Parameters.Add(para);
try
{
conn.Open();//open the connection
cmd.ExecuteNonQuery();//execute the stored procedure
if ((bool)para["@RecordCount"])//the output value can be got now
{
//exist the record,do nothing
}
else
{
//do insert operation
}
}
catch(Exception x)
{
//do something to handle the exception
throw(x); //continue throwing the exception
}
finally
{
//do some cleanning work
if (conn.State == ConnectionState.Open)
{
conn.close();
}
}

[blackcatiii]

sorry,I forget to set the CommandType property :(

cmd.CommandType = CommandType.StoredProcedure;