Sukesh Marla

Technical Training at reasonable price

2013-12-22T23:56:00.000-08:00

For technical training on various topics including asp.net,WCF,MVC and Design Patterns contact SukeshMarla@Gmail.com

Visual studio 2012 tweaks

2013-01-22T19:39:00.000-08:00

Introduction

In this article I will point out some not very great but somewhat useful tweaks comes up with Visual Studio 2012

Single Click Preview

One of the most annoying features I found after migrating from VS 2010 to VS 2012 is, Single Click Preview.

For me it’s quite frustrating, each time I accidently click and file in solution explorer, preview get shown.
Reason might be I was very used to VS 2010 environment, most people may like it. But I wanted to remove it and found the tweak for the same.
Go to Tools > options > Tabs and Windows

Where is design view in ASP.NET

I am an ASP.NET developer from quite long time and I pretty much enjoy writing aspx markup than using design view. But couple of days before I noticed, there is no design view anymore (which was there in visual studio 2005 and 2008, not sure about 2010). I am not interested in design view even now, but curiosity forced me to find the way to get it back. And I find the tweak  Go to Tools > options > HTML Designer

Multiple themes in Visual studio

(Frankly I like the default light theme, dark theme is indeed very dark)

Upper Case Menus

Do anybody notice all Menus in visual studio shown in capital letter.

Funny isn’t it, Add following registry key if you don’t like it.
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\11.0\General DWORD: SuppressUppercaseConversion Value: 1

Hope all of you enjoyed reading this article. Thank you for the patience.
For technical training related to various topics including ASP.NET, Design Patterns, WCF and MVC contact SukeshMarla@Gmail.com
For more stuff like this click here. Subscribe to article updates.

Naming Conventions

2012-12-09T10:52:00.000-08:00

Introduction

This is one of the series of articles “Coding guidelines and Best practices.”, and today we will cover Naming conventions.

What is Naming Convention?
Why Naming Convention is required?
What are different types of Naming conventions?
How to decide Conventions?
Conclusion

What is Naming Convention?

Naming convention is something which answers a question “How to name an element.”
In programming, it can be defined as set of rules which tells how a identifier will be named, like

What all characters are permissible?
How it should be formatted or organized?
And so on...

When it comes to naming, it’s a quite contentious topic.

Why Naming Convention is required?

Try to read the following word.
gradeofamericancustomer.
It’s challenging to read it in a single glance.
Now try to read this one
GradeOfAmericanCustomer

The answer is

Respectable programming is that where code is healthy written, which can be easily read and apprehend.
And for readability naming convention is must. No one can read my name if I write like “sukeshmarla”, but can if it’s like “Sukesh Marla”.
When we talk about a project, we have a team. And it will be a very difficult when every programmer in a team use his own way or standard for defining variables. Difficulties in both management and understanding. It becomes even more difficult when a team member resigns and new guys take handover
So why every company defines centralized Naming Conventions and brings consistency.
Readability and consistency reduced effort needed to read and understand the code (especially written by other developers).
A proper naming convention with modern enhanced Intellisense feature drastically improves the development speed.

What are different types of Naming conventions?

The first golden rule everyone should follow is “Variable name should be meaning full.”

There are lots of common conventions are there for naming Identifiers. Some of them are

Pascal (aka Upper Camel) - First letter of every single word will be capital. Example: GradeOfCustomer
Camel - Begins with lower case and then capitalizes first letter of every ensuing word. Example: gradeOfCustomer
Hungarian - Variables are prefixed with some kind of information like Data Types, Modifiers etc. Example: strCustomerName, intCustomerAge

How to decide Conventions?

We already spoke about importance about naming conventions. Choosing convention completely depends how we think, it’s actually a though process thing. Let me share my thought about the same.

