problem retrieving info from one table to insert it into another
-
using (OleDbCommand cmd1 = sql_con.CreateCommand())
{cmd1.CommandText = "INSERT INTO Commandes (montant\_com) VALUES (@montant\_com)"; OleDbCommand cmr = sql\_con.CreateCommand(); cmr.CommandText = "SELECT @@IDENTITY AS LastId"; cmd1.Parameters.AddWithValue("@montant\_com", TxtTotalCmd.Text); id = (int)cmr.ExecuteScalar(); TxtNunCmd.Text = id.ToString(); cmd1.ExecuteNonQuery(); }but i can't get the id
Stop guessing, and start thinking. When is the ID actually created? What line of code causes that to happen?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!
-
Stop guessing, and start thinking. When is the ID actually created? What line of code causes that to happen?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!
Hello sir and all my excuses for yesterday I had a connection problem that's why I disconnected but by dint of fighting all night I could find the solution regaré and tell me if the code is clean. I must say I am glad I did ...
:-D :-D :-D :-D
using (OleDbCommand cmd1 = sql_con.CreateCommand())
{cmd1.CommandText = "INSERT INTO Commandes (montant\_com) VALUES (@montant\_com)"; cmd1.Parameters.AddWithValue("@montant\_com", TxtTotalCmd.Text); cmd1.ExecuteNonQuery(); OleDbCommand cmr = sql\_con.CreateCommand(); cmr.CommandText = "SELECT @@IDENTITY AS LastId"; int LastId = Convert.ToInt32(cmr.ExecuteScalar()); TxtNunCmd.Text = LastId.ToString(); //sql\_cmd = new OleDbCommand(CommandText, sql\_con); } -
Hello sir and all my excuses for yesterday I had a connection problem that's why I disconnected but by dint of fighting all night I could find the solution regaré and tell me if the code is clean. I must say I am glad I did ...
:-D :-D :-D :-D
using (OleDbCommand cmd1 = sql_con.CreateCommand())
{cmd1.CommandText = "INSERT INTO Commandes (montant\_com) VALUES (@montant\_com)"; cmd1.Parameters.AddWithValue("@montant\_com", TxtTotalCmd.Text); cmd1.ExecuteNonQuery(); OleDbCommand cmr = sql\_con.CreateCommand(); cmr.CommandText = "SELECT @@IDENTITY AS LastId"; int LastId = Convert.ToInt32(cmr.ExecuteScalar()); TxtNunCmd.Text = LastId.ToString(); //sql\_cmd = new OleDbCommand(CommandText, sql\_con); }Yes, that's fine - you don't need the "AS LastID" because ExecuteScalar doesn't return labels, but it doesn't matter if you add it.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!
