System.Data.OleDb.OleDbException: 找不到可安装的 ISAM 高手帮忙看下为什么出错
string strConnection = "Provider =Microsoft.Jet.OLEDB.4.0; data source==F:\\ASP网站\\WebSite3\\data.mdb; Persist Security Info=False;";OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
String sql_insert = "insert into user (username,password,QQ) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";
OleDbCommand cmd_insert = new OleDbCommand(strConnection);
cmd_insert.Parameters.Add(new OleDbParameter("@username", this.TextBox1.Text));
cmd_insert.Parameters.Add(new OleDbParameter("@password", this.TextBox2.Text));
cmd_insert.Parameters.Add(new OleDbParameter("@QQ", this.TextBox3.Text));
objConnection.Close();
运行调试后显示
System.Data.OleDb.OleDbException: 找不到可安装的 ISAM
我试了一上午了 都不行啊 到底哪里出错了 --------------------编程问答-------------------- 写法注意格式
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;data source=F:\\ASP网站\\WebSite3\\data.mdb; Persist Security Info=False;";
--------------------编程问答-------------------- 如果是web程序
请把mdb放在网站根目录下的Data_App下面。然后写
String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|data.mdb";
这样可以提高数据库的安全性 --------------------编程问答-------------------- 还是不行啊
补充:.NET技术 , C#