Question

C#如何将textbox中的内容写入ACCESS数据库。求完整代码。给大神跪了

Answer 1

OledbConnection myconn = new OledbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tushu.mdb") & ";Persist Security Info=False”);
myconn.Open();

string strsql = "insert into table values('"+textBox1.Text+"')";
OledbCommand cmd = new OledbCommand(strsql,myconn);
cmd.ExecuteNonQuery();

myconn.Close();
//最后可以提示一下
MessageBox.Show("success");

追问

大神你看我的sql语句有没有问题

string strtx1=.textBox1.text
string strtx2=.textBox2.text
inset into RegionCode(Code,Name)values('"+strtxtt1+"','"+strtxt2+'');

Answer 2

引用巨蟹囧rz小朋友的回答：
OledbConnection myconn = new OledbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tushu.mdb") & ";Persist Security Info=False”);
myconn.Open();

string strsql = "insert into table values('"+textBox1.Text+"')";
OledbCommand cmd = new OledbCommand(strsql,myconn);
cmd.ExecuteNonQuery();

myconn.Close();
//最后可以提示一下
MessageBox.Show("success");

"inset into RegionCode(Code,Name) values('"+strtxtt1+"','"+strtxt2+"')";