C#

<br />
UPDATE [Table1] SET [name] = @name, [address] = @address, [phone] = @phone WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ((@IsNull_phone = 1 AND [phone] IS NULL) OR ([phone] = @Original_phone)));<br />
SELECT id, name, address, phone FROM Table1 WHERE (id = @id)

UPDATE       [Table1]<br />
SET          name = @name, address= @address, phone = @phone<br />
WHERE        (Id = @Original_Id); <br />
SELECT Id, name,address,phone FROM [User] WHERE (Id = @Id)

void Find_FormClosing(object sender, FormClosingEventArgs e)
{
   e.Cancel = true;
   this.Visible = false;
}

public static string GetMAC()
        {
            string returnString = string.Empty;
            ManagementObjectSearcher query = null;
            ManagementObjectCollection queryCollection = null;
            try
            {
                query = new ManagementObjectSearcher("SELECT * FROM Win32_NetworkAdapterConfiguration");
                queryCollection = query.Get();
                int count = 0;
                foreach (ManagementObject mo in queryCollection)
                {
                    if (!(mo["MacAddress"] == null))
                    {
                        count++;
                        if (count == 3)
                        {
                            returnString = mo["MacAddress"].ToString();
                            mo.Dispose();
                            break;
                        }
                    }
                    mo.Dispose();
                }
                queryCollection.Dispose();
                query.Dispose();
            }
            catch
            {
            }
            return returnString;
        }

DaveyM69 wrote:

if anyone has any suggestions on improving it?

class CryptoStreamEncryption
    {
        private static byte[] Key = ASCIIEncoding.ASCII.GetBytes(Constants.Misc.MyKey);
        private static byte[] IV = ASCIIEncoding.ASCII.GetBytes(Constants.Misc.MyKey);

        public static void Encrypt(XmlDocument ThisDocument, string FullPath)
        {
            try
            {
                FileStream fStream = File.Open(FullPath, FileMode.Create);
                Rijndael RijndaelAlg = Rijndael.Create();
                CryptoStream cStream = new CryptoStream(fStream, RijndaelAlg.CreateEncryptor(Key, IV), CryptoStreamMode.Write);
                StreamWriter sWriter = new StreamWriter(cStream);
                try
                {
                    sWriter.WriteLine(ThisDocument.OuterXml);
                }
                catch (Exception e)
                {
                    Console.WriteLine("An error occurred: {0}", e.Message);
                }
                finally
                {
                    sWriter.Close();
                    cStream.Close();
                    fStream.Close();
                }
            }
            catch (CryptographicException e)
            {
                Console.WriteLine("A Cryptographic error occurred: {0}", e.Message);
            }
            catch (UnauthorizedAccessException e)
            {
                Console.WriteLine("A file error occurred: {0}", e.Message);
            }

        }

        public static XmlDocument Decrypt(string FullPath)
        {
            XmlDocument ThisDocument = new XmlDocument();
            string val = null;
            try
            {
                FileStream fStream = File.Open(FullPath, FileMode.Open);
                Rijndael RijndaelAlg = Rijndael.Create();
                CryptoStream cStream = new CryptoStream(fStream, RijndaelAlg.CreateDecryptor(Key, IV), CryptoStreamMode.Read);
                StreamReader sReader = new StreamReader(cStream);
                try
                {
                    val = sReader.ReadLine();
                }
                catch (Exception e)
                {
                    Console.WriteLine("An error occurred: {0}", e.Message);
                }
                finally
                {
                    sReader.Close();
                    cStream.Close();
                    fStream.Close();
                }
            }
            catch (CryptographicException e)
            {
                Console.WriteLine("A Cryptographic error occurred: {0}", e.Message);
            }
            catch (UnauthorizedAccessException e)
            {
                Console.WriteLine("A file error occurred: {0}", e.Message);
            }
            catch (System.IO.FileLoadException e)
            {
                Console.WriteLine("A file load error occurred: {0}", e.Message);
            }
            catch (System.IO.FileNotFoundException e)
            {
                Console.WriteLine("A file not found error occurred: {0}", e.Message);
            }
            if (!(val == null))
            {
                ThisDocument.LoadXml(val);
            }
            return ThisDocument;
        }
    }