有这样的一个存储过程:
CREATE PROCEDURE checkstate @param varchar(11)
AS
IF (SELECT state FROM authors WHERE au_id = @param) = 'CA'
RETURN 1
ELSE
RETURN 2
问题是我怎样在程序接收到sql返回的值???
用Command.ExecuteScalar()??还是用Command.ecuteNonQuery();??
CREATE PROCEDURE checkstate @param varchar(11)
AS
IF (SELECT state FROM authors WHERE au_id = @param) = 'CA'
RETURN 1
ELSE
RETURN 2
问题是我怎样在程序接收到sql返回的值???
用Command.ExecuteScalar()??还是用Command.ecuteNonQuery();??
解决方案 »
- WCF RESTful 权限的控制
- XFire在Eclipse中开发webservice,C#中调用:中文为乱码!
- 请问如何安全的销毁线程
- C#释放内存空间的问题~急急急
- 关于实体的循环取值的问题,因扰了好久了!
- 高手请看看这个数据库DTS的ActiveX脚本是什么错误呀
- c# 怎么获取datagridview中DataGridViewComboBox的显示值(不是value实际值)啊?急
- C#怎样在窗体上实现拓扑结构图
- 只显示验证码,而其他都不显示?
- c#访问access时like 查询的内存溢出
- 请 RainAndFire 过来,给您另加20分
- 怎么实现在listview里面用鼠标选择多行啊??
是这个,但是update 或delete执行后Command.ecuteNonQuery()返回影响的行数,不要误用哦
@title varchar(80), -- This is the input parameter.
@ytd_sales int OUTPUT -- This is the output parameter.
AS -- Get the sales for the specified title and
-- assign it to the output parameter.
SELECT @ytd_sales = ytd_sales
FROM titles
WHERE title = @titleRETURN
GO
///============public override bool ExecuteStoredProc(string pcSPName, ArrayList poParams, ref string pcOutputParamName)
{
bool llRetVal = false; if (this._Connection!=null)
{
try
{
SqlCommand loCommand = new SqlCommand(pcSPName, this._Connection,
this._Transaction);
loCommand.CommandType = CommandType.StoredProcedure;
foreach (npIdName loParam in poParams)
{
SqlParameter loSqlParm = new SqlParameter("@"+loParam.Id, SqlDbType.NChar);
loSqlParm.Value = loParam.Name;
loSqlParm.Direction = ParameterDirection.Input;
loCommand.Parameters.Add(loSqlParm);
}
if (pcOutputParamName!="")
{
pcOutputParamName = "@"+pcOutputParamName;
SqlParameter loOutPutParm = new SqlParameter(pcOutputParamName, SqlDbType.NChar);
loOutPutParm.Direction = ParameterDirection.Output;
loCommand.Parameters.Add(loOutPutParm);
} loCommand.ExecuteNonQuery();
if (pcOutputParamName!="")
pcOutputParamName = loCommand.Parameters[pcOutputParamName].Value.ToString(); llRetVal = true;
}
catch (Exception e)
{
this.FireDBConnectionError("ExecuteStoredProc", pcSPName, e.Message);
}
} return llRetVal;
}