d630

TODO

d630

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

d630

TODO

d630

4. TODO

5. • Kreuztabelle, Kartesisches Produkt, cross join
   • The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match. The RIGHT JOIN keyword returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side, when there is no match.

• The INNER JOIN keyword selects records that have matching values in both

d630

namespace IHK2
{
    public class Auftrag
    {
        public Auftrag(int a_id, string nummer, double umsatz, int v_id)
        {
            this.A_id = a_id;
            this.Nummer = nummer;
            this.Umsatz = umsatz;
            this.V_id = v_id;

d630

using System;
using System.Collections.Generic;
using System.Windows.Forms;
using System.Xml;

namespace XmlExp
{
    public partial class Form1 : Form
    {
        public const string XML_DATA = "http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml";

d630

using System;
using System.Collections.Generic;
using System.IO;

namespace person
{
    class Person
    {
        public Person(string nachname, string vorname)
        {

d630

-- 1)
SELECT *
FROM mitarbeiter
WHERE tagesarbeitszeit IS NULL OR tagesarbeitszeit < 7;

-- 2)
UPDATE mitarbeiter
SET tagesarbeitszeit = tagesarbeitszeit + tagesarbeitszeit * 0.10
WHERE tagesarbeitszeit IS NOT NULL;

d630

TODO

d630

using System;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using System.Windows.Forms;

// TODO: avoid injections
// TODO: Better exception handling

namespace PersonalDB
{