Hi to all,

I am using Updategram.I have a problem to get the IDENTITY.
I have follwed the following link.
http://msdn.microsoft.com/library/de...68ff245df1.asp
its working fine only single parent and its related child records.


I explain my problem with an example as below:

I have two tables in sql, one is master another one is detail. these are
related to one another. let us assume, one is studentname table another one
is studnetmark detail. I have added the data into these table with
sqladapter.First i have inserted into studentname in one table and take the
IDENTITY, after that insert into student Mark table with StudentName
Identity. I have inserted the StudentName s and respective Marks in
StudentMark details. But i can't get the Correct IDENTITY. But Last IDENTITY
has been repeated for all the StudentMark's rows which ever i inserted.

This is My Inbound Message:

<ns0:Student xmlns:ns0="http://InsertMarklist.Input">
  <Details Name="jana" City="VLR">
    <Mark EName="EName_0" M1="50" M2="50" M3="50" />
    <Mark EName="EName_1" M1="50" M2="50" M3="50" />
  </Details>
  <Details Name="sample" City="City_1">
    <Mark EName="EName_4" M1="50" M2="50" M3="50" />
    <Mark EName="EName_5" M1="50" M2="50" M3="50" />
  </Details>

</ns0:Student>



BUT I GOT AS FOLLOWS

STUDENTNAME Table
-------------------------

ID NAME CITY
-------------------------------
22 jana VLR
23 sample City_1

STUDENTMARK Table (Here i m having problem in ID)
-------------------------

ID EXAM M1 M2 M3 TOT
----------------------------------------------------------------------
23 EName_0 50 50 50 150
23 EName_1 50 50 50 150
23 EName_4 50 50 50 150
23 EName_5 50 50 50 150

NOTE: SEE the ID column is in same value.

I expected in SQL

STUDENTNAME Table
-------------------------

ID NAME CITY
-------------------------------
22 jana VLR
23 sample City_1

STUDENTMARK Table
-------------------------

ID EXAM M1 M2 M3 TOT
----------------------------------------------------------------------
22 EName_0 50 50 50 150
22 EName_1 50 50 50 150
23 EName_4 50 50 50 150
23 EName_5 50 50 50 150

Thanks In Advance
Jana


Jana