Nowadays all IDE’s (like visual studio) provides a great Intellisense, so using Hungarian notation will not be a good idea. It’s just makes variable more complicated to read.
Pascal or Camel - we must choose at least one of them. But which one? Well it’s up to in which you are comfortable. For instance in Java, Camel case is used extensively where as in .net Microsoft preferred Pascal (upper camel case).
I am a d.net developer, so I prefer Pascal casing for class members and Camel for local members (members defined inside a function or function parameters).
Other than Pascal and Camel some people often use one more notation where name start with underscore followed by camel casing. For example _age, _dateOfBirth.
Normally this notation is used for naming private data members,
I personally feel great about this.
It comes to handy when we have a class with say hundreds of data members (combination of private and other). And when it’s comes accessing any private member inside member function, developer just presses ‘_’ and Intellisense will show all private members at top.

Conclusion

This article cannot be treated as a final documented Naming convention document. Here I tried to explain the importance of naming convention and how to choose them.
As I said, choosing a naming convention is completely a thought process. We should remember them by their significance not just by mugging documents. Pascal, Camel, Hungarian each of them have their own significance, when comes to readability of code.

Hope all of you enjoyed reading this article. For technical training related to .net, design patterns, jQuery , WCF and more contact SukeshMarla@Gmail.com

Keep updated about articles - Facebook, twitter@SukeshMarla.

Strategy Design Pattern

2012-12-09T01:23:00.002-08:00

Feedback and suggestions are always welcome.
Hop to see you next time,
You can tweet me @SukeshMarla
https://www.facebook.com/pages/Blogs-By-Sukesh-Marla/168078149903213?bookmark_t=page

From No Factory to Factory Method

2012-11-21T09:22:00.000-08:00

Introduction

When we hear the word Design Pattern, the first question that comes to our mind is, “What are Design Patterns?”
Design Patterns are reusable and documented solutions for recurring problems in software development.
Gang of four (GOF) have categorized Design Patterns into 3 categories

Creational
Structural
Behavioral

When I started to learn Design Pattern I found Factory method as a very intriguing pattern. It is one of the most controversial and confused Creational Pattern. There is a alot of confusion in People to understanding this pattern .
First of all let me make all of you clear there is nothing like Factory Pattern (as per GOF design pattern list), GOF has something called Factory Method Pattern. (We will come across with both the terminology later in this stage)

In this article for discussion and explanation purpose I am introducing to you, two fictional characters Alexander (a .NET developer) and Thomas (CEO of an IT institute called Programmer24X7).

Story begins on the day when Thomas contacts Alexander and asks him to take up role of architect in his in-house project called “Course Management System”. We will see how Alexander progresses his knowledge about Factory Method Pattern day by day and how finally he come up with a great solution.

Before you starts reading this article, a small advice from my side, keep some snacks ready besides you, because it’s going to be a weary 6 day story. Basically I am trying to play with your patience. don’t worry just kidding. It’s gonna be fun, you will enjoy reading this article and towards the end of this article you can proudly say “I know Factory Method Pattern”.

So relax and let’s start our journey to learn Factory Method Pattern

Index

Design Pattern Series

2012-10-20T01:06:00.000-07:00

Design Patterns are widely accepted, recurring or reusable solutions to the problems occurring again and again in software development. Design Patterns - Introduction

Categories

Creational :

Structural:

Behavioural :
1. Learn Design Pattern – Mediator Pattern
2. Learn Design Pattern – Strategy Pattern

Become a .net Developer - Chapter 1 - .Net Framework

2012-10-06T03:11:00.000-07:00

Feedback and suggestions are always welcome.
Hop to see you next time,
You can tweet me @SukeshMarla
https://www.facebook.com/pages/Blogs-By-Sukesh-Marla/168078149903213?bookmark_t=page

Become a .net developer

2012-09-30T00:08:00.000-07:00

Hi Readers,
Soon I am about to start a new series called Become a .net developer.

This series especially targets fresher.

Let me share agenda

.Net Basics

How .net compiles the code
What is .net Framework?(CLR,CTS,JIT,IL Code)
Difference between Value Types and Reference Types?
What is Boxing and Un Boxing?
What is Managed and Un Managed Code?
What is Garbage Collection?

OOPS

What is class?

What is object?

Difference between structure and a class?

Abstraction and Encapsulation.

Aggregation and Composition

