存储过程返回值问题

[_程序员]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER procedure [dbo].[insertemployee]
@TitleOfCourtesy varchar(25),
@LastName varchar(20),
@FistName varchar(10),
@EmployeeID int OUTPUT
AS
INsert INto Employees
(TitleOfCOurtesy,LastName,FistName,HireDate)values(@TitleOfCourtesy,@LastName,@FistName,GETUTCDATE());
set @EmployeeID = @@IDEntity

[_程序员]

为什么 没有返回值...?

[wuyq11]

设置ParameterDirection.Output;
parameters[3].Value返回值

[_程序员]

cmd.Parameters["@EmployeeID"].Direction = ParameterDirection.Output;
cmd.Parameters["@EmployeeID"].Value
这两句吗?
不行哦

[wuyq11]

IDataParameter[] parameters = {
new SqlParameter("@TitleOfCourtesy ", SqlDbType.NVarChar,25) ,
new SqlParameter("@LastName ", SqlDbType.NVarChar,20) ,
new SqlParameter("@FistName ", SqlDbType.NVarChar,20) ,
new SqlParameter("@EmployeeID ", SqlDbType.Int,4)
};
parameters[0].Value = "";
parameters[1].Value = "";
parameters[2].Value = "";
parameters[3].Direction = ParameterDirection.Output; // 设置为输出参数

[_程序员]

cmd.Parameters["@EmployeeID"].Value返回值为空

[huangwenquan123]

你代码怎么写的？

[_程序员]

cmd.Parameters["@EmployeeID"].Direction = ParameterDirection.Output;
cmd.Parameters[3].Direction = ParameterDirection.Output;
都不行而且我在数据库里面直接调用存储过程...也是没有返回值

[_程序员]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER procedure [dbo].[insertemployee]
@TitleOfCourtesy varchar(25),
@LastName varchar(20),
@FistName varchar(10),
@EmployeeID int OUTPUT
AS
INsert INto Employees
(TitleOfCOurtesy,LastName,FistName,HireDate)values(@TitleOfCourtesy,@LastName,@FistName,GETUTCDATE());
set @EmployeeID = @@IDEntity







SqlConnection con = new SqlConnection("Server=Shepherd-pc; Integrated Security =true; Database=test");
SqlCommand cmd = new SqlCommand("InsertEmployee",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TitleOfCourtesy", SqlDbType.NVarChar, 25));
cmd.Parameters["@TitleOfCourtesy"].Value = "不知道是什么";
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.NVarChar, 20));
cmd.Parameters["@LastName"].Value = "九阳";
cmd.Parameters.Add(new SqlParameter("@FistName", SqlDbType.NVarChar, 10));
cmd.Parameters["@FistName"].Value = "王";
cmd.Parameters.Add(new SqlParameter("@EmployeeID", SqlDbType.Int, 4));
cmd.Parameters["@EmployeeID"].Direction = ParameterDirection.Output;
con.Open();
Console.WriteLine("{0}\n{1}", cmd.ExecuteNonQuery(), cmd.Parameters["@EmployeeID"].Value);
con.Close();

[_程序员]

应该是存储过程那里出了问题

[我在深圳搬砖-Justin]

ALTER procedure [dbo].[insertemployee]
@TitleOfCourtesy varchar(25),
@LastName varchar(20),
@FistName varchar(10),
@EmployeeID int OUTPUT
AS  
INsert INto Employees
(TitleOfCOurtesy,LastName,FistName,HireDate)values(@TitleOfCourtesy,@LastName,@FistName,GETUTCDATE());
SELECT @EmployeeID = @@IDEntity

SELECT

[我在深圳搬砖-Justin]

declare @aa int
Insert Into testA(NameA) values('123') SELECT @aa=@@IDENTITY; 
print '值为'+Cast(@aa As nvarchar(50))

输出结果

(1 行受影响)
值为7

[_程序员]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER procedure [dbo].[insertemployee]
@TitleOfCourtesy varchar(25),
@LastName varchar(20),
@FistName varchar(10),
@EmployeeID int OUTPUT
AS
INsert INto Employees
(TitleOfCOurtesy,LastName,FistName,HireDate)values(@TitleOfCourtesy,@LastName,@FistName,GETUTCDATE());
select @EmployeeID = @@IDEntity

还是没有哦..

[cf370697816]

[Quote=引用 8 楼 qq77452919 的回复:]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER procedure [dbo].[insertemployee]
@TitleOfCourtesy varchar(25),
@LastName varchar(20),
@FistName varchar(10),
@EmployeeID int OUTPUT
AS
I……
[/Quote]
你这代码好乱，没用三层做嘛？

[alan_219_2008]

表设置了自增种子没？
看了好久 貌似没错。。

[_程序员]

一个测试而已,用什么三层

[我在深圳搬砖-Justin]

要设置自增的

[wuyq11]

是否设置自增列

[huangwenquan123]

--写了个测试没问题--
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[InsertUsers]
(
	@UserName varchar(255),@Password varchar(255),@UserID int output
)
as
insert into Users(UserName,Password)values(@UserName,@Password)
set @UserID=@@Identity

    protected void Button1_Click(object sender, EventArgs e)
    {
        using (SqlConnection conn = new SqlConnection())
        {
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString;
            conn.Open();
            SqlCommand cmd = new SqlCommand("[InsertUsers]", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@UserName", TextBox1.Text));
            cmd.Parameters.Add(new SqlParameter("@Password", TextBox2.Text));
            cmd.Parameters.Add(new SqlParameter("@UserID", 0)).Direction = ParameterDirection.Output;
            int result = cmd.ExecuteNonQuery();
            Response.Write(result + " UserID：" + cmd.Parameters["@UserID"].Value);
        }
    }

[_程序员]

OK了谢谢各位

[_程序员]

要一个自增ID才可以...