Wednesday, 23 November 2011

Progress Dialog


import android.app.Activity;

import android.app.ProgressDialog;

import android.content.pm.ActivityInfo;

import android.os.Bundle;


public class ProgressDialogActivity extends Activity {

/** Called when the activity is first created. */

ProgressDialog pro;

@Override

public void onCreate(Bundle savedInstanceState)

{

super.onCreate(savedInstanceState);

setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_USER);

setContentView(R.layout.main);

pro=new ProgressDialog(this);

pro.setProgressStyle(ProgressDialog.STYLE_HORIZONTAL);

pro.setMax(300);

pro.setCancelable(true);

pro.setMessage("Loading data..");

pro.show();

Threadex t=new Threadex();

t.start(); //start thread

}//This is Oncreate method

class Threadex extends Thread

{


public void run()

{

for(int i=10;i<=pro.getMax();i=i+10)

{

pro.incrementProgressBy(10);

try

{

sleep(1000); //sleep for 1 seconds

}

catch(Exception e)

{

e.printStackTrace();

}

} //this is for loop ends

pro.dismiss();

} //this is end of Run

}//This is End of Threadex

} //This is End of Activity


Here Update the 10 distance continues Upto 300 distance because we have set 300 distance as max .




This is after the Dismiss the ProgressDialog





This is for ProgressDialog.STYLE_HORIZONTAL.

we can set Another Style ProgressDialog.STYLE_SPINNER but view is different

Monday, 14 November 2011

Getting SMS in your Activity

import android.app.Activity;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.widget.TextView;

public class SMSActivity extends Activity
{
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
TextView textview = new TextView(this);
Uri url = Uri.parse("content://sms/inbox");
Cursor cursor = getContentResolver().query(url, null, null, null,null);
String smsdisplay = "";
while (cursor.moveToNext()) {
smsdisplay += "From :" + cursor.getString(2) + " : " + cursor.getString(11)+"\n";
}
textview.setText(smsdisplay);
setContentView(textview);
}
}

in the AndroidManifest.xml

android.permission.READ_SMS

Gives this Permission for Reading SMS in your activity.




Tuesday, 12 July 2011

ViewBag v/s ViewData


Hi Friends,
If you go through ASP.NET MVC 3.0 framework then you will find  two frequently  used collection of data object which  used to pass data between control and views  and partial views. as both are doing similar functionality but has  some difference in that , so today , I would like to  put some difference of those and interoperability of that .



ViewData
ViewBag
It is dictionary of name/value pair  collection
It is dynamic  type object
This features exist since 1st release of ASP.NET MVC
This features available from ASP.NET MVC 3.0
This will work  in ASP.NET with .net 3.5 framework and above
This will work well with ASP.NET 4.0  with .net 4.0 framework and above
ViewData is faster compare to ViewBag   
ViewBag is slower than ViewData
While retrieving  data from viewData in to view pages , one need to do proper type casting
While retrieving  data from viewbag in to view pages , one need  not to do  type casting
Hence it make code with lots of  type casting  fragments
Hence it make more clear code

Friday, 8 July 2011

Checklist for Validation messages



The following are the Validation/Messages to be checked commonly while executing Add/Edit and Search Page in any applications
ADD
1. Check for Page Title. It should be “Add a/an in
2. Check for Page Heading. It should be “Add
3. Check for the presence of Header & Footer contents.
4. Check for the Labels i.e Field name are meaning full and not having any spelling mistakes.
5. Check for the Mandatory Fields are differentiated by Red color or by red * symbol.
6. Check whether the cursor points to the first field.
7. Check whether the Tab Order is correct.
8. Check whether the required field validations are done in user side JavaScript and also in server side.
a. Check whether Starting and Ending spaces are getting trimmed.

The Changing Paradigm of Testing Industry

Software testing was an important turning point in the IT industry. It has changed the face of the software world today. In today's world, consumer expectations are very high on quality. They want customized access from anywhere, anytime, through any device and within no time and with no glitches. Satisfying such consumer needs and expectations of high quality were only possible by immense software testing. Testing has optimized software business products and has lessened the complexities faced by software developers. It has helped improve the overall software development life cycle.

