If we use sqdataadapter to insert data from a datatable into a table in the database using an SPROC. The Sproc also returns the identity column values that are created by the database.
If those identity columns are called “IDcolumn” in the physical DB but in my dataset I call them “MyIdentity”.
So IDcolumn is an output of my SProc
I use :
Pm.Direction=ParameterDirection.Output
Then I use pm.SourceColumn property :
Should I use « IDcolumn” or “MyIdentity”
Like this:
Pm.sourcecolumn=”IDcolumn” or like this:
Pm.sourcecolumn=” MyIdentity”
Thank you
Thanks a lot, I appreciate your taking the time to help me.