我是一个新手,今天正在做一个小的留言板,使用的是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();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货