自己写了个access的简单记事本,调不过去
请大虾们帮解决下
新手
语言请简单:)
**************************
报错提示:
“/MsgBoard”应用程序中的服务器错误。
--------------------------------------------------------------------------------编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: CS0103: 当前上下文中不存在名称“DbProviderFactories”源错误: 行 25: string strConnection = @"Provider=Micorsoft.Jet.Ole.4.0;Data Source=";//设定连接字符串
行 26: strConnection += Server.MapPath(".\\App_Data\\MsgBoard.mdb");
行 27: System.Data.Common.DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactor("System.Date.OleDb");
行 28: DbConnection dbConnection = dbProviderFactory.CreateConnection();
行 29: dbConnection.ConnectionString = strConnection;
源文件: d:\My Documents\Visual Studio 2005\WebSites\MsgBoard\Default.aspx.cs 行: 27
*************************************
.cs的源码如下
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
string strName = this.tbName.Text;
string strSubject = this.tbSubject.Text;
string strMsg = this.tbMsg.Text;
string strIP = Request.UserHostAddress.ToString();
string strDate = System.DateTime.Now.ToString();
//插入数据库
string strConnection = @"Provider=Micorsoft.Jet.Ole.4.0;Data Source=";//设定连接字符串
strConnection += Server.MapPath(".\\App_Data\\MsgBoard.mdb");
System.Data.Common.DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactor("System.Date.OleDb");
DbConnection dbConnection = dbProviderFactory.CreateConnection();
dbConnection.ConnectionString = strConnection;
dbConnection.Open();
DbCommand dbCommand = dbProviderFactory.CreateCommand();
dbCommand.Connection = dbConnection;
//注意date未Access保留字,所以需要加[]号
dbCommand.CommandText = "INSERT INTO post(name,subject,message,[date],ip)VALUES('";
dbCommand.CommandTest += strName + "','" + strSubject + "','" + strMsg + "','" + strDate + "','" + strIP + "');";
// dbCommand.CommandText="INSERT INTO post(name,subject,message,[date],ip)VALUES("";dbCommand.CommandTest+=strName+"",""+strSubject+"",""+strMsg+"",""+strDate+"",""+strIP+"");";
// <!--("";dbCommand.CommandText+=strName+"",""+strSubject+"",""+strMsg+"",""+strDate+"",""+strIP+"");";-->
dbCommand.ExecuteNonQuery();
dbConnection.Close();
dbConnection.Dispose();
Response.Redirect("default.aspx");
}
}
请大虾们帮解决下
新手
语言请简单:)
**************************
报错提示:
“/MsgBoard”应用程序中的服务器错误。
--------------------------------------------------------------------------------编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: CS0103: 当前上下文中不存在名称“DbProviderFactories”源错误: 行 25: string strConnection = @"Provider=Micorsoft.Jet.Ole.4.0;Data Source=";//设定连接字符串
行 26: strConnection += Server.MapPath(".\\App_Data\\MsgBoard.mdb");
行 27: System.Data.Common.DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactor("System.Date.OleDb");
行 28: DbConnection dbConnection = dbProviderFactory.CreateConnection();
行 29: dbConnection.ConnectionString = strConnection;
源文件: d:\My Documents\Visual Studio 2005\WebSites\MsgBoard\Default.aspx.cs 行: 27
*************************************
.cs的源码如下
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
string strName = this.tbName.Text;
string strSubject = this.tbSubject.Text;
string strMsg = this.tbMsg.Text;
string strIP = Request.UserHostAddress.ToString();
string strDate = System.DateTime.Now.ToString();
//插入数据库
string strConnection = @"Provider=Micorsoft.Jet.Ole.4.0;Data Source=";//设定连接字符串
strConnection += Server.MapPath(".\\App_Data\\MsgBoard.mdb");
System.Data.Common.DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactor("System.Date.OleDb");
DbConnection dbConnection = dbProviderFactory.CreateConnection();
dbConnection.ConnectionString = strConnection;
dbConnection.Open();
DbCommand dbCommand = dbProviderFactory.CreateCommand();
dbCommand.Connection = dbConnection;
//注意date未Access保留字,所以需要加[]号
dbCommand.CommandText = "INSERT INTO post(name,subject,message,[date],ip)VALUES('";
dbCommand.CommandTest += strName + "','" + strSubject + "','" + strMsg + "','" + strDate + "','" + strIP + "');";
// dbCommand.CommandText="INSERT INTO post(name,subject,message,[date],ip)VALUES("";dbCommand.CommandTest+=strName+"",""+strSubject+"",""+strMsg+"",""+strDate+"",""+strIP+"");";
// <!--("";dbCommand.CommandText+=strName+"",""+strSubject+"",""+strMsg+"",""+strDate+"",""+strIP+"");";-->
dbCommand.ExecuteNonQuery();
dbConnection.Close();
dbConnection.Dispose();
Response.Redirect("default.aspx");
}
}
解决方案 »
- DataGridView 自定义columnType列问题
- 数据库存储过程超时。求解。谢谢。
- 如何实现DropDownList里面的Items属性问题?
- BeforeLabelEdit AfterLabelEdit 这二个事件为什么不触发???
- 请问如何根据一个日期得到该日期是一年中的第几周中的日期,谢谢
- 求正规表达式
- 最近要做个c/s的项目,准备恶补下c/s的知识,大家帮忙推荐本好书吧。
- 如何给mdi主窗口加一个网页背景并且不影响子窗口的显示
- silverlight 5 换肤
- 那里有独立的iis安装程序下载?此问题应在其他论坛,但这里兄弟熟阿,就当散分吧
- 如何以指定的用户,在远程的共享文件夹中创建文件? 请教高手,郁闷好久了。。。
- 能否在函数中设置一种变量,函数退出再进入仍是原值?
using System.Data.Common;