Return Current Identity from Stored Procedure using C# and VB.Net in ASP.Net

Hi dorsa,

Check this example. Now please take its reference and correct your code.

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

SQL

CREATE PROCEDURE Get_LastProfId
AS
	SELECT IDENT_CURRENT ('Customers') AS Current_Identity
GO

HTML 

<asp:Label ID="lblId" runat="server" />

Namespaces

C#

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

VB.Net

Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    String strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    SqlConnection con = new SqlConnection(strConnString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.CommandText = "Get_LastProfId";
    cmd.Connection = con;
    try
    {
        con.Open();
        object obj = cmd.ExecuteScalar();
        lblId.Text = "ID = " + obj.ToString();
    }
    catch (Exception ex)
    {
        throw ex;
    }
    finally
    {
        con.Close();
        con.Dispose();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim strConnString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim con As SqlConnection = New SqlConnection(strConnString)
    Dim cmd As SqlCommand = New SqlCommand()
    cmd.CommandType = CommandType.StoredProcedure
    cmd.CommandText = "Get_LastProfId"
    cmd.Connection = con
    Try
        con.Open()
        Dim obj As Object = cmd.ExecuteScalar()
        lblId.Text = "ID = " & obj.ToString()
    Catch ex As Exception
        Throw ex
    Finally
        con.Close()
        con.Dispose()
    End Try
End Sub

Output

ID = 4