Get Identity Column Value in C# 'Dataset'--Access DataBase

Question

Hi

I want to retrieve identity column value after running Insert or Update (using Access DB in C#). How can I do it?

i use a Typed dataset to fill and update...

Answer 1

For retrieving the identity of inserted rows see this link:

http://msdn.microsoft.com/en-us/library/ks9f57t0%28VS.80%29.aspx

This link describes how to find the value of an inserted row in SQL, you then need to return that row in a SELECT statement (as Access does not support return parameters)

You may also be interested in this question, which compares the different methods of returning the identity.

http://stackoverflow.com/questions/42648/best-way-to-get-identity-of-inserted-row

Answer 2

Ms-Access C# connectivity for insertion deletion updation for identity column

Tutorial

Answer 3

(sorry I cannot post a comment)
It sounds to me like he is using an ADO.net DataSet, and wants to retrieve an the value of an auto-increment column after inserting a value.
I don't know where you are all getting partial classes from, he's saying he can't figure out how to do it in C#, not that he doesn't want it in C#.

Answer 4

Hi My Freind

In Find answer of My Question

the Flowing Links Helped me to write a partial Class to Validate Rows in Dataset And Write a Code to Recive a AutoIncrement Column Value:

http://msdn.microsoft.com/en-us/library/ms171896(VS.80).aspx

http://msdn.microsoft.com/en-us/library/0f7ey06d(VS.80).aspx

http://msdn.microsoft.com/en-us/library/1120xds5(VS.80).aspx

thank you