Opening the event with a keynote session, Arun Kumar Singh, Vice President and Global Head Testing ,Financial Services, Wipro, threw some light on the importance of testing in today's business and tried to forecast where testing will go in years ahead. He spoke about 1.0, 2.0 and 3.0 phases of software testing.

How to decompile Android application to get sourcecode

Hi Friends,
reverse engineering is everywhere. but reverse engineering is meant for  code review of  vulnerable application. so I hope you guys will not  use this reverse engineering  tricks to do any illegal things.
all android application are running  on Dalvik , which is a Virtual Machine having register-base  architecture and different from Java Virtual Machine by sun-microsystem (and now by oracle ) which is stack machine.
hence all android application is consist of Dalvik Executable (.dex).  hence to convert those  android application( *.apk) to source code we have to follow below steps

(Note : apk is packing of  .dex  file and other resources.)

step to decompile

1) convert  .dex file format to  .class file
2) convert  .class file format to  java code file

1) android application will come with .apk file format. which contains  .dex file .
hence  to convert .dex file in to .class file ( and those compress .class files  are placed in .jar file)
one need to have .dex  to  .class file converter .(both are binary format)
you can download such  tool from below link.


 after downloading you need to extract them and it will have following files in you  file system.




















Sunday, 3 July 2011

How to prevent from Cross-site scripting attacks on your ASP.NET website?


Hi friends,
Security is major concern for our clients when they ask us to develop their website. Hence we have to take care of  attacks like sql injection and cross-site scripting attacks.
today I come across with a very good library to  prevent our website against cross-site scripting attacks.
Cross-site scripting (which  also called as XSS) attacks occur when an attacker uses a web apps to inject malicious code(mainly scripting), generally in the form of a browser side (means java script injection ), to a different visitor or your site.

Friday, 1 July 2011

How to compress our websites..!!??


Hi friends,
when you have website which has heavy  pages( means all page are loaded with lots of html and css etc...) .It is recommended to compress your website pages while serving. This will decrease your network traffic at your server. To achieve such compression of your website pages while delivering to browser  is done by two way.
 1) By server  setting
 2) do custom coding  in your web application

Wednesday, 29 June 2011

Advantages of QTP

1) Support for record and playback and ability to edit scripts after recording. Also different recording modes are provided in QTP viz.

2) Support for different addins like Java, Oracle, SAP, .NET, Web Forms, Siebel, PeopleSoft, Web services, Main frame.

3) Ability to let you enhance the existing tests even without the AUT (Application under test) through active screen.

4) QTP uses VBScript which is English-like and very easy to learn and gain expertise. We have plenty of resource available to learn VBScripts.

5) Microsoft Object model can be implanted in QTP easily. Like, Word document object, Excel Object, Outlook Object, ADO objects, File system objects.

6) It comes with loads of inbuilt properties and methods in QTP as well as inbuilt functions in VBScripts

7) Support for XML.

8) Use of Datatables/Excel files are easier and provides a variety of methods to play around with rows and columns.

9) Test reporting with all necessary details for analysis is provided.

When your client will concern about his db password


Hi friends,

When you get a client who is more technical ,then it accentuate on safety of his critical data. Recently I faced such type of client. When my client went through publish asp.net project on server and he found that our db password inside  web.config ‘s connection string , and  expressed his concern for  it safety of db password. so   he suggested me not to  placed in web.config moreover he asked me to  hardcoded that password in my asp.net code and obfuscate that dll..!!.

Tuesday, 28 June 2011

Accelerate Downloads In Chrome & IE With FileServe Manager

FileServe Manager is a free download management application which is designed to optimize your system resources and to provide you with accelerated download speed. It is much similar to the widely used Orbit downloader and supports downloading files from Windows clipboard, resumption of broken downloads, provision for managing downloads by means of adjusting speed limit, and download scheduling.
FileServe Manager can also be integrated into both Chrome and Internet Explorer, letting you download files directly from the web without having to copy and paste source URL to begin downloading process. Unlike Orbit, it automatically moves downloads into convenient categories according to file types. You will, for instance, be able access all the downloaded apps, photos, and audio files from Software, Picture, and Music categories. Other than serving as a download manager, it also has an uploading utility to instantly save and access your files to and from the cloud. If you have your download URLs stored in a text file, you can append them in its Batch download window to start downloading all the items in one go.


