C#最基本的数据库增删改查
时间：2021-07-01 10:21:17
帮助过：19人阅读
access
{
public partial class Form1 : Form
{
//定义数据库的连接路径
string txtConn =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\access.mdb";
public Form1()
{
InitializeComponent();
}
private void button1_Click(
object sender, EventArgs e)
{
//修改记录按钮代码
using(OleDbConnection conn =
new OleDbConnection(txtConn))
{
string sql =
string.Format(
"update table1 set fl=‘{1}‘,lxfs=‘{2}‘,dzyj=‘{3}‘ where xm=‘{0}‘", textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text);
OleDbCommand cmd =
new OleDbCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
}
}
private void button2_Click(
object sender, EventArgs e)
{
//删除记录按钮代码
using (OleDbConnection conn =
new OleDbConnection(txtConn))
{
string sql =
string.Format(
"delete from table1 where xm=‘{0}‘", textBox1.Text);
OleDbCommand cmd =
new OleDbCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
}
}
private void button3_Click(
object sender, EventArgs e)
{
//添加记录按钮代码
using (OleDbConnection conn =
new OleDbConnection(txtConn))
{
string sql =
string.Format(
"insert into table1(xm,fl,lxfs,dzyj) values(‘{0}‘,‘{1}‘,‘{2}‘,‘{3}‘)", textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text);
OleDbCommand cmd =
new OleDbCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
}
C#最基本的数据库增删改查
标签：provider mat 定义 date using new ring format into
