SCOPE IDENTITY in c#
It is very easy to get the SCOPE_IDENTITY() value back from SQL Server. I will give an example where I was able to print the SCOPE_IDENTITY() data back in c# label.
My Code Snippet in a Submit from data insert
btnSubmit_Click() {
Random s = new Random();
cmd = new SqlCommand("INSERT INTO [dbo].[tblMemberAccount] ([Userid], [User_pwd], [User_mobile], [User_referal], [UserWallet]) VALUES(@Userid, @User_pwd, @User_mobile, @User_referal, @UserWallet) select scope_identity()", cons);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Userid",s.Next(4506,9999));
cmd.Parameters.AddWithValue("@User_pwd",txtPassword.Text);
cmd.Parameters.AddWithValue("@User_mobile",txtPhoneNumber.Text);
cmd.Parameters.AddWithValue("@User_referal",txtReferral.Text);
cmd.Parameters.AddWithValue("@UserWallet",10);
cons.Open();
int g = Convert.ToInt32(cmd.ExecuteScalar());
cons.Close();
lblConfirm.Text = "Member " +g+ " added successfully!";
}
Here the value 'g' is returning the scope_identity value.
#scope_identity #lastrowinserted #serialnumberofcurrentrow