Display identity number on textbox or label

Hi,

You can Use Scope_Identity() function to retrieve identity column value .

 //SQL Connections
                String ConnectionString = ConfigurationSettings.AppSettings["DataSourceName"];
                SqlConnection conn = new SqlConnection(ConnectionString);
                String CommandString = "Insert Into CourseTable(CourseName, ShortName) Values (@CourseName,  @ShortName);Select CourseID from CourseTable Where CourseID = SCOPE_IDENTITY()";
                SqlCommand commandS = new SqlCommand(CommandString);
                try
                {
                    commandS.Parameters.Add("@CourseName", this.txtCourse.Text.Trim ());
                    commandS.Parameters.Add("@ShortName", this.txtShortName.Text.Trim());
                conn.Open();
                commandS .Connection = con;
                SqlDataReader reader =  commandS .ExecuteReader();
 while(reader.Read())
 {
        // You can Get you auto generated number as 
        string getID = reader[0].ToString();
 }
                }
                catch (Exception e)
                {
                   
                }
                finally
                {
                    commandS.Parameters.Clear();
                    commandS.Dispose();
                    commandS =null;
                    conn.Close();
                }

If this post helps you, then mark as "Correct Answer". Thank You

Do something like bellow.
 Create Stored Procedure Sp_Name
(
@Val1 DataType,
@val2 DataType,
@no DataType out
)
AS
Begin
Insert Into Table Values(@val1,@val2)
Set @no='Identity Is :'+CONVERT(Varchar(20),@@IDENTITY
End
This will display the identity after insert. If you want to display the identity value before insert then try
Select Max(IdentityCloumn+1)From TableName
And display this value in you lable or textbox.

Hi Arvind,
When you save the data into the dastabase that time you can retrieve that data(i.e auto-generated number) in the textbox or label as per your convinient.