public bool Insert(LSPDClass c)
        {
            //creating defualt return type and setting is vale to false
            bool isSuccess = false;
            //connect database
            SqlConnection conn = new SqlConnection(myconnstrng);
            try
            {
                // create a sql query to insert data
                string sql = "INSERT INTO Table_LookUp (FirstName, LastName, LicensePlateNumber, CriminalRecord, Licences, DateOfBirth, Aliases, Affiliations, ThreatLevel, AddInfo, VALUES (@FirstName, @LastName, @LicensePlateNumber, @CriminalRecord, @Licences, @DateOfBirth, @Aliases, @Affiliations, @ThreatLevel, @AddInfo)";
                //creating sql command using sql conn
                SqlCommand cmd = new SqlCommand(sql, conn);
                //create parameters to add data
                cmd.Parameters.AddWithValue("@FirstName", c.FirstName);
                cmd.Parameters.AddWithValue("@LastName", c.LastName);
                cmd.Parameters.AddWithValue("@LicensePlateNumber", c.LicensePlateNumber);
                cmd.Parameters.AddWithValue("@CriminalRecord", c.CriminalRecord);
                cmd.Parameters.AddWithValue("@Licences", c.Licences);
                cmd.Parameters.AddWithValue("@DateOfBirth", c.DateOfBirth);
                cmd.Parameters.AddWithValue("@Aliases", c.Aliases);
                cmd.Parameters.AddWithValue("@Affiliations", c.Affiliations);
                cmd.Parameters.AddWithValue("@ThreatLevel", c.ThreatLevel);
                cmd.Parameters.AddWithValue("@AddInfo", c.AddInfo);
                //open connection
                conn.Open();
                int rows = cmd.ExecuteNonQuery();
                // if query is successful then the value of rowns will be <0 else it will be 0
                if (rows > 0)
                {
                    isSuccess = true;

                }
                else
                {
                    isSuccess = false;
                }

            }
            catch (Exception ex)
            {

            }
            finally
            {
                conn.Close();
            }
            return isSuccess;
        }


//-------------------------------------------------------------------------------------

  private void Submitbtn_Click(object sender, EventArgs e)
        {
            //get the value from input fields
            c.FirstName = FirstNameID.Text;
            c.LastName = LastNameID.Text;
            c.LicensePlateNumber = LicensePlateNumberID.Text;
            c.DateOfBirth = DateOfBirthID.Text;
            c.Aliases = AliasesID.Text;
            c.Affiliations = AffiliationsID.Text;
            c.ThreatLevel = ThreatLevelID.Text;
            c.AddInfo = AddInfoID.Text;
            c.CriminalRecord = CriminalRecordID.Text;

            //insert data into database
            bool success = c.Insert(c);
            if (success == true)
            {
                //successful insert
                MessageBox.Show("new entry completed");
            }
            else
            {
                //faield insert
                MessageBox.Show("Entry Failed");
            }



        }