有人指點一下錯在哪里嗎？謝謝！代碼如下：
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0; Data Source=" + @"C:\Temp\901.mdb");
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM OrderTransactions ORDER BY OrderTransactionID", conn);
OleDbCommand updateCommand = new OleDbCommand("UPDATE OrderTransactions SET LastRowHash = ? WHERE OrderTransactionID = ? ", conn);
updateCommand.Parameters.Add("p1", OleDbType.VarWChar, 50, "LashRowHash");
OleDbParameter param = updateCommand.Parameters.Add("p2", OleDbType.Integer);
param.SourceColumn = "OrderTransactionID";
param.SourceVersion = DataRowVersion.Original;
adapter.UpdateCommand = updateCommand;
DataTable data = new DataTable();
adapter.Fill(data);
string rowString;
foreach (DataRow row in data.Rows)
{
rowString = "";
foreach (DataColumn col in data.Columns)
{
if (col.ColumnName.ToUpper() != "LASTROWHASH")
{
rowString += row[col].ToString();
}
}
string hashString = ComputeMD5(rowString);
if (row["LastRowHash"].ToString() != hashString)
{
row["LastRowHash"] = hashString;
}
}
adapter.Update(data);
conn.Close();
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/50925.html
標籤：C#