我是一个新手,今天正在做一个小的留言板,使用的是ACCESS数据库,可是我在添加数据的时候不知道为什么我的数据库变成只读的了,错误提示我需要一个可以更新的查询。而且我不知道怎么设置数据库的绝对路径。

希望高手给我一些指点。谢谢!
下面是我部分代码:

    OleDbConnection thisConnection = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\Inetpub\wwwroot\leaveword\database\db.mdb");
    DataSet thisDataSet = new DataSet();
    thisConnection.Open();
    OleDbDataAdapter thisAdapter = new OleDbDataAdapter("select id,Name,Tel,Address,Inc,Email,Topic,Title from leaveword",thisConnection);
    OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
    thisAdapter.Fill(thisDataSet,"leaveword");
    DataRow thisRow = thisDataSet.Tables["leaveword"].NewRow();
    thisRow["id"] = 1;
    thisRow["Name"] = Name.Text.Trim();
    thisRow["Tel"] = Tel.Text.Trim();
    thisRow["Address"] = Address.Text.Trim();
    thisRow["Inc"] = Inc.Text.Trim();
    thisRow["Email"] = Email.Text.Trim();
    thisRow["Topic"] = Topic.Text.Trim();
    thisRow["Title"] = Title.Text.Trim();
    thisDataSet.Tables["leaveword"].Rows.Add(thisRow);
    thisAdapter.Update(thisDataSet,"leaveword");
    this.Error1.Text="<SCRIPT language='javascript'>alert('成功添加!');</script>";
    thisConnection.Close();
posted on 2005-03-16 11:02  疯狂老蛋  阅读(3064)  评论(1编辑  收藏  举报