Sort C# Code Structure In Visual Studio 2010 With CodeSorter

One of the most tiring task you might have to perform over source code files everyday is code sorting. Since there aren’t any set conditions which one can instantly apply over source code file to make it look tidy and clean, users have to manually sort the code structure according to their requirements. If you’re looking for a relatively easy way to sort your C# code in Visual Studio 2010, you can try out CodeSorter to specify code sorting conditions, so that they can be applied with a single click over all the code files. The add-in only works with C# project files and may disturb code structure of other languages. The add-in has a host of different code sorting conditions which can be customized in numerous ways. It was developed to sort source code files by different conditions such as, names, types; including, class, struct, method, virtual modifiers; virtual overide, new, etc.


Create Android Apps For Your Favorite Websites In Just A Few Clicks!


Disappointed that your favorite website does not have a mobile web variant? Looking for a way to create an app for your own website without having to learn how to code? Look no further. AppYet is a web service that allows you to create, in just a few clicks, reasonably feature-rich and presentable Android RSS feed readers for websites of your choice.


Google’s Plans For Web Spam in 2011

We all get junk in our inboxes, through our letterboxes and you may or may not have noticed that you get spam in search results too. This is as a result of websites tricking the search engines so that they rank higher in results.

Google have commented on their plans for spam in 2011:


"…We’re evaluating multiple changes that should help drive spam levels even lower…


…We'll continue to explore ways to reduce spam, including new ways for users to give more explicit feedback about spammy and low-quality sites."

So fingers crossed we’ll see less spam, at least in Google!

Follow these simple tips to ensure that your website won’t be affected by Google’s changes:

Publish unique content only
Use ethical SEO techniques
Publish good quality content

If you’re at all worried about the quality of your website and how Google might view it, then contact us and we’ll help you out.

What Type Of Website Would Best Suit Your Business?

Today there are many different types of websites to choose from when considering updating your existing website or starting a brand new one. To help you get started here's a list of the main types:

eCommerce: you'll need this kind of website if you'd like to have a shopping cart so that visitors can purchase online. Here's an example of an e-commerce website that Matrix built: www.soul-shoes.co.उक

Bespoke: important if you'd like a totally unique site that stands out, you can specify every last detail you'd like to see on the website. Here's an example of a bespoke website that Matrix built: www.barbicantheatre.co.उक

Template: a cheaper option based on an existing template that's populated with your content, images and colours. Here's an example of a Matrix-built template website: www.eagle-smt.कॉम

Content Management System (CMS): this will allow you to take the reins and update and change your website yourself. Depending on your CMS you can create new pages, add new products, change images and text and much more! Here's an example of a website that Matrix built with CMS functionality: www.devonfurniture.co.uk

Hopefully the above will help you to understand the different types of websites you can choose for your business. If you're still none-the-wiser then give us a call and we'll be happy to help.

Monday, 27 June 2011

Atom v/s RSS


Hi friends,
  to follow's  our favorite blogs or websites, usually we subscribe Atom or RSS feed  provided by those blogs or  websites. so one should  know the difference  and similarity between them

Forget '.com', are you ready for '.google', or '.bank'?

Think of it as a cyberspace land rush, as companies and others try to stake claims to websites ending with names like ".bank"

Come next year, an era when site names ended in a handful of predictable ways like ".com" or ".gov" draws to a close. ICANN, which stands for the Internet Corporation for Assigned Names and Numbers, says it will accept applications for domains with new suffixes that could range from corporate names (like ".Apple" or ".Sony") to more generic terms (like ".bank" or ".supermarket").

Don't expect that all those ".com" sites will simply fade away, or that every celebrity will start a site with a name like "Lady.Gaga." Some pop stars may try to do that, but ICANN has made the process of launching a new suffix cumbersome and costly, to put some limits on the proliferation of web suffixes.

