form5.cs

用C#编写的 实现事件发生的原因与存放到数据库

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;

namespace ming
{
    public partial class Form5 : Form
    {
        public Form5()
        {
            InitializeComponent();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("报警原因及措施不能为空");
                textBox1.Select();
            }
            else
            {
                string   ram = this.textBox1.Text;                        //数据存进数据库
                string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
                                       "SERVER=localhost;" +
                                       "DATABASE=user_imformation;" +
                                       "UID=root;" +
                                       "PASSWORD=123;" +
                                       "OPTION=3";
                                      
                                      

                OdbcConnection MyConnection = new OdbcConnection(MyConString);

                OdbcCommand MyCommand = MyConnection.CreateCommand();
                MyConnection.Open();
             
                MyCommand.CommandText = "INSERT INTO calling(reasonandmeasure,time) VALUES ('" + ram + "', '" + System.DateTime.Now + "') ";
                OdbcDataReader MyReader = MyCommand.ExecuteReader();
                MessageBox.Show("消除成功");
                MyConnection.Close();
                Close();
               
                        }
        }

        private void label4_Click(object sender, EventArgs e)
        {

        }

        private void Form5_Load(object sender, EventArgs e)
        {

        }
    }
}