transaction in asp.net
-
i have code like this : Dim SQL As String SQL = String.Format("delete from CEVAPLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd As New SqlCommand(SQL, cn) cmd.Connection.Open() Dim sql1 As String sql1 = String.Format("delete from NOTLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd1 As New SqlCommand(sql1, cn) cmd1.Connection.Open() there is two sql command here. I want to run this querries in a transaction.if one of them this querries are cancelled both of them are made rollback. How can i coded this transaction in asp.net vb codebehind.? Thanks..
-
i have code like this : Dim SQL As String SQL = String.Format("delete from CEVAPLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd As New SqlCommand(SQL, cn) cmd.Connection.Open() Dim sql1 As String sql1 = String.Format("delete from NOTLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd1 As New SqlCommand(sql1, cn) cmd1.Connection.Open() there is two sql command here. I want to run this querries in a transaction.if one of them this querries are cancelled both of them are made rollback. How can i coded this transaction in asp.net vb codebehind.? Thanks..
Something like this. Used stored procs though!!!! Dim SQL As String SQL = String.Format("delete from CEVAPLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cn As New SqlConnection Dim cmd As New SqlCommand(SQL, cn) Dim trans As SqlTransaction cmd.Connection.Open() trans = cn.BeginTransaction Dim sql1 As String sql1 = String.Format("delete from NOTLAR where PERSONEL_ID={0} and BOLUM_ID={1} and DONEM='{2}'", ddlPersonel.SelectedItem.Value, ddlBolumAdi.SelectedItem.Value, Session("donem")) Dim cmd1 As New SqlCommand(sql1, cn) trans.Commit() how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06