Add a Transaction to your C# code:
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand( queryString,connection ))
{
SqlTransaction trans;
try
{
connection.Open();
trans = connection.BeginTransaction("Trans");
cmd.Transaction = trans;
cmd.ExecuteNonQuery ();
trans.Commit();
return "sukses";
}
catch (Exception ex)
{
if trans != null) trans.Rollback();
return ex.Message;
}
}
}
[edit]:doh: forgot to connect the transaction to the command... :O [/edit]
[edit]Griff, get yourself a coffee - you need it...[/edit]