Help needed for new vb.net user

[Mark]

Hi all

Can someone please post some sample code to get me going. I have a simple table which I would like to add a new record to and have the Identity of the new row passed back to me. The table is called “ContactGroups� and it has 2 fields intID and GroupName. (Database on SQL Server 2000

I have managed to do the insert, but It is not giving me the Identity back. The code I have used is as follows, but I am sure there is a better way to do this. I have only been using VB.Net for a month and am struggling to get my head around it

Dim ReturnedID as Intege
Dim newConn as New Data.SqlClient.SqlComman

Dim cmd as New Data.SqlClient.SqlComman
Dim prmIn as New Data.sqlClient.SqlParamete
Dim prmOut as New Data.sqlClient.SqlParamete

newConn.ConnectionString = strCon

prmIn.dbType = dbType.Strin
prmIn.Direction = ParameterDirection.Inpu
prmIn.Value = “Testâ€

prmOut.dbType = dbType.Int1
prmOut.Direction = ParameterDirection.Outpu

newConn.Open(

With cm
.CommandText = “InsGroupâ€
.CommandType = CommandType.StoredProcedur
.Parameters.Add(prmIn
.Paramiters.Add(prmOut
.Connection = newCon

.ExecuteNonQuery(
End Wit

ReturnedID = cmd.Parameters(“prnOut�).Valu

Stored Procedure Cod

Create Procedure [dbo].[InsGroup

@Data VARCHAR(30)
@intID INT OUTPU

A

INSERT INTO ContactGroups (ContactGroup) VALUES (@Data

SET @intID = SCOPE_IDENTITY(
G

When I run the code I get an error stating that Parameter 1 is not a parameter for procedure InsGrou

Am I on the right track with this, or should I be doing this in a totally different way? Can the same be done without using Stored Procedures?

Any help would be great, especially if someone would be kind enough to post a code sample of a better way of doing this

Thank You

Mar