谁有操作SQL2000数据库的添加、删除、更新的源码。回复有分，谢了！！

Question

http://community.csdn.net/Expert/topic/2971/2971408.xml?temp=.9550135

Answer 1

//添加的源码bool InsertDB(SqlConnection sqlConnection)
{
SqlTransaction bookTransaction = null; try
{
// Start a local transaction
bookTransaction = sqlConnection.BeginTransaction();

string insertSQL = "Insert into Test(test1, test2) values('1', '2')";

SqlCommand insertCMD = new SqlCommand(insertSQL, sqlConnection);
insertCMD.Transaction = bookTransaction; int insRow = insertCMD.ExecuteNonQuery(); if (insRow == 0)
{
bookTransaction.Rollback(); return false;   //失败
}
bookTransaction.Commit();

return true;//成功
}
catch
{
return false;
}
}

Answer 2

Microsoft 101 sample 有n多http://www.microsoft.com/downloads/details.aspx?FamilyID=08e3d5f8-033d-420b-a3b1-3074505c03f3&DisplayLang=en

Answer 3

//删除的源码bool DeleteDB(SqlConnection sqlConnection)
{
SqlTransaction bookTransaction = null; try
{
// Start a local transaction
bookTransaction = sqlConnection.BeginTransaction();

string deleteSQL = "DELETE FROM test WHERE testID=1"; SqlCommand deleteCMD = new SqlCommand(deleteSQL, sqlConnection);
deleteCMD.Transaction = bookTransaction; int delRow = deleteCMD.ExecuteNonQuery(); if (delRow == 0)
{
bookTransaction.Rollback(); return false;
}
bookTransaction.Commit();

return true;
}
catch
{
bookTransaction.Rollback();
return false;
}
}//更新的源码
bool UpdateDB(SqlConnection sqlConnection)
{
SqlTransaction bookTransaction = null; try
{
// Start a local transaction
bookTransaction = sqlConnection.BeginTransaction();

string updateSQL = "Update test set test1 = '2' WHERE testID=1"; SqlCommand updateCMD = new SqlCommand(deleteSQL, sqlConnection);
updateCMD.Transaction = bookTransaction; int delRow = updateCMD.ExecuteNonQuery(); if (delRow == 0)
{
bookTransaction.Rollback(); return false;
}
bookTransaction.Commit();

return true;
}
catch
{
bookTransaction.Rollback();
return false;
}
}

Answer 4

http://community.csdn.net/Expert/topic/3134/3134358.xml?temp=.5690424帮忙看看！大哥们！