51与PC通信协议设计及实现（七）：关于数据库

按前面的要求，所应用到数据库为sql serve2005,经过我三天的摸索学习，发现数据库还是非常简单的哈～～

先上个学习过程写的数据库，都是最最简单的操作，包括数据库的连接，增减字段……嘿嘿，这么简单竟然学了那么久……惭愧

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

namespace WindowsApp_sql
{
    public partial class Form1 : Form
    {
        SqlConnection sqlconn = new SqlConnection();
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            open_conn(sender,e);
            if (sqlconn.State == ConnectionState.Open)
            {
                test_conn.Text = "连接成功";
                test_conn.Enabled = false;
                exit.Enabled = true;
                add.Enabled = true;
                re_data.Enabled = true;
               // sqlconn.Close();
            }
            else test_conn.Text = "连接失败";
        }

        private void add_Click(object sender, EventArgs e)
        {
            //open_conn(sender,e);
            string add = "INSERT INTO score VALUES('5','数据结构',88)";
            SqlCommand sc = new SqlCommand();
            sc.CommandText = add;
            sc.Connection = sqlconn;
            sc.ExecuteNonQuery();
        }

        private void open_conn(object sender, EventArgs e)
        {
            string myconn = "Server = 192.168.47.128;uid = sa;pwd =;initial catalog = mydb;Connect Timeout=30";
            sqlconn.ConnectionString = myconn;
            try
            {
                sqlconn.Open();
            }
            catch (SqlException se)
            {
                MessageBox.Show(se.ToString());
            }
        }


        private void re_data_Click(object sender, EventArgs e)
        {
            string add = "DELETE FROM score WHERE score.学号 = 5";
            SqlCommand sc = new SqlCommand();
            sc.CommandText = add;
            sc.Connection = sqlconn;
            sc.ExecuteNonQuery();
        }

        private void exit_Click(object sender, EventArgs e)
        {
            if (sqlconn.State == ConnectionState.Open)
            {
                sqlconn.Close();
                exit.Text = "已断开连接";
                exit.Enabled = false;
                test_conn.Enabled = true;
                add.Enabled = false;
                re_data.Enabled = false;
                test_conn.Text = "连接数据库";
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            if (sqlconn.State == ConnectionState.Open)
            {
                exit.Enabled = true;
                add.Enabled = true;
                re_data.Enabled = true;
            }
            else
            {
                exit.Enabled = false;
                add.Enabled = false;
                re_data.Enabled = false;
            }
        }
    }
}

数据库的基本操作还是非常简单的……

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

namespace WindowsApp_sql
{
    public partial class Form1 : Form
    {
        SqlConnection sqlconn = new SqlConnection();
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            open_conn(sender,e);
            if (sqlconn.State == ConnectionState.Open)
            {
                test_conn.Text = "连接成功";
                test_conn.Enabled = false;
                exit.Enabled = true;
                add.Enabled = true;
                add_base.Enabled = true;
                add_table.Enabled = true;
                re_data.Enabled = true;
               // sqlconn.Close();
            }
            else test_conn.Text = "连接失败";
        }

        private void add_Click(object sender, EventArgs e)
        {
            //open_conn(sender,e);
            string add = "INSERT INTO score VALUES('5','数据结构',88)";
            SqlCommand sc = new SqlCommand();
            sc.CommandText = add;
            sc.Connection = sqlconn;
            sc.ExecuteNonQuery();
        }

        private void open_conn(object sender, EventArgs e)
        {
            string myconn = "Server = 192.168.47.128;uid = sa;pwd =;initial catalog = mydb;Connect Timeout=30";
            sqlconn.ConnectionString = myconn;
            try
            {
                sqlconn.Open();
            }
            catch (SqlException se)
            {
                MessageBox.Show(se.ToString());
            }
        }


        private void re_data_Click(object sender, EventArgs e)
        {
            string add = "DELETE FROM score WHERE score.学号 = 5";
            SqlCommand sc = new SqlCommand();
            sc.CommandText = add;
            sc.Connection = sqlconn;
            sc.ExecuteNonQuery();
        }

        private void exit_Click(object sender, EventArgs e)
        {
            if (sqlconn.State == ConnectionState.Open)
            {
                sqlconn.Close();
                exit.Text = "已断开连接";
                exit.Enabled = false;
                test_conn.Enabled = true;
                add.Enabled = false;
                add_base.Enabled = false;
                add_table.Enabled = false;
                re_data.Enabled = false;
                test_conn.Text = "连接数据库";
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            if (sqlconn.State == ConnectionState.Open)
            {
                exit.Enabled = true;
                add.Enabled = true;
                add_base.Enabled = true;
                add_table.Enabled = true;
                re_data.Enabled = true;
            }
            else
            {
                exit.Enabled = false;
                add.Enabled = false;
                add_table.Enabled = false;
                add_base.Enabled = false;
                re_data.Enabled = false;
            }
        }

        private void add_base_Click(object sender, EventArgs e)
        {
            string add = "CREATE DATABASE keys";
            SqlCommand sc = new SqlCommand();
            sc.CommandText = add;
            sc.Connection = sqlconn;
            sc.ExecuteNonQuery();
        }

        private void add_table_Click(object sender, EventArgs e)
        {
            string add = "CREATE TABLE keys ("+
                                            "按键位置 CHAR(10),"+
                                            "按键状态 CHAR(10),"+
                                            "时间 CHAR(10),"+
                                            "次数 CHAR(10)"
                                            +")";
            SqlCommand sc = new SqlCommand();
            sc.CommandText = add;
            sc.Connection = sqlconn;
            sc.ExecuteNonQuery();
        }
    }
}

我的函数和变量的命名规则有问题，得规范起来！！！