Inheritance

Polymorphism

Interfaces

Abstract Classes

Partial Classes

Delegates and Events

ASP.NET

Simple ASP.NET hello world.

Demonstrate state less protocol. HTTP state protocol

How to make ASP.NEt stateful session

View state

Cache object

Application object

Asp.net Page life cycle

Response.redirect and server transfer

Ajax , Ajax with Webservices

Authentication and Authorization

Tracing and debugging Instrumentation (5 Tips of Debugging)

Master pages

Web.config file settings

Deployment

Validation (Compare,Custom,Range,Regular,Expression,RequiredField) in ASP.NET

CSS and ASP.NET

ASP.NET with ADO.NET

JQUERY

.NET Collections and Other Generic Collections

Two, Three Tier Architecture

LINQ

Extension Methods

SQL

Stored Procedures

Joins

Sub Queries

SYNONYM

Cursors

Co-related Queries

Triggers

Normalization Denomalization.

Primary Key , Unique Key ,Foreign Key

Count , Max and other mathematical functions

Best Tips for SQL Optimization.

(Index may change in future)

I am already started a series of articles on design pattern at
http://www.c-sharpcorner.com/authors/SukeshMarla/sukesh-marla.aspx

For C# interview questions and answer series click http://www.questpond.com.

Comments, Suggestions and feedbacks are always welcome

14 steps to create MVP application

2012-08-26T10:28:00.000-07:00

In this article we will see what the basic steps we should follow for creating any MVP application.

Create a project structure with 4 folders

Model,View,Presenter and ViewInterfaces.

Create Entities in Model to represent data.

Create DataAccessLayer for interacting with database.

Create BusinessAccessLayer.

Identify the Display, Focus and Binding functionalities to be done in the UI,

Create interfaces (View Interface) and put those methods inside it.

Create Presenter class with a private global variable of type ViewInterface.

Create a constructor for Presenter class accepting a parameter of type of ViewInterface and inside constructor, assign parameter value to global parameter created in the step 7.

Identify actions to be performed in the UI like [Binding the Grid], [Save the record if validation passes].

Put all those methods inside Presenter (As these methods are action methods, all will be with return type void.)

Create View and implement View interface and override all the methods.

Create a global private Presenter object inside a View.

Create default constructor for view and inside it initialize presenter object created in step 12, passing current Page instance as parameter.

Handle events in the view and pass control to Presenter

In 3-Tier application in UI, we handle the events and call the actions (methods in short) defined in the page itself and In MVP in UI, we handle the events and call the actions defined in the presenter.

Hope you enjoyed,
Refer following links to learn more about MVP and 3-Tier architecture.

http://www.c-sharpcorner.com/UploadFile/SukeshMarla/3-tier-architecture-using-Asp-Net/

http://www.c-sharpcorner.com/UploadFile/SukeshMarla/building-Asp-Net-applications-using-mvp-architectu-part-1/

http://www.c-sharpcorner.com/UploadFile/SukeshMarla/building-Asp-Net-applications-using-mvp-architectu-part-2/

Hope to see some good comments.

Asp.net page Life Cycle

2012-08-05T11:20:00.001-07:00

In this article we will explore different events which take place right from the time user sends a request ,till he get the final rendered result.

Introduction

Just like normal living being, every asp.net control including Page has a life.
In our life we go through various events like Birth, Education, Marriage, Job and at the end death. And every event does some important task.
Similarly whenever a asp.net Page/Control is requested it goes through a sequence of events.

Before moving further i would like to put light towards some important concepts.

How the Request is handled by IIS.

We put URL to a aspx page in browser address bar and press enter, what happen..we get the response in terms of rendered HTML but how?

We are requesting something from browser means indirectly we are requesting something from Web Server, that means IIS. IIS based on the file extension decides which ISAPI extension can serve the request.
And in case of asp.net(.aspx) it will be aspnet_isapi_dll so passed to same for processing.
When the first request comes to the website,
1. Application domain gets created by ApplicationManager class where exactly the website runs, and which creates an isolation between 2 web applications.
2. Within the application domain an instance of the HostingEnvironment class is created which provide access information about the application such as name of the folder where the application is stored.
Next asp.net creates core objects like HttpContext, HttpRequest,HttpResponse.
Finally Application Starts by creating an instance of HttpApplication Class (which can be reused for multiple requests to maximize performance).

Request processing by HttpApplication

While processing request, HttpApplication invokes various events which includes Module Events, handlers and Page Events.
Sequence is
1. Module events - Important events are BeginRequest, AuthenticateRequest, AuthorizeRequest, ResolveRequestCache, AcquireRequestState and PreRequestHandlerExecute.
  We can use these events when we want to inject custom Pre-Processing logic, i.e, before Page Object is created.
  (you can read more about these events here
2. Handler Events - Once the above 6 events are fired, ASP.NET engine will invoke ProcessRequest event if you have implemented HttpHandler in your project. (We normally use HttpHandlers when we want to put some logic based on the File extension, Like for ImageFiles, Aspx files,...)
3. Page Events - After the HttpHandler logic executes Asp.net Page object is created during which various events will be fired and important ones are
  PreInit,Init,LoadViewState,LoadPostData ,Load,ControlEvents,PreRender,SaveViewState,Render.
  We go through every event as we move further.
4. Module events - Important events are PostRequestHandlerExecute, ReleaserequestState, UpdateRequestCache and EndRequest.
  We use this when we want to custom Post-Processing logic.
Developer can extend any of the events as per there Convenience and logic.

A small Secret about Master Pages and Life Cycle Events

All though Master Pages seems like parent they are actually child or in short we can say they behave like user control for pages.

<%@ Page Title="My Child Page" Language="C#" MasterPageFile="~/MyMaster.master" AutoEventWireup="true" CodeFile="ChildPage.aspx.cs" Inherits=" ChildPage "  %>

All events except Init and Unload fires from outside to inside manner.
Means PageEvent will be fired first and then masterpages then user controls and so on.
PreInit is a kind of event which exists only for Page.
Some events get executed only if it's a postback(Full/Asynchronous).

Life Cycle Events

PreInit - The properties like IsPostBack have been set at this time.
This event will be used when we want to
1. set master page dynamically.
2. set theme dynamically.
3. read or set profile property values.
4. this event is also preferred if want to create any dynamic controls.
Init
1. Raised after all the controls have been initialized with their default values and any skin settings have been applied.
2. Fired for individual controls first and then for page.
LoadViewState
1. Fires only if IsPostBack is true.
2. Values stored in HiddenField with id as __ViewState decoded and stored into corresponding controls.
LoadPostData - Some controls like
1. Fires only if IsPostBack is true.
2. Some controls like Textbox are implemented from IPostBackDataHandler and this fires only for such controls.
3. In this event page processes postback data included in the request object pass it to the respective controls.
PreLoad - Used only if want to inject logic before actual page load starts.
Load - Used normally to perform tasks which are common to all requests, such as setting up a database query
Control events
- This event fired means IsPostBack is true.
- Use these events to handle specific control events, such as a Button control's Click event or a TextBox control's TextChanged event.
PreRender - Raised after the page object has created all the controls that required for rendering which includes child controls and composite controls.
1. Use the event to make final changes to the contents of the page or its controls before the values are stored into viewstate and rendering stage begins.
2. Mainly used when want to inject custom Javascript logic.
SaveViewState - All the control values that support viewstate are encoded and stored into the viewstate.
Render-Generates output(html) to be rendered at client side.
We can add custom html to the output if we want here.
Unload
1. Fired for individual controls first and then for page.
2. Used to perform cleanup work like closing open files and database connections.

Reference links

http://msdn.microsoft.com/en-us/library/bb470252.aspx
http://msdn.microsoft.com/en-us/library/ms178472.aspx
http://msdn.microsoft.com/en-us/library/9ysfzy8h(v=vs.71)

Object Initializers in C#

2012-01-15T09:37:00.000-08:00

Hi all, finally i am back after long time.

Today we are going talk about Object Initializers ,

Now what exactly Object Initializer is ,
It's a C# 3.0 feature,
using which we can create object of a class and assign values to any accessible fields or properties of it at the same time, its not required explicitly invoke a constructor.

Lots of times, we create object of a class and start immediately setting values to its properties,

Lets take an example.

public class Car
{
 public string Name{get;set;}
 public Color Color{get;set;}
}

In C# 2.0 we write following code to create instance of Car and for setting it's properties.

Car myCar=new  Car ();
myCar.Name ="Chevrolet Corvette";
myCar.Color =Color.Red;
//OR Even with lots of controls it happens
TextBoxt t=new TextBox();
t.Id="txtCustomerName";
t.CssClass="textbox";

C# 3.0 make it easy with the help of Object Initializers

Car myCar=new Car(){Name="Chevrolet Corvette",Color=Color.Red};

Its simple,compact and easy to use, normally if u have worked with JSON you could have seen such syntax,

Basically this kind of feature saves some typing and code will become more concise.

Hope you enjoyed, Stay tuned for more, till then Enjoy Programming.

Page Methods in asp.net

2011-12-29T10:36:00.000-08:00

Now a days, People are looking for richer user experience, In short what they need is more speed or we can say in simple terms, Now a days people dont like waiting.

Ajax is the one by which we can create such applications
In asp.net several methods are there for calling Server Side function from JavaScript and Page methods introduced in 2.0 is one of them.

Requirements for creating Page Methods
1.It has to be static
2.It must have attached attribute WebMethod.

Example.

Lets Create a small Web application say "CallServerFunction" which contain a web page say "MyDateTimeClass"

CodeBehind

using System;
using System.Web.Services;
namespace MarlaLibraries.PageMethods
{
 public partial class PageMethodTest : System.Web.UI.Page
 {
  [WebMethod]
  public static string GetUniqueId()
  {
   return Guid.NewId.ToString();
  }
 }
}

Aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PageMethodTest .aspx.cs" Inherits="MarlaLibraries.PageMethods.Test" %>

  . 
  .
  . 
  .
  


       
 
       
   

.  
  .
  .

Javascript

That’s it as you see it’s very easy.Hope you like it. Stay tuned for more.Till then Enjoy Programming..

Retrieving row randomly

2011-11-10T02:43:00.000-08:00

ABC organization decides, they will randomly choose one of there customer each day and send some special gift to there address.
Considering there is a table TblCustomer which contain columns CusomerId,CustomerName,Address.
what will be the query to retrieve customer randomly from a list.

Getting started with android development - installation in windows platform

2011-10-29T01:53:00.000-07:00

Hi,
For getting started with android development,

First you need is JDK.
Next is Eclipse.
To Make programming and debugging easy, android provides and Eclipse plugin called ADT or Android development tools.

Install ADT

Start Eclipse, then select Help > Install New Software....
Click Add, in the top-right corner.
In the Add Repository dialog that appears, enter "ADT Plugin" for the Name and the following URL for the Location:
https://dl-ssl.google.com/android/eclipse/
Click OK
In the Available Software dialog, select the checkbox next to Developer Tools and click Next.
In the next window, you'll see a list of the tools to be downloaded. Click Next.
Read and accept the license agreements, then click Finish.
When the installation completes, restart Eclipse.

Configure ADT

Download Android SDK and extract it.
Start Eclipse.
Select Window > Preferences
Select Android from the left panel.
For the SDK Location in the main panel, click Browse... and locate your downloaded SDK directory.
Click Apply, then OK.
Add Platforms and other components

select Window > Android SDK and AVD Manager
OR
Double-click the SDK Manager.exe file at the root of the Android SDK directory.

Select the components you required and say Install.
( SDK Tool, SDK Platform tools and SDK Platform are the basic ones.)

Here we done with it, now you can start with the development,
Hope you enjoyed, Click on +1 and don't forget to put some comments.

Nullable value types

2011-10-26T12:49:00.000-07:00

Some times, we came to a situation where we need to put null value into a Integer variable, or into any other value types( We can take an example of database operations, it may possible that even Bool(bit) column in table contains null value.)

In such situation Nullable types comes into picture.

What exactly Nullable types are:

Its an instance of System.Nullable struct
It just represents a value type which even can be assigned to a null value.

Example:

public class NullableTypesTest
{
    static void Main()
    {
        Nullable<int> IntPriNumber=null;
        if (IntPriNumber.HasValue == true)
        {
            System.Console.WriteLine("Varibale has value and its "+IntPriNumber.Value);
        }
        else
        {
            System.Console.WriteLine("Varibale dont have a value");
        }
}

Some points about Nullable types:

We cannot create Nullable types based on reference types.
Nullable types have some important

properties like

HasValue - returns true/false indicating variable contains value or not.
Value - return the value it contains.

methods like

GetValueOrDefault() - return default value in case of variable contains null value,
Example

 

     Nullable<int> x=55;
     
     //Print 55
     System.Console.WriteLine(x.GetValueOrDefault());
     
     Nullable<int> y=null;
     
     //Print 0
     System.Console.WriteLine(y.GetValueOrDefault());

Alternative way of defining nullable types is
T? variable=some value
where T is a value type.
Example
int? temp=55

Validation Controls

2011-10-02T04:17:00.000-07:00

Validation is the key feture in any application dvelopement.
And when it comes to asp.net validation, there are 2 types of validations

Client Side

In this type of validation, validation is been performed in client side with the help of some client side scripts like Javascript.
The Bad thing about the Client side validation is you were never quite sure if the requesting browser would understand the scripting code(usually in java script or vb script) that you used for the validation. So, it was usually better, especially for critical Web applications, to bring the validation to the server.

Server Side

Here server side scripts are been used.
The bad thing about server-side validation is that it requires trips back and forth to the server. This takes a lot of resources and makes for a slower-paced form for the user.

Asp.net Validation Server Controls

These are the controls provided by Microsoft which provides both client and server side validation and thus used for validating user input.
If we are using such controls for validation, then its not we who decide whether to perform client side or server side validation, its Asp.net engine(depending on the browser which made the request),which indicates your page's functionality varies depending on the requesting browser.
Here is a list of the validation controls

RequiredFieldValidator
The RequiredFieldValidator control is used to ensures that a input field is not skipped in the entry. The control fails validation if the value it contains does not change from its initial value when validation is performed. If all the fields in the page are valid, the page is valid.
RegularExpressionValidator
The RegularExpressionValidator control confirms that the entry matches a pattern(let say \w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)* which is for email address) defined by a regular expression.
RangeValidator
The RangeValidator control tests whether an input value falls within a given range.
CompareValidator
The CompareValidator control compares the value of one control to another, or to an explicit value in the control's ValueToCompare property,Even we can use this for Datatype Validation(like we have to enusre that user can eneter only integer values).
CustomValidator
The customvalidator control allows writing custom validation for a control. So, if the others validators are not useful for a specific validation, it is possible to write server side validation function or a client side validation function.
ValidationSummary
A ValidationSummary control is displayed when Page validation fails. It "polls" each of the validation controls on the page and aggregates the text messages exposed by each.

Reference links

http://www.c-sharpcorner.com/UploadFile/SukeshMarla/Asp-Net-validation-control

Hope it helped,will post in detail,how to use this controls in future posts.

Thanks,Happy programming, awaiting for comments

Between operator in Sql

2011-10-01T04:24:00.000-07:00

Scenario: Consider you have a Table Say Student with Column say Age.
Student--
Age
-----
1
2
3
3
4
5
6
5

Question: What will be the result of the following query? With reason
(Use of query analyzer is not permitted,just think and answer)

Declare @Number1 int=4
Declare @Number2 int=2
SELECT * FROM Student
      WHERE Age BETWEEN  @Number1 and @Number2

Eliminate Duplicate Records

2011-08-10T11:39:00.001-07:00

Hi guys,
This time our task is to remove or eliminate duplicate entries from a sql Table.
Consider we have a Table Say Employee which contain some duplicate entries,and we have to eliminate the duplicate ones.

So lets start thinking..

Get Max Value Without using Max And Order by

2011-08-09T08:27:00.000-07:00

Hello Guys, I was busy with some stuffs from last few days,actually was looking for a job change.
but now i am back.
In one of my interview with some good reputed company,interviewer asked me a very interesting question,
He wanted me to write a query to get maximum amount without using order By and max keyword from a table T1 which contain 2 Columns Say Id and amount
As soon as he Kept this question,i bethink,some time before i encountered a situation where i have to find the maximum number in array using .net,
And i thought same approach can be applied even here..
i.e,

Declare @MaxValue int
Select @MaxValue=(case when @MaxValue>Amount then @MaxValue else Amount end) From T1
Select @Maxvalue

Interviewer impressed by this, but he still wanted the output, i.e, the max value using a single query.
After pondering for sometime,I got a respond from interviewer that "I already found,what is looking on u,so leave it,will move forward,I know u will do it."
When i came out of intreview panel,i again statred to think the solution for that,and ultimatly i found that even.
on the next day i asked my friends the same question,and one of my friend accidently found one more query

Declare @MaxValue int
Select @MaxValue=Amount From T1 Group by Amount
Select @MaxValue

I was ok with the query,because the desired result was there...and then i put the same condition whcih was put by interviewer in my case,i.e i need the result in single query..
and the query was ultimatly..

SELECT 
T11.Id,
T11.Amount as MaxAmount
FROM T1 AS T11 left outER JOIN
T1 AS T12 ON T11.Amount < T12.Amount 
GROUP BY T11.Amount, T11.Id
having COUNT(T12.Amount)=0

(Try to put more solutions if you have any..
also if in case any body have any such or related to any technology any scenario, put it them along with your solution as a comment.I will help you to share with the world)

Sql Practice - 1

2011-08-08T09:40:00.000-07:00

Hi all,

One of my friend have been asked in of the interview following question,

Consider you have at table Say TblEmployee with a column say EmployeeName

which contain Records as A,B,A,A,B,C,B,C,A

your task is to write a query which will change the EmployeeName A to B and B to A.

Means after the query been executed Records will be as B,A,B,B,A,C,A,C,B

Think what will be the query..and try to post some answers..after two day i will post the answer

Custom attributes and reflection

2011-07-06T10:00:00.000-07:00

In this post, will see
1.Create custom Attributes in c#
2.Attach them to types,
3.Retrieving them at run time

Before starting,What are attributes?
An Attribute is a declarative tag which can be used to provide information to the compiler about the behaviour of the C# elements such as classes and assemblies.

1.

public CustomValue:Attribute
{
   public string Value{get;set;}
   public CustomValue(string Value)
   {
     this.Value=Value;
   }
}

[CustomValue("Welcome To Programming world")]
public Class MyClass
{
   Public string MyProperty{get;set;}
}

//Say myObject is an instance of MyClass
Type ObjPriType=myObject.GetType();
CustomValueAttribute[] CustomAttributes=ObjPriType.GetCustomAttributes(
                typeof(CustomValueAttribute), false) as CustomValueAttribute[];
//CustomAttributes[0].Value is your Value

//In case if attribute is attached to a field in Type Code will be
Type ObjPriType=myObject.GetType();
FieldInfo ObjPriInfo=ObjPriType.GetField("MyProperty");
CustomValueAttribute[] attribs = fieldInfo.GetCustomAttributes(
                typeof(CustomValueAttribute), false) as CustomValueAttribute[];

Dynamic Top Clause in sql

2011-06-06T19:50:00.000-07:00

All of us know about the TOP clause in sql, it returns the top 'n' records from a result set.
But you ever thought about dynamic TOP .
What i mean is,we want to fetch Top 'n' records from a result set where n will be provided as a stored procedure parameter or some other manner.
Query:-

Select top @NumberOfRecords From TblFriends
--@NumberOfRecords  is a sql variable

This query will throw an error ' Incorrect syntax near top'.
Solution:-

Select top (@NumberOfRecords) From TblFriends
--here, we can set @NumberOfRecords to any integer value,even to some aggregate function
--like, select @NumberOfRecords=min(age) from TblEmployee

Hope you enjoyed it, will back with some more interesting stuffs.
(please put comments if you like it.)

Sukesh Marla: Interview Questions

2011-06-02T09:47:00.000-07:00

Click Interview Questions to view all.

Get Top N Rows For Each Group

2011-05-30T20:54:00.000-07:00

Consider a table which store the Total Marks of each student in each standard

Create Table TblMarksheet
(
  StudentId varchar(40),
  Standard varchar(max),
  TotalMarks int
)

Insert Some Values into it

Insert into TblMarksheet
Select 1,1,10 union all
Select 2,1,50 union all
Select 3,1,5 union all
Select 4,1,30 union all
Select 5,2,0 union all
Select 6,2,9 union all
Select 7,2,8 union all
Select 8,2,10 union all
Select 9,3,1 union all
Select 10,3,3 union all
Select 11,3,6 union all
Select 12,3,2 union all
Select 13,4,10 union all
Select 15,4,9 union all
Select 15,4,8 union all

Now what we want is we want to find the Top 3 Students from Each Standard.
Query:-

With MyTempView
(
  StudentId varchar(40),
  Standard varchar(max),
  TotalMarks int,
  RowIndex int
)
as
(
  Select *,row_number () over (partition by Standard order by TotalMarks desc)
)

Select StudentId,Standard,TotalMarks From MyTEmpView where RowIndex<=3

Insert value into Identity Column

2011-05-24T10:21:00.000-07:00

Create Table

CREATE TABLE [dbo].[TblMyFriends]
(
            [FriendId] [int] IDENTITY(1,1) NOT NULL,
            [FriendName] [varchar](50) NOT NULL
)

Insert Values

Insert into [TblMyFriends](FriendName) values('Dipal')
Insert into [TblMyFriends](FriendName) values('Sai')
Insert into [TblMyFriends](FriendName) values('Harshad')
Insert into [TblMyFriends](FriendName) values('Pankaj')

Insert Values with Explicity Identity Value

Insert into [TblMyFriends](FriendId,FriendName) values(44,'New Friend')
--Throw Error
--   Cannot insert explicit value for identity column in table 'Employee' when IDENTITY_INSERT --is set to OFF.

SET IDENTITY_INSERT [TblMyFriends] ON
INSERT INTO dbo.[TblMyFriends](FriendId,FriendName) VALUES(44, 'New Friend')
SET IDENTITY_INSERT dbo.[TblMyFriends] OFF

Hope This will help you,Expecting Comments....

Sukesh Marla

Technical Training at reasonable price

For technical training on various topics including asp.net,WCF,MVC and Design Patterns contact SukeshMarla@Gmail.com

Visual studio 2012 tweaks

Introduction

Single Click Preview

Where is design view in ASP.NET

Multiple themes in Visual studio

Upper Case Menus

Naming Conventions

Introduction

Contents

What is Naming Convention?

Why Naming Convention is required?

What are different types of Naming conventions?

How to decide Conventions?

Conclusion

Strategy Design Pattern

From No Factory to Factory Method

Introduction

So relax and let’s start our journey to learn Factory Method Pattern

Index

Design Pattern Series

Become a .net Developer - Chapter 1 - .Net Framework

Become a .net developer

14 steps to create MVP application

Asp.net page Life Cycle

Introduction

How the Request is handled by IIS.

Request processing by HttpApplication

A small Secret about Master Pages and Life Cycle Events

Life Cycle Events

Reference links

Object Initializers in C#

Page Methods in asp.net

Retrieving row randomly

Getting started with android development - installation in windows platform

Nullable value types

Validation Controls

Between operator in Sql

Eliminate Duplicate Records

Get Max Value Without using Max And Order by

Sql Practice - 1

Custom attributes and reflection

Dynamic Top Clause in sql

Sukesh Marla: Interview Questions

Get Top N Rows For Each Group

Insert value into Identity Column