What's certain, though, is that companies and other entities will now be thinking hard about the new "your-name-here" opportunity. And on the flip side, they'll be pondering the potential risks of not joining the stampede.

Web experts have said that ICANN’s proposals, to essentially open up a new online market-place, where new addresses are available for those brands and individuals who have lost their identity online in the first and second wave of the web, could be significant.

It will cost £162,000 to apply, and individuals or organizations will be asked to show a legitimate claim to the name they are buying.

Credit: Material from the Telegraph and Wire Services were used in this article.

What is Graphic Design?

Suppose you want to announce or sell something, amuse or persuade someone, explain a complicated system or demonstrate a process. In other words, you have a message you want to communicate. How do you “send” it? You could tell people one by one or broadcast by radio or loudspeaker. That's verbal communication. But if you use any visual medium at all-if you make a poster; type a letter; create a business logo, a magazine ad, or an album cover; even make a computer printout-you are using a form of visual communication called graphic design.

Graphic designers work with drawn, painted, photographed, or computer-generated images (pictures), but they also design the letterforms that make up various typefaces found in movie credits and TV ads; in books, magazines, and menus; and even on computer screens. Designers create, choose, and organize these elements-typography, images, and the so-called “white space” around them-to communicate a message. Graphic design is a part of your daily life. From humble things like gum wrappers to huge things like billboards to the T-shirt you're wearing, graphic design informs, persuades, organizes, stimulates, locates, identifies, attracts attention and provides pleasure.

Graphic design is a creative process that combines art and technology to communicate ideas. The designer works with a variety of communication tools in order to convey a message from a client to a particular audience. The main tools are image and typography.


Basics to start an e-Commerce website



1. Web Hosting Service – A hosting server gives your website a place to reside on the Internet; without a hosting service, visitors cannot access your website. Most hosting services are available for a nominal monthly fee. Make sure the hosting service is compatible with your shopping cart software.

2. Website – Once you have place for your website online, next is the website itself. There are a myriad of available options when it comes to creating your website. If you already have an existing website, you can integrate e-commerce capabilities. If you are building the website from scratch, there are a handful of software programs that can help you build a website with no HTML skills or you can have your site designed by a website design professional or firm (typically the most expensive alternative).

Saturday, 25 June 2011

Customized Android ROM Build


Dear Friends,
Android is booming in mobile market now days. And you will find varieties of mobile device with android OS. Moreover it is open source OS, so one can customize this Android OS for targeting any OEM’s device. By customizing the Android, one can add or subtract some features to OS which may not be provided or disable by OEM of that particular mobile device.

Friday, 24 June 2011

A Complete URL Rewriting Solution for ASP.NET 2.0

This article uses regular expressions to specify rewriting rules and resolves possible difficulties with postback from pages accessed via virtual URLs.

Why use URL rewriting?

The two main reasons to incorporate URL rewriting capabilities into your ASP.NET applications are usability and maintainability.


Apple Vs. Microsoft The History Of Computing (Infographic)

Inforgraphic are the the best learning concepts in modern Internet world.
Look out for infographics for learning.

I am sharing wonderful infographic of two Software Giants history and present.




Image By Manolution – The Blog for Men

Thursday, 23 June 2011

EB algorithm for Azure Database connection


Hi Friends,
As cloud computing  buzzing now days, so I spend my spare time to do some hand-on code for Window Azure using trial pass and reading related blogs for that
  Then during  my hand-on , once I face the problem of frequent connection failure due to  my Azure db was unavailable for few mins .

Neowin - Nokia Window Phone 7.1 (Mango)

Nokia CEO Stephen Elop have unveiled the Nokia’s first Windows Phone device during an internal company meeting earlier this week. According to Neowin “Elop mentions that the device is “super confidential” and that the company doesn’t want to see it out in the blogosphere. “Beautiful design, gorilla glass, pillow shaped backing, carl ziess 8MP camera,” says Elop.
The product is Nokia’s first Windows Phone device and will be available later this year when the company releases a batch of Windows Phone Mango devices.”

SQL Server CE

XLSExport: A CLR procedure to export proc results to Excel


Introduction

