C#

Abhinav S wrote:

You have posted a similar question in the .Net framework forums as well.

INSERT INTO TABLE (FIELD1, FIELD2) VALUES ('value1','value2')

INSERT INTO TABLE (FIELD1, FIELD2) VALUES ('value1',123)

'MS Access
'Execute = INSERT, UPDATE, DELETE
Public Function ExecuteDbData(ByVal oConn As System.Data.OleDb.OleDbConnection, ByVal sSQL As String) As Long
    Dim oComm As System.Data.OleDb.OleDbCommand, oTrans As System.Data.OleDb.OleDbTransaction = Nothing
    Dim iRetVal As Integer

    Try
        oConn.Open()
        oTrans = oConn.BeginTransaction()
        oComm = New System.Data.OleDb.OleDbCommand(sSQL, oConn, oTrans)
        iRetVal = oComm.ExecuteNonQuery()
        oTrans.Commit()

    Catch ex As System.Data.OleDb.OleDbException
        MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")
        Try
            oTrans.Rollback()
            oTrans.Dispose()
        Catch
            'do nothing
        End Try

    Catch ex As Exception
        MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")

    Finally
        oConn.Close()
        oTrans = Nothing
        oComm = Nothing
    End Try

    Return iRetVal

End Function

'MS SQL
'Execute = INSERT, UPDATE, DELETE
Public Function ExecuteDbData(ByVal oConn As System.Data.SqlClient.SqlConnection, ByVal sSQL As String) As Long
    Dim oComm As System.Data.SqlClient.SqlCommand, oTrans As System.Data.SqlClient.SqlTransaction = Nothing
    Dim iRetVal As Integer

    Try
        oConn.Open()
        oTrans = oConn.BeginTransaction(System.Data.IsolationLevel.Serializable)
        oComm = New System.Data.SqlClient.SqlCommand(sSQL, oConn, oTrans)
        iRetVal = oComm.ExecuteNonQuery()
        oTrans.Commit()

    Catch ex As System.Data.SqlClient.SqlException
        MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")
        Try
            oTrans.Rollback()
            oTrans.Dispose()
        Catch
            'do nothing
        End Try

    Catch ex As Exception
        MsgBox(ex.Message, MsgBoxStyle.Exclamation, "Error")

    Finally
        oConn.Close()
        oTrans = Nothing
        oComm = Nothing
    End Try

    Return iRetVal

End Function

HalliHaida wrote:

grp = Graphics.FromImage(image);

K1, AAA
K2, BBB
K3, BBB
K4, CCC

using System;
using System.Collections.Generic;

namespace KeyValuePair
{
    class Program
    {
        static void Main(string[] args)
        {
            List<KeyValuePair<string, string>> listImport = new List<KeyValuePair<string, string>>();
            listImport.Add(new KeyValuePair<string, string>("K1", "CCC"));
            listImport.Add(new KeyValuePair<string, string>("K2", "BBB"));
            listImport.Add(new KeyValuePair<string, string>("K3", "AAA"));
            listImport.Add(new KeyValuePair<string, string>("K4", "BBB"));
            listImport.Sort(delegate(KeyValuePair<string, string> first, KeyValuePair<string, string> second)
            {
                return first.Value.CompareTo(second.Value);
            });

            // We only need to "remember" the last value because the KeyValuePair list is sorted.
            string strLast = String.Empty;
            List<string> listDistinct = new List<string>();
            foreach (KeyValuePair<string, string> kvp in listImport)
            {
                if (strLast == kvp.Value)
                    continue;

                listDistinct.Add(kvp.Value);
                strLast = kvp.Value;
            }

            foreach (string str in listDistinct)
                Console.WriteLine(str);

            Console.ReadKey();
        }
    }
}

public class Form2 : Form
{
  private int m_nValue = 0;
  //Constructor
  public Form2()
  {
  }

  public void SetValue(int val)
  {
    m_nValue = val;
  }
}

Form2 frm = new Form2();
frm.SetValue(1);