>>>>>Now, having done that, is there an easy way to get the new ID that was generated for this new record?
>>>>
>>>>You can do SELECT MAX(iID)....but it is not a good idea in a multi-user environment. The best thing is to pre-fetch the iId.
>>>>
>>>
>>>Any idea on how to do that (pre-fetch the key)? In this particular case, I've got a candidate key I could use to requery the table w/and grab it, but I know in most cases I won't.
>>
>>You can use SqlCommand.ExecuteScalar() funtion which is optimized to return single value from the database. You should be able to call NewId() SP straight through SqlCommand.
>>
>>Let me know if you need code examples...
>
>Yeah, code examples (for calling NewID() directly) would be appreciated. I was able to call NewID():
>
>

>oleCmd.CommandText = "NewID('user')";
>oleCmd.ExecuteNonQuery();
>

>
>However, I wasn't able to get the return value. I tried using the parameter object:
>
>

>oleCmd.CommandText = "NewID('user')";
>
>oleParameters = oleCmd.Parameters.Add("user_iid", System.Data.OleDb.OleDbType.Integer);
>oleParameters.Direction = System.Data.ParameterDirection.ReturnValue;
>oleParameters.Value = 0;
>
>oleCmd.ExecuteNonQuery();
>
>string newUserIID = oleCmd.Parameters["user_iid"].Value.ToString() ;	
>				
>

>
>But, all I keep getting back is "0".

You will need to set CommandType for the command object.

For example,

oleCmd.CommandType = CommandType.StoredProcedure