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();
}
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();
MessageBox.Show("挂号成功");
}
private void button3_Click(object sender, EventArgs e)
{
textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = string.Empty;
}
private void 挂号界面_Load(object sender, EventArgs e)
{
}
}
}
难道是数据库连接或者 insert 语句错误吗?
求大神帮忙看下,帮我改下,小弟实在是小白啊