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
