✅ Stored Procedure Help

        public static Vendor GetVendor(int vendorID)
        {
            Vendor vendor = new Vendor();
            SqlConnection connection = PayablesDB.GetConnection();
            //string selectStatement =
             //   "SELECT VendorID, Name, Address1, Address2, City, State, " +
             //       "ZipCode, Phone, ContactFName, ContactLName, " +
             //       "DefaultAccountNo, DefaultTermsID " +
             //   "FROM Vendors " +
             //   "WHERE VendorID = @VendorID";
            SqlCommand selectCommand = new SqlCommand("spGetVendor", connection);
            selectCommand.Parameters.AddWithValue("@VendorID", vendorID);