Guru E. Technology

need of every business.

How to Get Unique Item with Latest Date of Entry

Situation is, I have a table which contains multiple records of a item but with different date. For example, I have table of workers which contains the Id, Name, WorkingDay column similar to below table: ID NAME WorkingDay 1 VJ 15-Mar-2012 2 AP 15-Mar-2012 3 TS 15-Mar-2012 1 VJ 16-Mar-2012 2 AP 17-Mar-2012 I want […]

No Comments

How to Update a Column Value from Another Table

While working with SQL Table and queries most of the time we have to face this scenario to create or update a table with another table values. So I am going to demonstrate a simple example here. I have a table1 which has following structure. ID | Name | State =================== 1 | Ap | […]

No Comments

How to Load XML file into SQL Temporary Table

Well, this is very interesting! We can load complete XML file into SQL table and Add/Update records for the table. It was not easy earlier as it seems to be iterating all the nodes picked the value and then insert into table hu! really tough Job. I will explain you how you can load XML […]

No Comments

Bind Combo-Box Control with IList – Simple Example

Data binding for the WPF controls same as the WF controls little bit difference with binding option. //Code behind. //Create IList for the object. IList listObject = new List(); //Add item to IList. ObjectList item = new ObjectList(); item.Name = “A”; item.Value = 1; listObject.Add(item); //Bind IList to control. cmbControlName.ItemsSource = listObject; cmbControlName.DisplayMemberPath = “Name”; […]


How to Copy Entire DataTable Row to Another DataTable?

Whenever we do play with the DataSet or DataTable.  We always need solution to copy entire row from one table to another table. It’s very easy in another way by creating new object of data table and set each column value from another row column. I wondered if both objects (data rows) have same set […]

No Comments

How to Get Virtual Path?

When we work with ASP.Net application with Visual Studio, you will note that when you run  your application it will use the folder name with the server name ie(http://localhost/Webapplicationname/) and then the file which you are executing in the address bar of your browser. I think every developer face this issue when he try to […]

No Comments

Evolution of Latest Technology

The word “technology” is the study of tools and techniques. This term refers to everything that can be said several specific historical period son the state of the art in all areas of life skills and use of tools. It thus includes art, craft, crafts, applied science and possibly knowledge. By extension it can also […]

No Comments

Important Phases of Software Development

We’re living within twenty-first hundred years and close to us each and every things quickly change. Usually we pay attention that right now train, coach, car, mailbox, banking as well as attendance program etc. operating as computerize. Normally everybody trusts about the automated program because this particular work in accordance predefines functions and provide result […]

No Comments

Mobile Apps Development Life Cycle

Mobile technology has been able to keep people connected since many years now from the pagers to the recent smart phones. These days, companies are pressured to get out of the desktop perspective and also the cloud to obtain a place in a far more personal space of the customer through the mobile. Most marketers […]


Why Website Designing is Essential for the Business?

Web site plays a significant role in the present market and so it is essential on the part of every business to design a website so that they can easily reach the target customers and improve their sales revenue. There are numerous internet sites available which gives importance to cool photos and wait for extravagant […]

1 Comment