C#与mySql实战七：在界面中输入参数；

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

using MySql.Data;
using MySql.Data.MySqlClient;
namespace WindowsFormsApplication1
{    

    public partial class Form1 : Form
    {
        string MyConnectionString = "server=localhost;uid=root;pwd=1234;database=student";
        public Form1()
        {
            InitializeComponent();
        }

        //在每个按钮或其他动作里面添加数据库的打开、操作、关闭；这样可以连续不断的独立的运行；

        private void button1_Click(object sender, EventArgs e)
        {
            int studentScore;
            string score = textBox3.Text;
            int.TryParse(score, out studentScore);

            MySqlConnection connection = new MySqlConnection(MyConnectionString);
            MySqlCommand cmd;
            connection.Open();

            try
            {
                cmd = connection.CreateCommand();
                cmd.CommandText = "INSERT INTO student_score(Id,Name,Score) VALUES(@Id,@Name,@Score)";
                cmd.Parameters.AddWithValue("@Id", int.Parse(textBox1.Text));
                cmd.Parameters.AddWithValue("@Name", textBox2.Text);
                cmd.Parameters.AddWithValue("@Score", studentScore);

                cmd.ExecuteNonQuery();
            }
            catch(Exception)
            {
                throw;
            }
            finally
            {
                //最后是关闭操作；
                if(connection.State==ConnectionState.Open)
                {
                    connection.Close();
                    LoadData();
                }
            }

        }
        private void LoadData()
        {
            MySqlConnection connection = new MySqlConnection(MyConnectionString);
            connection.Open();
            try
            {
                MySqlCommand cmd = connection.CreateCommand();
                cmd.CommandText = "SELECT * FROM student_score";

                //对数据库的读出和写入可以单独操作；
                MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                adap.Fill(ds);
                //表示显示ds中第一个数据表，默认设置（全部显示）；
                dataGridView1.DataSource = ds.Tables[0].DefaultView;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if(connection.State==ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }


        
    }
}

图像：