只需编写一个更新数据例程。下面是一个C#应用程序的代码，它检查数据是否有效，然后当您单击更新按钮时，魔术数据将被更新

private void btnUpdate_Click(object sender, System.EventArgs e)
    {
        if (!validateInput())
        {
            return;
        }
        if (!validateEmail())
        {
            return;
        }
        using (SQLiteConnection conn = new SQLiteConnection($"Data Source = '{dbName}';Version=3;"))
        {
            conn.Open();
            string sql = "UPDATE FriendsData SET fxFirstName = @fxFirstName, fxLastName = @fxLastName,fxAddress = @fxAddress,fxCity = @fxCity, fxState = @fxState,fxZip = @fxZip,fxCellPhone = @fxCellPhone,fxEmail = @fxEmail,fxInfo = @fxInfo WHERE FID =" + userData.udID;
            using (var cmd = new SQLiteCommand(sql, conn))
            {
                try
                {
                    cmd.Parameters.AddWithValue("@fxFirstName",tbFirstName.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxLastName",tbLastName.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxAddress",tbAddress.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxCity",tbCity.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxState",tbState.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxZip",tbZip.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxCellPhone",mtbCellPhone.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxEmail",tbEmail.Text.Trim());
                    cmd.Parameters.AddWithValue("@fxInfo",rtbInfo.Rtf.Trim());

                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    result = ex.ToString();
                    tbMessage.Text = result;
                }
            }
        }
        tbMessage.Text = "Information Updated";
        btnUpdate.Enabled = false;
        btnClose.Focus();
    }