Last generated value

Hi All,

I have typical problem

What I Want is:

I am inserting values in table A. Table A has IDENTITY column

After inserting values in table A, Taking the last generated IDENTITY value i have to insert another 3 table that table A IDENTITY value.

How can i do this in VB.NET.

I am using SQL SERVER database.

I tried with Select SCOPE_IDENTITY, but it's not working

Please help me.

Thanks in advance,

Regards

Nagendra K.