Re: MySQL/ASP.NET(C#) mysql_insert_id?

[Hauke Betz]

Hello,
After executing your Insert-Command (C#, Connection is stored in conDBConnection):

...
string strSQLSelect = "SELECT @@IDENTITY AS 'LastID'";
MySqlCommand dbcSelect = new MySqlCommand(strSQLSelect, conDBConnection);
MySqlDataReader dbrSelect = dbcSelect.ExecuteReader();

dbrSelect.Read();
int intCounter = Int32.Parse(dbrSelect.GetValue(0).ToString());

dbrSelect.Dispose();
conDBConnection.Close();

MessageBox.Show("Test: " + intCounter.ToString());

Greets,

Hauke




"SELECT @@IDENTITY AS 'LastID'"