Tuesday, May 29, 2012

How to get WPF datagrid cell value

We can easily get the value of a WPF datagrid cell value using cast with the class. in which class the data grid is   bind. consider the code




 private void GetTotalGBP()  
     {  
       decimal dr = 0, cr = 0;  
      for (int i = 0; i < receiveInvoiceDataGrid.Items.Count; i++)  
        {  
          ReceiveInvoice obj = receiveInvoiceDataGrid.Items[i] as ReceiveInvoice;  
          TGBP += Convert.ToDecimal(obj.NetValue); // getting cell value  
          TQTY += Convert.ToDecimal(obj.ConfirmOrderQty); // getting cell value  
        }  
       totalGBPTextbox.Text = TGBP .ToString("F");  
       totalQtyTextBox.Text = TQTY .ToString("F");  
     }  



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...