Get created ID and enter it to different table with other information

Solution: Its finally working. Thank you all so much especially @BonnieB

   SqlCommand MyCommand = new SqlCommand                    ("INSERT INTO Vis (fName, sName, vCompany, vEmail, regNo, carMake, carColour) VALUES (@fName, @sName, @vCompany, @vEmail, @regNo, @carMake, @carColour); SET @visID = SCOPE_IDENTITY()", myConnection);                MyCommand.Parameters.AddWithValue("@fName", Vis1.Text);                MyCommand.Parameters.AddWithValue("@sName", TextBox1.Text);                MyCommand.Parameters.AddWithValue("@vCompany", TextBox2.Text);                MyCommand.Parameters.AddWithValue("@vEmail", emailTB.Text);                MyCommand.Parameters.AddWithValue("@regNo", mailTB.Text);                MyCommand.Parameters.AddWithValue("@carMake", lsMake.SelectedItem.Value);                MyCommand.Parameters.AddWithValue("@carColour", lsColour.SelectedItem.Value);                MyCommand.Parameters.AddWithValue("@visId", 0);                MyCommand.Parameters["@visId"].Direction = ParameterDirection.InputOutput;                  myConnection.Open();                status = MyCommand.ExecuteNonQuery();               int visId = (int)MyCommand.Parameters["@visId"].Value;                               // Create INSERT statement to insert to History                SqlCommand MyCommand1 = new SqlCommand                ("INSERT INTO History(Campus, ParkName, BayNo, Disabled, bkDate, VisId) VALUES (@Campus, @ParkName, @BayNo, @Disabled, @bkDate, @VisId)", myConnection);                MyCommand1.Parameters.AddWithValue("@Campus", mytexthid1.Text);                MyCommand1.Parameters.AddWithValue("@Disabled", rbDisabled.SelectedItem.Value);                MyCommand1.Parameters.AddWithValue("@bkDate", DateBox.Text);                MyCommand1.Parameters.AddWithValue("@BayNo", mytexthid.Text);                MyCommand1.Parameters.AddWithValue("@ParkName", mytexthid2.Text);                MyCommand1.Parameters.AddWithValue("@VisId", visId);                                              status = MyCommand1.ExecuteNonQuery();                                return status;            }        }

---

a desperate learner