using System.Data.OleDb;也写了的
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection sqlcon = new OleDbConnection("provider=Microsoft.Jet.Oledb.4.0;Data Source=db_RGS.mdb");
sqlcon.Open();
OleDbCommand ocmd = new OleDbCommand("insert into user(user_id,user_pwd,user_type) values ('" + textBox1.Text + "','" + textBox2.Text + "'," + textBox3.Text + ")", sqlcon);
ocmd.ExecuteNonQuery();
MessageBox.Show("添加 is susses");
}
麻烦各位大大帮我看下来那儿有错
数据库中表属性是文本、文本、数字、
表名字是user
字段是user_id
user_pwd
user_type
在C#中老显示insert into语句有错
然后
ocmd.ExecuteNonQuery();这句话被涂黄了的
OleDbConnection sqlcon = new OleDbConnection("provider=Microsoft.Jet.Oledb.4.0;Data Source=db_RGS.mdb");
sqlcon.Open();
OleDbCommand ni = new OleDbCommand("delete from userr where id=" + textBox1.Text, sqlcon);
ni.ExecuteNonQuery();
MessageBox.Show("删除 is susses");
如何把这句话改成文本啊OleDbCommand ni = new OleDbCommand("delete from userr where id=" + textBox1.Text, sqlcon);
现在的输入方法是数值.
|
