SqlCommand act = conn.CreateCommand(); conn.Open(); act.Transaction = conn.BeginTransaction(IsolationLevel.RepeatableRead); try { act.CommandType = CommandType.StoredProcedure; act.CommandText = "insert_act"; act.Parameters.AddWithValue("actnumber", SqlDbType.NVarChar).Value = actnumber.Text; act.Parameters.AddWithValue("dateact", SqlDbType.DateTime).Value = DateTime.Parse(actdate.Value.Date.ToString()); act.Parameters.AddWithValue("company", SqlDbType.Int).Value = Int32.Parse(company.SelectedValue.ToString()); act.Parameters.AddWithValue("worker", SqlDbType.Int).Value = Int32.Parse(worcker.SelectedValue.ToString()); act.Parameters.AddWithValue("in_or_out", SqlDbType.Int).Value = 1; act.Parameters.AddWithValue("document", SqlDbType.Image).Value = buf; int idactnew = Int32.Parse(act.ExecuteScalar().ToString()); act.Transaction.Comit(); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } finally { подключение.close(); }