how to insert update master and transactions like this.

Posted by Jayakumars under Regular Expressions on 6/23/2011 | Points: 10 | Views : 1759 | Status : [Member] [MVP] | Replies : 3
Hi

I have transaction Insert screen clarification

1 have 2 table header,details tables
now i am pass the value header table with textboxes values
Details table i am passing dataset values inserted fine
another process i am view the corresponding records both table records
it is working fine after i am modify in my dataset particular values
now i m how to which value i m change that value only updated my Detailstable
and how pass that values which value effected the dataset that value only
i need update in my Detailstable i need most urgent because i have detailstable
100 records have so i am try to delete after insert newly but this is
performance bad so any one solve this.

Mark as Answer if its helpful to you


Responses

Posted by: Rajesh_a_kumar on: 7/5/2011 [Member] Starter | Points: 25

Up
0
Down
JayaKumar,

If you are trying to find the changed records from a Dataset, then you can call the method "GetChanges()" on the "DetailsTable" dataset. This method returns a new dataset that contains only the changed values.

If this answer doesn't resolve your question, please give us an example to help you quickly.

Thanks,
Rajesh

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 7/5/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi
Rajesh
can you post sample code for this i need most urgent and send me attachment file here.


Mark as Answer if its helpful to you

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh_a_kumar on: 7/5/2011 [Member] Starter | Points: 25

Up
0
Down
Can you look at: http://blogs.msdn.com/b/spike/archive/2009/10/20/datatable-getchanges-datarowstate-modified-returns-null.aspx

Thanks,
Rajesh

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response