点击button后,出错 找不到输出表 'ads' ,ads为数据库
protected void Button2_Click(object sender, EventArgs e)
{
String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:Web/App_Data/ads.mdb";
OleDbConnection connection = new OleDbConnection(connectionString);
string notice_TitleStr = "noticeTitle";
string notice_TimeStr = "noticeTime";
string notice_ContentStr = "noticeContent";
string sqlString = "insert into ads([notice_Title],[notice_Time],[notice_Content]) values('" + notice_TitleStr + "','" + notice_TimeStr + "','" + notice_ContentStr + "')";
connection.Open();
OleDbCommand cmd = new OleDbCommand(sqlString,connection);
cmd.ExecuteNonQuery();
}
protected void Button2_Click(object sender, EventArgs e)
{
String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:Web/App_Data/ads.mdb";
OleDbConnection connection = new OleDbConnection(connectionString);
string notice_TitleStr = "noticeTitle";
string notice_TimeStr = "noticeTime";
string notice_ContentStr = "noticeContent";
string sqlString = "insert into ads([notice_Title],[notice_Time],[notice_Content]) values('" + notice_TitleStr + "','" + notice_TimeStr + "','" + notice_ContentStr + "')";
connection.Open();
OleDbCommand cmd = new OleDbCommand(sqlString,connection);
cmd.ExecuteNonQuery();
}
说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: 找不到输出表 'ads' 。源错误:
行 27: connection.Open();
行 28: OleDbCommand cmd = new OleDbCommand(sqlString,connection);
行 29: cmd.ExecuteNonQuery();
行 30:
行 31:
sql问题
你断点跟踪到sql这一行
看看这行会是什么很明显你连表和库每分清楚