关于.net数据库操作中执行增删改，需要有返回值的操作

 

不使用微软企业库，用事务来执行增删改查，需要有执行结果是否成功的值方法。

using (SqlConnection conn = new SqlConnection(StrConstring))
{
using (SqlCommand command = conn.CreateCommand())
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction();
command.Transaction = transaction;
try
{
command.CommandText = "INSERT INTO WebDB_Info_Upfiles(AttachID,infoid,filename,fileContent,contentType,length) VALUES('" + AttachID + "','" + infoid + "','" + filename + "','" + fileContent + "','" + contentType + "','" + length + "')";
command.ExecuteNonQuery();
transaction.Commit();
}
catch
{
transaction.Rollback();
return false;
}
}
}
return true;