Wednesday, December 26, 2012

silverlight hyperlink button image in datagrid column

In tool hyperlink image button in silverlight datagrid we can set property, command like other control.
the binding of the datagrid column is:


  <sdk:DataGridTemplateColumn Header="Buyer Comments" Width="2*">  
             <sdk:DataGridTemplateColumn.CellTemplate>  
               <DataTemplate>  
                 <StackPanel Orientation="Horizontal">  
                   <HyperlinkButton Content="" Width="30" Command="{Binding Source={StaticResource srConfirm}, Path=ShowComments}"   
                            CommandParameter="{Binding}" ToolTipService.ToolTip="{Binding Path=Comments}">  
                     <HyperlinkButton.Background>  
                       <ImageBrush ImageSource="/images/Icons/add.png" Stretch="Uniform" />  
                     </HyperlinkButton.Background>  
                   </HyperlinkButton>  
                 </StackPanel>  
               </DataTemplate>  
             </sdk:DataGridTemplateColumn.CellTemplate>  
           </sdk:DataGridTemplateColumn>  

here srConfirm is the Viewmodel of the window which i defined in cs.

     private VMEditReceiveBuyerComment _dataContext = null;  
     public EditBuyerCommentReceival()  
     {  
       _dataContext = new VMEditReceiveBuyerComment();  
                this.Resources.Add("srConfirm", _dataContext);  
       InitializeComponent();  
       this.DataContext = _dataContext;  
     }  

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...