C#

        private string FixOBez()
        {
            SqlConnection dbconn = new SqlConnection(this.sqlconn);

            try
            {
                dbconn.Open();

                SqlDataReader sqlreader = null;
                SqlCommand mycmd = new SqlCommand("SELECT * FROM dbo.testdata", dbconn);
                sqlreader = mycmd.ExecuteReader();

                // Wo kein leerzeichen ist muss eins eingefügt werden
                while (sqlreader.Read())
                {
                    string obez = sqlreader["O_BEZ"].ToString();
                    string okuerzel = sqlreader["O_KURZ"].ToString();

                    // Neue Bezeichnung holen
                    string[] lines = GetNewOBez(obez);


                    // Neue Bezeichnung schreiben
                    SqlCommand sql2 = new SqlCommand("UPDATE dbo.testdata SET WEB_OBEZ1 = '" + lines[0] + "',WEB_OBEZ2 = '" + lines[1] + "',WEB_OBEZ3 = '" + lines[2] + "' WHERE O_KURZ = '" + okuerzel + "'",dbconn);
                    sql2.ExecuteNonQuery();

                    return "OK";
                }

            }
            catch (Exception ex)
            {
                return ex.Message;
            }

            return "OK";
}

private void mainTreeView_AfterSelect(object sender, TreeViewEventArgs e)
{
    if (mainTreeView.SelectedNode == null) return;    // No selection

    TreeNode selectedNode = mainTreeView.SelectedNode;

    switch (selectedNode.Level)
    {
        case 0:    // Root node
            // Toggle the 'Enabled' state of eight items total (combination of ToolStrip and MenuStrip items)
            // ...
            break;
        case 1:    // Child node (only goes Root->Child at the moment; may expand allowed depth later on but not right now)
            if (selectedNode.Parent.Name == "RootNode1")
            {
                // Toggle items based on child of RootNode1
                // ...
            }
            else if (selectedNode.Parent.Name == "RootNode2")
            {
                // Toggle items differently from RootNode1
                // ...
            }
            break;
    }
}
}

String sql = "SELECT ID as {c.id}, NAME as {c.name}, " +<br />
       "BIRTHDATE as {c.birthDate}, MOTHER_ID as {c.mother}, {mother.*} " +<br />
      "FROM CAT_LOG c, CAT_LOG m WHERE {c.mother} = c.ID";<br />
    List loggedCats = sess.createSQLQuery(sql)<br />
      .addEntity("cat", Cat.class)<br />
      .addEntity("mother", Cat.class).list()

SELECT {ctrl1.*}, {ctrl2.*} FROM tableA AS A<br />
                                                LEFT JOIN tableB AS ctrl1 ON (A.controlID = ctrl1.controlID AND ctrl1.controlOptionType = ? AND ctrl1.controlOptionValue = ?)<br />
                                                LEFT JOIN tableB AS ctrl2 ON (A.controlID = ctrl2.controlID AND ctrl2.controlOptionType = ? AND ctrl2.controlOptionValue = ?)

[DllImport("coredll.dll")]
        private extern static uint RasGetEntryProperties(string lpszPhoneBook, string szEntry, ref RASENTRY lpbEntry,
            ref int lpdwEntrySize, byte lpb, int lpdwSize);

RasGetEntryProperties(null, name, ref RasEntry, ref dwSize, 0, 128);

private struct RASENTRY
        {
            public int dwSize;
            public int dwfOptions;
            public int dwCountryID;
            public int dwCountryCode;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxAreaCode + 1)]
            public string szAreaCode;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxPhoneNumber + 1)]
            public string szLocalPhoneNumber;
            public int dwAlternatesOffset;
            public RASIPADDR ipaddr;
            public RASIPADDR ipaddrDns;
            public RASIPADDR ipaddrDnsAlt;
            public RASIPADDR ipaddrWins;
            public RASIPADDR ipaddrWinsAlt;
            public int dwFrameSize;
            public int dwfNetProtocols;
            public int dwFramingProtocol;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = MAX_PATH + 1)]
            public string szScript;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = MAX_PATH + 1)]
            public string szAutoDialDll;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = MAX_PATH + 1)]
            public string szAutoDialFunc;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxDeviceType + 1)]
            public string szDeviceType;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxDeviceName + 1)]
            public string szDeviceName;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxPadType + 1)]
            public string szX25PadType;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxX25Address + 1)]
            public string szX25Address;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxFacilities + 1)]
            public string szX25Facilities;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = RAS_MaxUserData + 1)]
            public string szX25UserData;
            public int dwChannels;
            public int dwReserved1;
            public int dwReserved2;
            public int dwCustomAuthKey;
        }

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
    int currentRow = int.Parse(e.RowIndex.ToString());
    int rowint = 0;
    string sql = "SELECT TimesheetDetailID, EmployeeID, TSProjectCodeID, TimeSheetDate, HoursWorked, TaskCode, Notes from tblTimesheetDetails WHERE TimesheetDetailID ='" + rowint + "'";
    string empID = dataGridView1[1, currentRow].Value.ToString();
    string projcode = dataGridView1[2, currentRow].Value.ToString();
    string timedate = Convert.ToString(dataGridView1[3, currentRow].Value.ToString());
    double hrs = Convert.ToDouble(string.Format("{0:f}", (dataGridView1[4, currentRow].Value.ToString())));
    string taskcode = dataGridView1[5, currentRow].Value.ToString();
    string notes = dataGridView1[6, currentRow].Value.ToString();
    OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
    OleDbCommandBuilder cmb = new OleDbCommandBuilder(da);
    da.Fill(dataTable);
    string updateString = "Update tblTimesheetDetails SET EmployeeID ='" + empID + "', TimesheetID ='" + "" + "', TSProjectID ='" + projcode + "', TimeSheetDate ='" + timedate + "', HoursWorked ='" + hrs + "',TaskCode ='" + taskcode + "', Notes ='" + notes + "' WHERE TimesheetDetailID ='" + rowint + "'";

    try
    {
        conn.Open();
        string timesheetString = dataGridView1[0, currentRow].Value.ToString();
        rowint = int.Parse(timesheetString);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message.ToString());
    }

    if (dataGridView1.Columns[e.ColumnIndex] == deleteButton && currentRow >= 0)
    {

        string queryDeleteString = "DELETE FROM tblTimesheetDetails where TimesheetDetailID = " + rowint + "";
        OleDbCommand sqlDelete = new OleDbCommand();
        sqlDelete.CommandText = queryDeleteString;
        sqlDelete.Connection = conn;
        sqlDelete.ExecuteNonQuery();
    }



    else if (dataGridView1.Columns[e.ColumnIndex] == editButton && currentRow >= 0)
    {

        try
        {
            if (dataTable.Rows.Count != 0)
            {
                dataTable.Rows[rowint]["EmployeeID"] = empID;
                dataTable.Rows[rowint]["TimesheetID"] = 0;
                dataTable.Rows[rowint]["TSProjectCodeID"] = projcode;
                dataTable.Rows[rowint]["TaskCode"] = taskcode;
                dataTable.Rows[rowint]["TimeSheetDate"] = timedate;
                dataTable.Rows[rowint]["HoursWorked"] = hrs;
                dataTable.Rows[rowint]["Notes"] = notes;
                dataTable.AcceptChanges();
                da.Update(dataTable);
            }
        }
        catch (OleDbException exx)
        {
            MessageBox.Show(exx.Message.ToString());
        }

    }
        conn.Close();
        GetDataView();
}

void h323_RemoteBusy()
        {
            MessageBox.Show("User is busy");
        }

        void h323_Disconnected(string RemoteUserName)
        {
            MessageBox.Show("Call Disconnected ");
            btnCall.IsEnabled = true;
            btnEndCall.IsEnabled = false;
            btnVideo.IsEnabled = false;
            lblCallStatus.Visibility = Visibility.Hidden;
        }
        void h323_Connected(string RemoteUserName)
        {
            System.Windows.Forms.DialogResult myDialogResult = System.Windows.Forms.MessageBox.Show("Incomming Call by " + RemoteUserName + "\nDo u want to recieve Call?", "Message", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question);
            if (myDialogResult == System.Windows.Forms.DialogResult.Yes)
            {
                h323.Answer();
            }
            else
            {
                h323.Hangup();
            }
        }