NPOI is a .NET project which can read and write read/write xls, doc, and ppt files without the need for a Microsoft Office installation or license. Formerly on CodePlex, the project is now located on Googlecode at http://code.google.com/p/npoi/.
In this CLR example, I'll use NPOI to create a procedure that takes a stored procedure name and list of parameters and parameter values for that procedure, and outputs an Excel spreadsheet that contains the execution results of that proc to the passed .XLS file specification. The advantage to a CLR solution is that (in addition to lacking an MS Office install or license requirement) ActiveX and COM components are not required on your otherwise pristine SQL Server to accomplish this task.
This procedure supports output data types of CHAR, NCHAR, VARCHAR, NVARCHAR, all numerics, DATE, TIME, DATETIME, DATETIME2, BIT, and BOOLEAN. Other datatype outputs are not currently supported, but are

Process Of Web Development Project

Every designer or company will develop unique components to their web design process over time, but the basics remain the same: learn, plan, design, code and launch...


How does Offshore Outsourcing Model work for the software development?

Last week I have received this inquisitive question from one of my team members.  So I thought of sharing my personal experience as of now how our team works in Hi-Tech ITO.
  • We have marketing team who gets prospect list, client meeting, web research etc.
  • Pre-sale team works on chunk lists like from SEO, direct calling, existing client list which can be the prospects for the software development, IT trade fair like CeBIT, reference from the existing client, bidding portal, consultant companies and social media etc.
  • This team gets the broad level requirement specification in form of email or document. 
  • While this is in process, they provide information about Hi-Tech and the various services it currently offers and details about our development expertise etc. are shared with the prospect.
  • Inquiry gets allocated to respective project manager or Business Analyst depending upon their availability for performing the impact analysis and finalizing effort estimates
  • We sign strict NDA to give them assurance about the privacy of the project information

GameSalad unleashes HTML5 game creator — no coding required







Game development tool-maker GameSalad announced it is releasing a suite of applications that will let game developers create a game for HTML5-powered browsers.
The company sells a suite of tools that let game developers create games with a drag-and-drop user interface. It makes it easy for users to develop their own games even if they don’t know any programming languages. It removes the barrier to entry for developing games for the iPhone, Android-powered mobile devices and now web browsers. HTML5 also works on most mobile browsers, eliminating the need to create a specific app for each mobile operating system.

Extention method for IComparable


Hi friends,
 C# 3.0 gives great feature of extension method. so i keep playing with this. today  I would like to show you something interesting way to use that extension method. This time it's extending IComparable<T>. The API signature for IComparable<T> has been around since the birth of  C language . If the left is less than the right, return something less than 0, if left is greater than right, return something greater than 0, and if they are equivalent, return 0. Well, its readability leaves a bit to be desired.

Wednesday, 22 June 2011

Motivating QA Team

Job satisfaction among QA professionals has been traditionally low when compared with their development peers and with those in other departments. Why? External misconceptions that are out there such as “anybody can do QA”, “hire some out of school kids to test our applications”, or “QA folks are in reality ‘developer wannabees’, can really have an impact on your team’s morale.
We will take a closer look at some common QA miss-perceptions, reason why they are wrong, and gives you some specific follow-up action items that you could act upon to keep and maintain a motivated staff.
Myth #1: Anybody can do QA
Wrong. Testing is a skilled activity that requires the ability to think, explore and follow logic while questioning and reasoning at the same time. It is based on the philosophy of performing a technical investigation of a product, to provide information and report back to various stakeholders throughout the organization. And to achieve

Tuesday, 21 June 2011

Windows Phone 7.5 Mango hands-on preview

Last week Microsoft presented me with a Samsung Focus smartphone that was running a recent pre-release build of Windows Phone "Mango." Mango is the version of the OS that will replace Windows Phone 7, which launched last year.



Microsoft will release its first major update for Windows Phone, bringing more than 500 new features to the OS. Known up till now as Mango, the update will formally go by the name of Windows Phone 7.5 and focuses on improving three key areas: Communications, apps, and Internet.
I found some great features windows 7.5 (Mango) which are listed as per bellow.

Are you a Novice Tester ???

