1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.Data.OleDb;
using System.IO;
using System.Threading;
using System.Globalization;
using System.IO.Ports;


namespace Auqamatic
{
    public partial class Form1 : Form
    {
        private string InputDatei ="C:\\sd\\Aquamatic.xls";
        SerialPort serialPortObject;
        
        private DataSet ds =null;
        private OleDbDataAdapter da = null;
        private DataTable dt = null;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
           this.Text = "Aquamatic v1.0";
           this.PopulateGrid();
           this.SetFilter();
           label1.Text = "Text kommt noch!";
           label2.Text = "Text kommt noch!";
        }

        private int PopulateGrid()
        {
            try
            {
                if (this.ds == null)
                {
                    String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + this.InputDatei + ";" + "Extended Properties=Excel 8.0;";
                    OleDbConnection objConn = new OleDbConnection(sConnectionString);
                    objConn.Open();
                    OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Tabelle1$]", objConn);
                    if ((this.da == null) && (this.ds == null))
                    {
                        this.ds = new DataSet();
                        this.dt = new DataTable();
                        this.da = new OleDbDataAdapter(objCmdSelect);
                        this.da.SelectCommand = objCmdSelect;
                        this.da.Fill(this.dt);
                        this.datagrid.DataSource = dt;
                    }
                    objConn.Close();
                 }

            }
            catch (Exception ex)
            {
                string msg = " Fehler beim bestücken des Datagrids";

                if (ex.Message != null)
                {
                    msg += ex.Message.ToString() + "\n";
                }
                if (ex.InnerException != null)
                {
                    msg += ex.Message.ToString() + "\n";
                }
                MessageBox.Show( msg, "Fehler", MessageBoxButtons.OK);
            }
            return 0;
        }

        private void monthCalendar1_DateSelected(object sender, DateRangeEventArgs e)
        {
            this.SetFilter();
        }


        private bool SetFilter()
        {
            if (this.ds != null)
            {
                string exp = "";

                exp = " datum >= ";
                exp += this.monthCalendar1.SelectionStart.ToString("#yyyy-MM-dd#");
                exp += " and datum <= ";
                exp += this.monthCalendar1.SelectionEnd.ToString("#yyyy-MM-dd#");
                this.dt.DefaultView.RowFilter = exp;
                this.dt.DefaultView.Sort = " datum";
            }
            else
            {
                return false;
            }
            
            return true;
        }

        private void monthCalendar1_DateChanged(object sender, DateRangeEventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {           

            serialPortObject = new SerialPort("COM1", 9600, Parity.None, 8, StopBits.One);//Parität=gerade
            serialPortObject.Handshake = Handshake.None;
            serialPortObject.ReadTimeout = 500;
            serialPortObject.WriteTimeout = 500;
            try
            {
                serialPortObject.Open();
            }
            catch (Exception)
            {
                label3.Text = "Comport nicht verfügbar";
                return;

            }
            timer1.Start();
            label3.Text = "Verbunden mit COM1";
            button2.Enabled = false;
            button3.Enabled = true;
           //-----------------------------------

            //Hier soll der Serialport ausgelesen und die Daten in Excel gespeichert werden!
      
        }

        private void button3_Click(object sender, EventArgs e)
        {         
            timer1.Stop();
            serialPortObject.Close();
            label3.Text = "COM Port geschlossen.";
            button3.Enabled = false;
            button2.Enabled = true;
           
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            readSerialPort(); //Intervall 1000

        }

        public void readSerialPort()//anstehende daten am COM Port einlesen
        {
            try
               {
                   string message = serialPortObject.ReadLine();
               }
            catch (TimeoutException) { }
       
        }

        public void sendSerialPort(String message)//Übergebene Nachricht über COM port verschicken und in Log eintragen
        {
            
       }

    }
}					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

        internal void _Port_DataReceived(object sender, System.IO.Ports.SerialDataReceivedEventArgs e)
        {
            string data = null;
            try
            {
                data = _Port.ReadLine();
            }
            catch
            {
                data = _Port.ReadExisting();
            }
            if (!String.IsNullOrEmpty(data))
                HandleData(data);
        }