存储过程如下:
ALTER PROCEDURE dbo.sele_ypdd
(@PM VARCHAR(50) OUTPUT
)
AS
begin
SELECT heyuehao,prodtype,pm FROM ypdd where id=1234 ORDER BY HEYUEHAO
SET NOCOUNT ON;
DECLARE cur_1 CURSOR FOR SELECT dq FROM ypdd where id=1234 ORDER BY HEYUEHAO
open cur_1;
FETCH cur_1 INTO @pm;
end
取@PM如下
Dim param As SqlClient.SqlParameter
param = New SqlClient.SqlParameter("@pm", SqlDbType.VarChar)
param.Direction = ParameterDirection.Output
SqlDataAdapter3.SelectCommand.Parameters.Add(param)
param.Value = "adfadfs"
ddh.DataBind()
kf.Text = SqlDataAdapter3.SelectCommand.Parameters.Item("@pm").Valuekf.text结果为空
ALTER PROCEDURE dbo.sele_ypdd
(@PM VARCHAR(50) OUTPUT
)
AS
begin
SELECT heyuehao,prodtype,pm FROM ypdd where id=1234 ORDER BY HEYUEHAO
SET NOCOUNT ON;
DECLARE cur_1 CURSOR FOR SELECT dq FROM ypdd where id=1234 ORDER BY HEYUEHAO
open cur_1;
FETCH cur_1 INTO @pm;
end
取@PM如下
Dim param As SqlClient.SqlParameter
param = New SqlClient.SqlParameter("@pm", SqlDbType.VarChar)
param.Direction = ParameterDirection.Output
SqlDataAdapter3.SelectCommand.Parameters.Add(param)
param.Value = "adfadfs"
ddh.DataBind()
kf.Text = SqlDataAdapter3.SelectCommand.Parameters.Item("@pm").Valuekf.text结果为空
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货