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

[Yock]

谁有操作SQL2000数据库,添加、删除、更新的源码。

[skyhill13]

我没有，但是我顶！给分可以了吧，我是第一个顶的哦

[Yock]

等等吧小子

[小贵子88]

我也顶

[LiJoe]

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

[yemao20]

UP

[guoyangc]

//添加的源码

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;
}
}

[sea026]

Microsoft 101 sample 有n多

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

[guoyangc]

//删除的源码

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;
}
}

[aidoudou]

来得晚不晚呀，我也在写这个没什么新意的东西

[xhn1]

到处都有啊 随便搜索一下就行了

[feifanyuge]

http://community.csdn.net/Expert/topic/3134/3134358.xml?temp=.5690424

帮忙看看！大哥们！