挂号成功，但数据没写入数据库中，帮忙改改看看把~！

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.Data.OleDb;

namespace 专科医院门诊系统_眼科_
{

public partial class 挂号界面 : Form
{

    public 挂号界面()
    {
        InitializeComponent();
        button1.Click += new EventHandler(button1_Click);
        button2.Click += new EventHandler(button2_Click);
        button3.Click += new EventHandler(button3_Click);

    }


    private void button1_Click(object sender, EventArgs e)
    {
        挂号缴费选择界面 frm = new 挂号缴费选择界面();
        frm.Show();
        Hide();
    }
    private void button2_Click(object sender, EventArgs e)
    {
        string a = textBox1 .Text ;
        string b = textBox2 .Text ;
        string c = textBox3 .Text ;
        string d = textBox4 .Text ;
        string f = textBox5 .Text ;
        string g = textBox6 .Text ;
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\design\vc\project\专科医院门诊系统（眼科）\db1.accdb";
        conn.Open();
        string str = "insert into patient (ID,名字,年龄,性别,电话号码,科室) values ( " + a + ",'" + b + "', "+ c +" ,'" + d + "', "+ f +" ,'" + g + "')";
        OleDbCommand cmd=new OleDbCommand();
        cmd.Connection=conn;
        cmd.CommandText=str;
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        conn.Close();
        conn.Dispose();
        if (textBox1.Text.Trim() == String.Empty || textBox2.Text.Trim() == String.Empty || textBox3.Text.Trim() == String.Empty || textBox4.Text.Trim() == String.Empty || textBox5.Text.Trim() == String.Empty || textBox6.Text.Trim() == String.Empty)
        {
            MessageBox .Show ("请输入完整的挂号信息");
        }
        else
        {
            MessageBox.Show("挂号成功");
         }
    }
    private void button3_Click(object sender, EventArgs e)
    {
        textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text =textBox6.Text = string.Empty;
    }
    private void 挂号界面_Load(object sender, EventArgs e)
    {

    }
}

}

cmd.ExecuteNonQuery();
这里有报错么？你怎么判断的已经插入了，又怎么判断的没有写入

先确认sql是否正确，然后看看数据库中有没有，或许是你查询有问题

把这三句注释了再试试
cmd.Dispose();
conn.Close();
conn.Dispose();