asp.net OleDbCommand 的用法
asp.net OleDbCommand 的用法
发布时间:2016-12-29 来源:查字典编辑
摘要:OleDbConnectioncon=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4....

OleDbConnectioncon=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;datasource=data.mdb");

con.Open();

OleDbCommanddc=newOleDbCommand("selectnamefromuswhereid=2",con);

textBox1.Text=dc.ExecuteScalar().ToString();

OleDbConnectioncon=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;datasource=data.mdb");

con.Open();

OleDbCommanddc=newOleDbCommand("insertintous(name)values(11)",con);

dc.ExecuteNonQuery();

con.Close();

stringus=textBox2.Text;

stringpa=textBox1.Text;

OleDbConnectioncon=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;datasource=data.mdb");

OleDbCommandoldC=newOleDbCommand("insertintousers(username,userpassword)values(@username,@userpassword)",con);

oldC.Parameters.Add("@username",us);

oldC.Parameters.Add("@userpassword",pa);

con.Open();

oldC.ExecuteNonQuery();

con.Close();

MessageBox.Show("Registersuccessful!");

this.Dispose();

推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
相关阅读
网友关注
最新asp.net教程学习
热门asp.net教程学习
编程开发子分类