Sunday, 26 February 2012

Querying from Dataset


  var qry = from packing in sp_ds.Tables[8].AsEnumerable()
                          where packing.Field<string>("pack_id") == global.prod_mastList[0].Last_pack_id.Trim()
                          select packing;
                if (qry.Count() >= 1)
                {
                    DataTable dt = qry.CopyToDataTable();
                    txtlast_Packing.Text = dt.Rows[0][2].ToString();
                }              

sending TAB key in WPF


 public static void Enter_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.Key == Key.Enter)
            {
                e.Handled = true;
                KeyEventArgs eInsertBack = new KeyEventArgs(Keyboard.PrimaryDevice, Keyboard.PrimaryDevice.ActiveSource, 0, Key.Tab);
                eInsertBack.RoutedEvent = UIElement.KeyDownEvent;
                InputManager.Current.ProcessInput(eInsertBack);
            }
        }

Sunday, 27 November 2011

how to sum a column in datatable

If untyped (replace int with the correct data type):
 var sum = table.AsEnumerable().Sum(x=>x.Field<int>(3));
or:
 var sum = table.AsEnumerable().Sum(x=>x.Field<int>("SomeProperty"));
If typed:
 var sum = table.Sum(x=>x.SomeProperty);

Wednesday, 9 November 2011

Sending Key or simulation Key press

 if (e.Key == Key.Down)
        {
            e.Handled = true;
            KeyEventArgs eInsertBack = new KeyEventArgs(Keyboard.PrimaryDevice, 
 Keyboard.PrimaryDevice.ActiveSource, 0, Key.Tab);
            eInsertBack.RoutedEvent = UIElement.KeyDownEvent;
            InputManager.Current.ProcessInput(eInsertBack);
        }

Tab order not working in WPF

<TabControl TabIndex="4" KeyboardNavigation.TabNavigation="Local">

Tuesday, 8 November 2011

How to run WPF - XBAP as Full Trust Application

How to run WPF - XBAP as Full Trust Application

Recently I work on WPF-XBAP application that will run from intranet website: