Skip to main content

Posts

Showing posts from October, 2011

WPF ComboBox Last item should be selected

If we want that our comboBox will select the last item, in combobox loading time then you can use   private void LoadComboBo()         {             comboBox1.Items.Add("Atik");             comboBox1.Items.Add("Amin");             comboBox1.Items.Add("Nabab");             comboBox1.Items.Add("Refat");             comboBox1.SelectedIndex = comboBox1.Items.Count - 1;         }

C# LINQ INSERT,UPDATE, DELETE, DOES EXIST statement

There is no doubt "LINQ" is much more smart that other. In our development we face complex transaction or logical query for our application. Hare is some common LINQ opration. It is important that your all table should be present in dbml file.  Hare PRODUCT_NAME is the table name, In which i will perform All LINQ operation.  Product is the class name which will contain data.  table should contain a Primary Key. LINQ INSERT: public void SaveNewProductName(Product aProduct) { var newProductName = new PRODUCT_NAME { NAME = aProduct.ProductName }; dataContexObj.PRODUCT_NAMEs.InsertOnSubmit(newProductName); dataContexObj.SubmitChanges(); } LINQ DOESEXIST: public bool DoesExistProductName(Product aProduct) { return (dataContexObj.PRODUCT_NAMEs.Any(o => o.NAME.Contains(aProduct.ProductName))); } LINQ UPDATE: public void Upda

How to use code in blogspot

 You can easily use your code spinet in your blog. Follow the link: http://codeformatter.blogspot.com/2009/06/about-code-formatter.html#comment-form Hare it is important You have paste your formatted code on your  Blog in  edit HTML view. Enjoy...

WPF DataGrid Cell Color Change

DataGrid's ROW & CELL color Changing is one of most important part in our development. if you want to change Data grid specific cell Background just like: use the xaml code for "Remaining Day" column in your Datagrid. <DataGridTemplateColumn Header="Remaining Day" Width="150"> <DataGridTemplateColumn.CellTemplate> <DataTemplate> <Border x:Name="brdBroder" VerticalAlignment="Stretch" Margin="1"> <TextBlock Text="{Binding RemainLeave}" Margin="3,1" x:Name="txtTextBlock"/> </Border> <DataTemplate.Triggers> <DataTrigger Binding="{Binding RemainLeave}" Value="0"> <Setter TargetName="brdBroder" Property="Background&qu

C# LINQ Search between date

The SQL BETWEEN operator we can use in C# code. Before your query you have to use System.Globalization.CultureInfo culInfo = new System.Globalization.CultureInfo("en-US");   Consider the Example: internal List<ECalendarSetup> GetCalenderInfoOnSelectedDate(ECalendarSetup calendarSetup) { ieclHrmDataContext = new IECL_HRMDataContext(); List<ECalendarSetup> calendarSetupsList = new List<ECalendarSetup>(); var query = from j in ieclHrmDataContext.HR_CALENDAR_INFOs where j.CAL_DAY_DATE >= calendarSetup.FromDate && j.CAL_DAY_DATE <= calendarSetup.ToDate select j; foreach (var calendarInfo in query) { ECalendarSetup eCalendarSetup = new ECalendarSetup(); eCalendarSetup.Date = (DateTime) calendarInfo.CAL_DAY_DATE; eCalendarSetup.DayStatus = calendarInfo.CAL_DAY_STATUS;

C# string split & LINQ operation

Spliting string in C# is one of the most interesting part. you can also perform your business logic operation on spliting part. Hare is a list of serial no comes from database, i split the Serial no then just increment id no +1 on maximum serial no, and return to UI. i also check hare is the serial no is in current year. internal string GetNewSerialNo() { string refence = ""; DateTime dt = DateTime.Now; List<RFQ> _listAllRef =new List<RFQ>(); foreach (var objrfq in rfqDalObj.GetNewSerialNo()) { string[] splitedRef = (objrfq.SerialNO).Split('-'); if(DateTime.Now.Year.ToString()==splitedRef[1]) { _listAllRef.Add(objrfq); } } List<int> rfqSerials = new List<int>(); if (_listAllRef.Count > 0) { foreach (var obj in _listAllRef) { string[] splitedRef = (obj.Serial

WPF Common Programming

ListView Binding: <ListView Height="182" HorizontalAlignment="Left" Name="foodSaleslistView" VerticalAlignment="Top" Width="503" BorderBrush="#00981010" Margin="2,1,0,0"> <ListView.View> <GridView> <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" /> </GridView> </ListView.View> </ListView> Get Data From ListView: for (int i = 0; i < headlistView.Items.Count; i++) { EStock anStock = headlistView.Items[i] as ES

WPF 4 Updated Information

There is many new functionality added in WPF 4 Like Visual tree,State Manager,VSM, Touch & manioulation, Graphics & Animation and much more.  By the following Link You can get idea: http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/d3d6b7ec-71f9-4011-afc5-0bf3956e6d78#x__Toc265507378 Enjoy.

WPF Datagrid cell {X,Y} coordinate value

Some time we need to find the datagrid selected cell's coordinate value. like You can easily find our your selected cell value. Please follow this link for more details.   http://www.scottlogic.co.uk/blog/colin/2008/12/wpf-datagrid-detecting-clicked-cell-and-row/ Enjoy..