To begin any career in any field brings a list of questions in your mind to become an expert in that. Novice testers have many questions about software testing and the actual work that they are going to perform. Certain tips can help in that to get the answers. These ‘testing truths’ are applicable to and helpful for experienced testing professionals as well.

Know Your Application

Don’t start testing without understanding the requirements. If you test without knowledge of the requirements, you will not be able to determine if a program is functioning as designed and you will not be able to tell if required functionality is missing. Clear knowledge of requirements, before starting testing, is a must for any tester.

Scheduling a SQL Server PowerShell script using the Task Scheduler

Problem

Even if your SQL Server edition does not include the SQL Server Agent service (if you use SQL Express, for instance), you can still automate administration tasks without using any 3rd party products. In this tip I'll describe how to schedule a PowerShell script with the Task Scheduler MMC snap-in. This applies to Windows 2008 Server, Windows 2008 Server R2 and Windows 7.

Solution

Following is the step by step process to setup Task Scheduler to run a PowerShell script. In this example I show how you can backup a database, but this can be applied to any SQL Server task you want to automate and have scheduled on a regular basis.
1. There are several ways to start the Task Scheduler, such as:
  • Go to Start ---> Control Panel ---> Administrative Tools ---> Task Scheduler
  • Go to Start ---> Run ---> Taskschd.msc
  • Go to the Configuration Node of the Server Manager (Windows Server 2008, 2008 R2) or to Computer Manager ---> System Tools (Windows 7 Pro) and click on Task Scheduler

SaaS, Web, Cloud and Mobile enablement of your C/S .NET (Windows Forms) application, is the most cost-effective decision you can make

Visual WebGui is the only technology that can do it. From desktop .NET (C#, VB.NET) into latest .NET based cross-platform HTML5 rich user-interface @ the shortest time to market and the lowest costs and risks.
VWG tool-based code migration tools are currently offered as a service; as a turn-key, or on a work sharing basis with the customers. It includes POC, prototyping, consulting, and "hand holding" support and professional services. The tools will be released in Q2 2011.

Metrics in Software Testing

Metrics for Evaluating Application System Testing:
Metric = Formula
Test overage = Number of units (KLOC/FP) tested / total size of the system. (LOC represents Lines of Code)
Number of tests per unit size = Number of test cases per KLOC/FP (LOC represents Lines of Code).
Acceptance criteria tested = Acceptance criteria tested / total acceptance criteria
Defects per size = Defects detected / system size
Test cost (in %) = Cost of testing / total cost *100
Cost to locate defect = Cost of testing / the number of defects located

Software Testing Standards - CMM

Capability Maturity model
-          It is a five level assessment model
-          Capability Maturity Model (CMM) broadly refers to a process improvement approach that is based on a process model. CMM also refers specifically to the first such model, developed by the Software Engineering Institute (SEI) in the mid-1980s, as well as the family of process models that followed.

Nokia N9 - Design, Social and Interaction


Hello Guys,

Nokia today announced N9, their new invention to compete with Smart Phone majors.
You can find more details on Nokia N9 - http://swipe.nokia.com/

I classify the device in to three major things , which are done beatifically in new Device.

how to make common control event for all child control of container

Hi friends
so time in my winform base project, I get scenario where one  to assign a click event handler to all child/dynamic Controls contained in a User Control. This is a good method but I found there was no proper docs for this.

Monday, 20 June 2011

Basic Object-Oriented Concepts

  • How People Understand Technology
  • How People Approach Object-Oriented Technology
  • Object-Oriented Terms and Concepts
    • Objects
    • Classes, Metaclasses, Parameterized Classes, and Exemplars
    • Black Boxes and Interfaces
    • Aggregation
    • Specialization and Inheritance
    • Abstract Classes
    • Operations
    • Constants
    • Exceptions
    • Object Coupling and Object Cohesion
    • Systems of Objects

Prepare Android Development Enviroment

Hi friends,
Google Android is booming platform on mobile and table device..,so,  many armature or beginner programmer need to know that how to setup a android development enviroment(ADE)  for that. 

Best part of Android is that, one can  setup ADE on any platform like Window, Mac or Linux or Unix. For ADE  following  chain toolkit are required

.NET coding standard part - 1

Hello friends, in coding practice there are some coding standards that we should follow to make code more readable and maintainable. I have compiled some coding standards that I have mentioned following.

Naming Conventions and Style

1. Use Pascal casing for type and method names and constants:

public class SomeClass
{
const int DefaultSize = 100;
public void SomeMethod()
{}
}

Server Side Pagination

The paging of a large database resultset in Web applications is a well known problem. In short, you don't want all the results from your query to be displayed on a single Web page, so some sort of paged display is more appropriate. While it was not an easy task in the old ASP, the DataGrid control in the ASP.NET simplifies this to a few lines of code. So, the paging is easy in ASP.NET, but the default behavior of the DataGrid is that all resulting records from your query will be fetched from SQL server to the ASP.NET application. If your query returns a million records this will cause some serious performance issues (if you need convincing, try executing such a query in your web application and see the memory consumption of the aspnet_wp.exe in the task manager). That's why a custom paging solution is required where desired behavior is to fetch only the rows from the current page.

Here I provide some query which provide solution for custom pagination. It helps to improve your search result for your filter data.

Code

One small step for an Employee, a giant leap for an Organization

Hello guys,

My first blogpost on Hi-Tech ITO blog, reminds me one of most famous line of last millenium.
"One small step for a man, a giant leap for mankind"

Yeah, for a company which focuses on Outsourcing Solutions, for them giving employees their own personal space via blog is really rare.

Hi-Tech Outsourcing again took wonderful step for their employees, now a team of excellent technical expertise post their routine problems which are likely faced by many others.
It is also an opportunity to groom employees writing skills and interpersonal skills.

As Operator in C#



The as operator is used to perform certain types of conversions between compatible reference types. "As" Operator is also known as a safe cast. What is does is it attempts to cast from one type to another and if the cast fails it returns null instead of throwing an InvalidCastException.


As-casting is equivalent to the following expression except that expression is evaluated only one time.

expression is type ? (type)expression : (type)null

NULLIF (Transact-SQL)


Yesterday I found one more function of sql server. NULLIF which returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression. NULLIF function is available from Sql Server 2005.



Syntax :



NULLIF ( expression , expression )



Example :



The following example creates a budgets table to show a department (dept) its current budget (current_year) and its previous budget (previous_year). For the current year, NULL is used for departments with budgets that have not changed from the previous year, and 0
is used for budgets that have not yet been determined. To find out the
average of only those departments that receive a budget and to include
the budget value from the previous year (use the previous_year value, where the current_year is NULL), combine the NULLIF and COALESCE functions.






ISNULLIF Example

Migrating From MySQL to SQL Server running PHP on IIS


In the following code, we connect to the MySQL server with mysql_connect() and then select the database with mysql_select_db() that we will work against.
MySQL PHP
MySQL Actor Table Viewer
$db_host = 'localhost';
$db_user = 'root';
$db_pwd = 'pass@word1';
$database = 'sakila';
$table = 'actor';
 
if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");
 
if (!mysql_select_db($database))
    die("Can't select database");
SQL Server PHP
With SQL Server PHP, the database context is established in one call to sqlsrv_connect() that returns a connection handle for running a queries.
SQL Server Actor Table Viewer
$db_host = '.\SQLEXPRESS';
$db_user = 'sa';   //recommend using a lower privileged user
$db_pwd = 'pass@word1';
$database = 'sakila';
$table = 'actor';
 
$connectionInfo = array("UID" => $db_user, "PWD" => $db_pwd, "Database"=>$database); 
$conn = sqlsrv_connect( $db_host, $connectionInfo);
if( !$conn )
{
     echo "Connection could not be established.\n";
     die( print_r( sqlsrv_errors(), true));
}

ASP.NET 4.0 Active MarkUp v/s Passive Markup


ASP.NET 4.0 gives us two main flavor of programming style. Active Markup and Passive Markup.
ohh..!! what is this new terminology Active Markup and Passive Mark Markup.. ?!!!. This term you never find on msdn or any Microsoft Evangelist's blog or book. this is new term coin by me for ASP.NET webform and ASP.NET MVC..