Database

public static bool Delete(int supplierID)
{
    int result = 0;
    using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
    {
        SqlCommand myCommand = new SqlCommand("sprocProcSupplierDelete", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add(Parameters.SupplierID);
        myCommand.Parameters[ParameterNames.SupplierID].Value = supplierID;
        try
        {
            myConnection.Open();
            result = myCommand.ExecuteNonQuery();
            myConnection.Close();
        }
        catch (SQLException e)
        {
            // handle exception
            ...
            // log exception
            ...
            throw;
        }
    }
    return result > 0;
}

<br />
<br />
INSERT INTO tClients(sClientName, sClientAddress, sClientContact, iClientOrder)<br />
VALUES ('Joe Simpson', '3 Green Ave' , 'Mr. R Simpson' , 3)<br />
<br />