rollback of last updated queries in sql server

Question

Hello seniors,

I have two  buttons. On the click of first button i update some rows in sql server table.
but my operation will complete after click on second button.

suppose after clicking on first button my server will close enexpectedly or someone close server directly. 
Is there any option availiable in sql server to rollback my last update query if the server is down enexpectedly.


Please give suggestion.

Answer 1

Refer this link,

 

http://www.c-sharpcorner.com/blogs/dynamic-menu-in-wpf122 

Answer 2

ViewModel

-------------------- 

public class MenuItemViewModel

{

public MenuItemViewModel()

{

this.MenuItems = new List<MenuItemViewModel>();

}

public string Text { get; set; }

public IList<MenuItemViewModel> MenuItems { get; private set; }

}

 

XAML Code

----------------------- 

<Window.Resources>

<HierarchicalDataTemplate DataType="{x:Type self:MenuItemViewModel}"

ItemsSource="{Binding Path=MenuItems}">

<ContentPresenter Content="{Binding Path=Text}" />

</HierarchicalDataTemplate>

</Window.Resources>

<DockPanel>

<Menu DockPanel.Dock="Top" ItemsSource="{Binding Path=MenuItems}" />

<Grid />

</DockPanel>