大家好,又见面了,我是你们的朋友全栈君。
OleDbConnection 用法
con=new OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0; data source=data.mdb”); con.Open(); OleDbCommand dc=new OleDbCommand(“select name from us where id=2”, con); textBox1.Text=dc.ExecuteScalar().ToString();
OleDbConnection con=new OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0; data source=data.mdb”); con.Open(); OleDbCommand dc=new OleDbCommand(“insert into us (name) values (11)”, con); dc.ExecuteNonQuery(); con.Close();
string us=textBox2.Text; string pa=textBox1.Text; OleDbConnection con=new OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0; data source=data.mdb”); OleDbCommand oldC=new OleDbCommand(“insert into users (username, userpassword) values (@username, @userpassword)”, con); oldC.Parameters.Add(“@username”, us); oldC.Parameters.Add(“@userpassword”, pa); con.Open(); oldC.ExecuteNonQuery(); con.Close(); MessageBox.Show(“Register successful!”); this.Dispose();
使用参数的时候,参数是有顺序的。@username 和 @userpassword 的顺序要写对,不能颠倒过来。
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/144274.html原文链接:https://javaforall.cn