public string GetNextNumber() { string query = "dbo.GetNextNumber"; string connString = this.GetConnectionString("PantryWare"); string newNumber = string.Empty; using (SqlConnection conn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NextNumber", "0000000000"); cmd.Parameters["@NextNumber"].Direction = ParameterDirection.Output; conn.Open(); cmd.ExecuteNonQuery(); newNumber = (string)cmd.Parameters["@NextNumber"].Value; } } return newNumber; }Stored Procedure
USE [PantryWare] GO /****** Object: StoredProcedure [dbo].[GetNextNumber] Script Date: 06/27/2010 08:15:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[GetNextNumber] -- Add the parameters for the stored procedure here @NextNumber varchar(10) Output AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Set @NextNumber = '0000001045' ENDI would like to figure it out although it wasn't my problem to start with. I got interested in this because I am trying to up my level of knowledge with SQL and using it.