Hi All,

I'm trying to insert a new record into my SQL Server dataabse. The first column is an automatically-generated identity field. I want to retrieve the ID number of the new row when I add the record using,

string NewID = command.ExecuteScalar().ToString();

For some reason, the ExecuteScalar() method throws a NullReferenceException, so I'm guessing it's not returning everything, and I'm not sure why. Can anyone help?

Cheers,

Mat

retreive the id after insertion because there is no Id until the record is inserted as its autogenerated.

So this would do the right thing?

1    command.ExecuteScalar();  //Execute the insert statement
2    command.CommandText = "SELECT MAX(ID) FROM tblMyTable;";
3    string NewID = command.ExecuteScalar().ToString();  //Get the new ID

Cheers,

Mat