Please refer following sample:
HTML
<div>
    Name :
    <asp:TextBox runat="server" ID="txtItemName" />
    <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="Submit" />
    <br />
    ID:
    <asp:Label ID="lblID" runat="server"></asp:Label>
</div>
Namespace
using System.Linq;
using LINQ;
C#
protected void Submit(object sender, EventArgs e)
{
    using (DataClassesDataContext dc = new DataClassesDataContext())
    {            
        lblID.Text = dc.InsertItems(this.txtItemName.Text.Trim()).SingleOrDefault().Column1.ToString();            
    }
}
SQL
CREATE TABLE [dbo].[Items](
	[ItemId] [int] IDENTITY(1,1) NOT NULL,
	[ItemName] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Items] PRIMARY KEY CLUSTERED 
(
	[ItemId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
---------------------------------------------------------------
-- InsertItems 'Item1'
CREATE PROCEDURE [InsertItems]
	@ItemName VARCHAR(50)
AS
BEGIN	
	SET NOCOUNT ON;
	INSERT INTO [Items] ([ItemName]) VALUES (@ItemName)
	SELECT SCOPE_IDENTITY()
END
GO
----------------------------------------------------------------
Screenshot
Output

Solution Structure

Table and Stored Procedure
