.net 怎么接收sql存储过程返回的结果？

[wang_jf411]

比如存储过程返回三个output：@a = '0' @b = '执行成功！' @c = '好'

在aspx页面上怎么来接收这三个结果，显示到三个输入框中？

[iuhxq]

http://www.google.cn/search?hl=zh-CN&q=SqlParameter+output&meta=&aq=f&oq=

[hongqi162]

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "...........";
SqlCommand cmd = new SqlCommand();
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "aa";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@a", SqlDbType.VarChar, "");
cmd.Parameters["@a"].Direction = ParameterDirection.Output;

cmd.Parameters.Add("@b", SqlDbType.VarChar, "");
cmd.Parameters["@b"].Direction = ParameterDirection.Output;

cmd.Parameters.Add("@c", SqlDbType.VarChar, "");
cmd.Parameters["@c"].Direction = ParameterDirection.Output;

cmd.EndExecuteNonQuery();

Response.Write(cmd.Parameters["@a"].Value.ToString());

[扎德]

楼上写得很详细了

[wang_jf411]

cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "Pro_Admin_GetDetail"; //存储过程
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@entername", SqlDbType.VarChar,0);
cmd.Parameters["@entername"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@enterip", SqlDbType.VarChar, 0);
cmd.Parameters["@enterip"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 0);
cmd.Parameters["@email"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@title", SqlDbType.VarChar, 0);
cmd.Parameters["@title"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@content", SqlDbType.VarChar, 0);
cmd.Parameters["@content"].Direction = ParameterDirection.Output;

cmd.EndExecuteNonQuery();

Response.Write(cmd.Parameters["@title"].Value.ToString());

是不是这样表达么，不成功！ 还请各位帮帮忙阿

[oktell]

"@entername","@enterip","@email"等参数怎么都是“传出参数类型”，应该只有一个传出参数啊。

[hongqi162]

怎么不成功？错误信息是什么？

[我姓区不姓区]

[Quote=引用 4 楼 wang_jf411 的回复:]
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "Pro_Admin_GetDetail";  //存储过程
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@entername", SqlDbType.VarChar,0);
cmd.Parameters["@entername"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@enterip", SqlDbType.VarChar, 0);
cmd.Parameters["@enterip"].Direction = Param…
[/Quote]
不成功是指执行存储过程出错还是输出参数的值不对？

[frankie_24]

已经写的很清楚了,你是不是调试看看哪里有问题!

[编程有钱人了]

2L正解