Monday, October 17, 2011

WPF Common Programming

ListView Binding:

 <ListView Height="182" HorizontalAlignment="Left"  
  Name="foodSaleslistView" VerticalAlignment="Top"  
 Width="503" BorderBrush="#00981010" Margin="2,1,0,0">  
           <GridViewColumn DisplayMemberBinding="{Binding Path=FoodName}" Header="Food name" Width="250" />  
               <GridViewColumn DisplayMemberBinding="{Binding Path=Qty}" Header="Quantity" Width="100" />  
               <GridViewColumn DisplayMemberBinding="{Binding Path=TotalPrice}" Header="Total price" Width="150" />  

Get Data From ListView:

  for (int i = 0; i < headlistView.Items.Count; i++)  
         EStock anStock = headlistView.Items[i] as EStock;  
         if (i==0)  
           anStock.Qty = Convert.ToInt32(textBox1.Text);  
         else if (i == 1)  
           anStock.Qty = Convert.ToInt32(textBox2.Text);  
           anStock.Qty = Convert.ToInt32(textBox3.Text);  

Load ListView:

       foreach (EStock stock in stockManagerObj.GetAllHeadofficeStock())  

LINQ GetAll From Table:

  List<EStock> headList = new List<EStock>();  
       var queery = from head in dataContex.HeadStocks  
             select new {head.TrNo, head.ItemCode, head.ItemName, head.Qty};  
       foreach (var hOffice in queery)  
         EStock eStock = new EStock();  
         eStock.Tr_No = hOffice.TrNo;  
         eStock.ItemCode = hOffice.ItemCode;  
         eStock.ItemName = hOffice.ItemName;  
         eStock.Qty = (int) hOffice.Qty;  
       return headList;  

LINQ Does Exist:

  internal bool DoesExist(EStock anStock)  
       return (dataContex.BranchStocks.Any(o => o.ItemCode.Contains(anStock.ItemCode) && o.TrNo.Contains(anStock.Tr_No)));  

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link.