ASP.NET的ACCESS数据库操作类

来源：csdn 作者：JavaProgramers 出处：巧巧读书 2006-07-03 进入讨论组

　　myAdpater.Update(myDataset,strTableName);

myConnection.Close();

}

///
/// 添加行
///
/// 此行中的字段集合

/// 此行中的字段集合的对应值
/// 所属表名称
/// 表中主键

public void AddRow(string[]columns,string[]columnvalue,string strTableName,string strColumnKey)
{

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=" + Server.MapPath(datapatch);

string strColumnCount = "";
foreach(string thiscolunmname in columns)
{
strColumnCount = thiscolunmname+","+strColumnCount;
}

string strCommandText = "select "+strColumnCount+strColumnKey+" from "+strTableName;

OleDbConnection myConnection = new OleDbConnection(strConnection);
myConnection.Open();

OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText,myConnection);

OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);

DataSet myDataset = new DataSet();

myAdpater.Fill(myDataset,strTableName);

DataRow newrow = myDataset.Tables[strTableName].NewRow();

for(int i=0;i {
string strColumnName = columns[i].ToString();

newrow[strColumnName] = columnvalue[i].ToString();
}

myDataset.Tables[strTableName].Rows.Add(newrow);

myAdpater.Update(myDataset,strTableName);

myConnection.Close();

}
///
/// 更新数据行
///
/// 要更新的列集合
/// 要更新的列集合的对应值
/// 所属表名称
/// 表主键
/// 行所属的ＩＤ
public void updateRow(string[]columns,string[]columnvalue,string strTableName,string strColumnKey,string strColumnValue)
{

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +
"Data Source=" + Server.MapPath(datapatch);

string strColumnCount = "";
foreach(string thiscolunmname in columns)
{
strColumnCount = thiscolunmname+","+strColumnCount;
}通告:http://www.qqread.com/aspdotnet/n748130002.html