hi friends

i need one transaction

in which i am using one command object

to delete all the records from table where userid = "?"

and

one dataadapter and command builder
 using this i am adding multiple rows in the same table

what should be the code for this

i tried this but it gave me some transaction error

thanks

Well

Please clarify your issue a bit more, & post the code that you have written, so that we can help you accordingly.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

Dim tran As SqlTransaction

            Try
                If cn.State = ConnectionState.Closed Then cn.Open()
                tran = cn.BeginTransaction
                Dim cmdDeleteUserActions As New SqlCommand("DELETE FROM UserActionDetails WHERE UserId = " & UserID, cn,tran)
                updateUserActionDetails = cmdDeleteUserActions.ExecuteNonQuery()

                Dim daUpdateUserActions As New SqlDataAdapter("SELECT * FROM UserActionDetails", cn)
                Dim cmdBuilder As New SqlCommandBuilder(daUpdateUserActions)
                Dim ds As New DataSet

                daUpdateUserActions.Fill(ds, "UserActionDetails")
                Dim dRow As DataRow
                Dim rowNo As Int16 = 0
                While rowNo < al.Count
                    dRow = ds.Tables("UserActionDetails").NewRow
                    dRow(0) = UserID
                    dRow(1) = al.Item(rowNo)
                    dRow(2) = 1
                    ds.Tables("UserActionDetails").Rows.Add(dRow)
                    rowNo += 1
                End While
                daUpdateUserActions.Update(ds, "UserActionDetails")
                tran.Commit()
                cmdDeleteUserActions.Dispose()
                cn.Close()
            Catch ex As Exception
               tran.Rollback()
                strEx = ex.Message
            Finally
                cn.Close()
            End Try
        End Function