c# 通过存储过程来自动创建主码

通过存储过程来创建主码:

1.首先先来创建存储过程

          在一个shopping表中,有三列,分别是ID,sname,price,其中ID为

主码.

CREATE PROCEDURE AutoADD(@ID int output,@sname varchar(50),@price float) AS
SELECT @ID=MAX(ID)+1 FROM shopping;
INSERT INTO shopping VALUES
(@ID,@sname,@price)
GO
2.C#调用存储过程:

SqlCommand cmd = new SqlCommand("AutoADD", Conn);
cmd.CommandType = CommandType.StoredProcedure;
 cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4,ParameterDirection.Output, false,0,0,"ID",DataRowVersion.Default,null));

cmd.Parameters.Add(new SqlParameter("@sname", SqlDbType.VarChar, 50, "sname"));
            cmd.Parameters.Add(new SqlParameter("@price", SqlDbType.Float, 0, "price"));
            cmd.UpdatedRowSource = UpdateRowSource.OutputParameters;
          
            cmd.Parameters[1].Value = this.textBox1.Text.Trim();
            cmd.Parameters[2].Value = Convert.ToDouble(this.textBox2.Text.Trim());
            cmd.UpdatedRowSource = UpdateRowSource.None;

cmd.ExecuteNonQuery();