Software / Technology Tips

How to execute a query and stored procedure in Kentico CMS? Some of the cases we need some query and storedprocedure execution in our webparts for retirve some data for our requirement. For this cases we may use some functions present in the some dll which are already defined over there. Add following namespaces:- using…

In many cases, the requirement is to show an alert view with black appearance. In that case , we have to opt for a custom view that resembles with alert view. But I have a solution , instead of creating custom view, we can create a subclass of UIAlertView and using CGCgraphics we can modify it…

XML is a simple and flexible system for defining data formats. This is completely platform independent and adopted everywhere for representing complex documents and data structures. For data transmission on web, its having significant contribution. It is very common to use dataset in .NET applications. A dataset may contain a single table or multiple tables…

These are the follwing steps we need to follow to connect windows  phone with wcf service 1.Creation of service 2.Hosting the service in IIS 3.Connecting from the windows phone step 1: >> First we need to create a wcf service.and put it in the D drive.Lets name it as WinPhoneWcfService. For the connectivity to DataBase…

Tip 6: While we use IN, in the sql query it better to use one or more leading characters in the clause instead of using the wildcard character at the starting. SELECT * FROM CustomerTable WHERE CustomerName LIKE ‘m%’ SELECT * FROM CustomerTable WHERE CustomerName LIKE ‘%m’ In the first query the Query optimizer is…

This tip demonstrates how to sort generic lists in a much simpler way without writing  much complex loops and comparison logic. The following steps are required for sorting the list: 1. Create class for sorting and implement interface IComparable wheres Type will reflect class for comparison Ex:  public class Racer : IComparable 2. Add properties…

At times we need to add a page content to a email body. Also some time we need to call a api link to get the data. Here is a function which will help you to read the page content of a given link and return the data in an array. So that you can use…

DrillDownGroupLevel Definition- DrillDownGroupLevel is a system defined function in Crystal Reports ,that returns the current drill down level in the report that one is working upon. DrllDownGroupLevel can be used efficeintly and dynamically to achieve more interactivity and dynamism in a report. Returns-Number (drill down group number). Can be Used with:Formula Fields,Database fields,Text Fields. Not…

The Solution SELECT * FROM `tablename`  WHERE  `id_record` IN (1,2,3,4,5,6,7,8,9,10,11) ORDER BY FIELD (`id_record`,5,4,6,3,2,1,7,9,8,10,11 ) As you can see from the code above ,we are using one more MySQL keyword called FIELD and inside the bracket we are passing the first parameter as the field name `id_record.`You can then order the records in the resultset. Note : Do…

Introduction- The major aim of C# 4.0 is dynamic programming.More importantly objects are dynamic and there behaviour and properties are not accessed by a static type. Followings are some example – 1. objects from dynamic programming languages 2. ordinary .NET types accessed through reflection 3. objects with changing structure, such as HTML DOM script objects…