2012-01-04T18:50:00.000+05:30

Dynamic SQL statements A dynamic SQL statement is constructed at execution time, for which different conditions generate different SQL statements. It can be useful to construct these statements dynamically when you need to decide at run time what fields to bring back from SELECT statements; the different criteria for your queries; and perhaps different tables to query based on different

2012-01-04T18:35:00.000+05:30

Passing table valued parameters in SQL Server 2008 How to pass table parameters I need to set up my SalesHistory table, which holds my product sales. The following script will create the table in the database of your choice: IF OBJECT_ID('SalesHistory')>0 DROP TABLE SalesHistory; GO CREATE TABLE [dbo].[SalesHistory] ( [SaleID] [int] IDENTITY(1,1) NOT NULL PRIMARY

Updating Source in WPF Data Binding

2011-12-05T18:50:00.001+05:30

In WPF data binding, when source property is updated from target property is called as updating source property and is defined using UpdateSourceTrigger property of Binding object. This property is used to define how you want to update source. There are two binding modes are available TwoWay and OneWayToSource which causes update to source property on change of target property. You can specify

Value Converters in WPF

2011-12-05T18:46:00.001+05:30

Start Posting Your Contents Here Value converters are used in Data binding. When source object type and target object type are different at that time value converts are used to manipulate data between source and target. Converter class must implement IValueConverter interface. The IValueConverter interface consists of two methods Convert and ConvertBack. Convert Method gets called when source

EventSetters in Style

2011-12-05T18:15:00.001+05:30

Event can also be attached inside style. Style provides EventSetter inside you can add EventName and attach appropriate handler for that event. <

Validate Data using IDataErrorInfo in WPF

2011-12-05T18:06:00.001+05:30

WPF Data binding supports for business layer data validation using IDataErrorInfo interface. IDataErrorInfo interface was exists earlier in Windows forms application. Microsoft added support for binding to report error using IDataErrorInfo interface in WPF 3.5 version. IDataErrorInfo interface has two properties one is string Error and another is string indexer. String indexer accepts property

Validation Rules in WPF

2011-12-05T18:00:00.001+05:30

WPF data binding model provides ability to validate user input. You can associate Validation Rule with your Binding as well with MultiBinding. Binding engine automatically checks whether any ValidationRule associated or not if yes then every time value passes to the source it will applies validation. Validation applies only when target value updates source value (i.e. with TwoWay or

DataTriggers in WPF

2011-12-05T16:57:00.001+05:30

This post shows how you can implement data triggers in WPF. The code is self explanatory. The window consists of textboxes which turn red in foreground color if a value of a memeber of a itemsource to which the data is bounded is set to false. The data is bound using XML data provider. Put the follo0wing ina XML file. true #FFCC3333

Epander control in WPF - Exmaple

2011-12-02T19:23:00.001+05:30

Just copy paste the code. it is self explanatory. XAML

Expander control in WPF

2011-12-02T19:05:00.001+05:30

An Expander control provides a way to provide content in an expandable area that resembles a window and includes a header. The Content and Header of an Expander can also contain complex content, such as RadioButton and Image objects. Setting the Direction of the Expanding Content Area You can set the content area of an Expander control to expand in one of four directions (Down, Up, Left, or

DockPanel in WPF

2011-12-02T18:53:00.001+05:30

Introduction The dock panel is a layout panel, that provides an easy docking of elements to the left, right, top, bottom or center of the panel. The dock side of an element is defined by the attached property DockPanel.Dock. To dock an element to the center of the panel, it must be the last child of the panel and the LastChildFill property must be set to true. Click

Two way Binding in WPF

2011-07-26T22:06:00.003+05:30

In this article we shall understand two way binding in WPF applications.Abstract :In this article I will show you about two way binding in WPF application. Its very easy to do in WPF in comparison of windows Application programming.Two way binding is used when we want to update some controls property when some other related controls property change and when source property change the actual

Styles in WPF

2011-07-26T19:53:00.003+05:30

The following sample shows how styles can be applied at page level in WPF. The style details are encapsulated under tags. Each style that you create must have a unique name associated with it. This is done by the key property.Setting the Key property to unique names created unique style elements. The creation of style is very similar to the way it is done in web

WPF Message box

2011-07-26T18:07:00.004+05:30

The sample demonstrates the use of message box in WPF. it also shows the various options available for the WPF message box parameters like "caption", "image to be shown", "MessageBoxText".The code/example is self explanatory .Just copy paste the code in the XAML and it's code behind file.XAML Code

SQL Concepts with examples

2011-06-03T21:09:00.000+05:30

VIEWS--------CREATE VIEW [Current Product List] ASSELECT ProductID,ProductNameFROM ProductsWHERE Discontinued=NoINDEX------CREATE INDEX IDX_CUSTOMER_LOCATIONon CUSTOMER (City, Country)CURSORS---------Declare @name varchar(32)declare cursorname cursor read_only forselect name from Ashwinopen cursornamefetch NEXT from cursorname into @namewhile(@@Fetch_status=0)beginprint @namefetch next from

C# 3.0 Features: Object Initializers

2011-06-03T19:56:00.001+05:30

C# 3.0 is just around the corner so I thought I'd start writing about a few of the features that it exposes and provide quick and concise examples of how they can be used. Many of the new features rely on the compiler to generate code that you would have had to write in the past. This can result in significantly less code compared to C# 2.0 syntax in many cases. Here's a list of some of the key

Extension Methods in C#

2011-05-25T12:58:00.001+05:30

.NET 3.5 is out which means all of the great features available in C# 3.0 are available to use now. Here's a quick list of the main language enhancements available in C# 3.0:# Object Initializers# Automatic Properties# Extension Methods# Anonymous Types# Lambda Expressions# LINQ# Collection InitializersExtension methods allow existing classes to be extended without relying on inheritance or

Difference bwtween truncate and delete in SQL

2011-05-16T17:14:00.001+05:30

Advantages of wcf service over web services.

2011-05-14T20:27:00.001+05:30

As several people asking me the WCF benefits over web services, I outlined the points here1.WCF supports more of WS-* standards than web services2.As I mentioned in the article WCF supports multiple bindings HTTP,TCP,MSMQ,WS-HTTP etc where as web service supports only HTTP.3.WCF can maintain transactions like COM+4.It has JSON integration5.It can be hosted on IIS,WAS, Self hosting and windows

Transact-SQL :- ROW_NUMBER()

2011-05-14T19:27:00.001+05:30

Transact-SQL :- ROW_NUMBER() While creating query we may need a column which will hold the sequential number like 1, 2, 3… Also we may need to show that sequential number according to a particular partition. In that situation we can use the ‘ROW_NUMBER’ keyword. Below syntax can be followed :- 1. To get sequential number irrespective of any partition. ROW_NUMBER ( ) OVER (

Assemblies in ASP.net

2011-05-12T02:22:00.000+05:30

What is an assembly? * An Assembly is a logical unit of code * Assembly physically exist as DLLs or EXEs * One assembly can contain one or more files * The constituent files can include any file types like image files, text files etc. along with DLLs or EXEs * When you compile your source code by default the exe/dll generated is actually an assembly * Unless your code is

Difference between Response.Redirect and Server.transfer

2011-05-12T02:11:00.000+05:30

You can transfer current users page request to another page with two methods: * Server.Transfer (HttpServerUtility.Transfer Method) * Response.Redirect (HttpResponse.Redirect Method)Its not always clear how these two approaches differ so let us try to clarify things a little:Response.Redirect sends HTTP code 302 down to the users browser along with the new URL location of the wanted

Reflection in c# - Detailed examples

2011-05-08T18:52:00.000+05:30

The Reflection API allows a C# program to inspect and manipulate itself. It can be used to effectively find all the types in an assembly and/or dynamically invoke methods in an assembly. It can at times even be used to emit Intermediate Language code on the fly so that the generated code can be executed directly.Reflection is also used to obtain information about a class and its members.

Reflection Examples [C#]

2011-05-08T18:45:00.000+05:30

This example shows how to dynamically load assembly, how to create object instance, how to invoke method or how to get and set property value.Create instance from assembly that is in your project ReferencesThe following examples create instances of DateTime class from the System assembly.[C#]// create instance of class DateTimeDateTime dateTime = (DateTime)Activator.CreateInstance(typeof(DateTime

Reflection in c# - part I

2011-05-08T18:41:00.001+05:30

Wikipedia says that "In computer science, reflection is the process by which a computer program can observe and modify its own structure and behaviour". This is exactly how Reflection in C# works, and while you may not realize it at this point, being able to examine and change information about your application during runtime, offers huge potential. Reflection, which is both a general term, as

Defining a custom Attribute in C#

2011-05-08T17:53:00.002+05:30

namespace CustomAttributes{// create custom attribute to be assigned to class members[AttributeUsage(AttributeTargets.Class |AttributeTargets.Constructor |AttributeTargets.Field |AttributeTargets.Method |AttributeTargets.Property,AllowMultiple = true)]public class BugFixAttribute : System.Attribute{// attribute constructor for positional parameterspublic BugFixAttribute(int bugID,string

Difference between a singleton and static in C#

2011-05-08T16:12:00.001+05:30

Advantages of singletonsSingletons preserve the conventional class approach, and don't require that you use the static keyword everywhere. They may be more demanding to implement at first, but will greatly simplify the architecture of your program. Unlike static classes, we can use singletons as parameters or objects.Using singleton as parameter [C#]//// We want to call a function with this

Implementing the Singleton Pattern in C#

2011-05-08T16:03:00.001+05:30

Implementing the Singleton Pattern in C#The singleton pattern is one of the best-known patterns in software engineering. Essentially, a singleton is a class which only allows a single instance of itself to be created, and usually gives simple access to that instance. Most commonly, singletons don't allow any parameters to be specified when creating the instance - as otherwise a second request for

Using Response.Redirect and Response.End in Try...Catch block

2011-05-07T13:59:00.000+05:30

In ASP.NET if you are using Response.End - Used for terminating page execution or Response.Redirect - used for redirecting page to some other page, and you are including these statements in TRY... CATCH block here is what you need to remember.Problem: When Response.Redirect or Response.End is written in TRY block, code in catch block is executed.Reason:ASP.NET executes these 2 methods on Response

Improve Perfomance in ASP.net

2011-05-07T13:46:00.002+05:30

While developing any web site, one should keep some points in mind.1) Set debug=false under compilation as follows: 2) Use Server.Transfer instead of Response.Redirect.3) Always check Page.IsValid when using Validator Controls4) Use Foreach loop instead of For loop for String Iteration.5) Use Client-Side Validation. (but not all the time you

Page Life Cycle in ASP.NET

2011-05-07T13:40:00.002+05:30

When a page request is sent to the Web server, the page is run through a series of events during its creation and disposal. In this article, I will discuss in detail the ASP.NET page life cycle Events (1) PreInit The entry point of the page life cycle is the pre-initialization phase called “PreInit”. This is the only event where programmatic access to master pages and themes is allowed. You can

Design Patterns - Observer pattern

2011-05-07T13:19:00.001+05:30

In this post we are going to take a look at the Observer pattern.What Is The Observer Pattern?The Observer pattern is a way for an object to notify all of it’s dependants when something changes based on a one to many relationship.The SituationContinuing to use our city dog registration software senario, one of the project’s requirements is that the dog’s owner’s be notified whenever a dog is

Design Patterns - Abstract factory pattern

2011-05-07T12:16:00.001+05:30

What Is An Abstract FactoryAn abstract factory contains a set of methods that create families of objects. For example you might have a DogFactory class that has various methods for creating different kinds of dogs like CreatePoodle, CreateBeagle, CreateGoldenRetriever, and CreateChocolateLab.Abstract Class Versus InterfaceBefore we get too deep into this pattern it is important to note that an

Design Pattern- Decorator Pattern

2011-05-06T19:05:00.001+05:30

DefinitionThe definition of the Decorator Pattern, according to Wikipedia, is:“The decorator pattern can be used to make it possible to extend (decorate) the functionality of a class at runtime. This works by adding a new decorator class that wrapsthe original class. This wrapping is typically achieved by passing theoriginal object as a parameter to the constructor of the decorator whenit is

Design Pattern - Definition

2011-05-06T18:53:00.001+05:30

What Is A Design Pattern?A design pattern is, simply, a solution to a recurring problem in software development. Design patterns outline communication and interaction between objects in common programming situations.

Difference between Marshal by value and Marshal by reference.

2011-05-06T18:48:00.001+05:30

Marshal-by-value objects are copied by the remoting system and passed in their entirety to the caller's application domain. Once copied to the caller's application domain (by the marshaling process), all method calls and property accesses are executed entirely within that domain. The entire object exists in the caller's domain, so there is no need to marshal accesses across domain boundaries.

Remoting in C# -Example

2011-05-06T16:38:00.001+05:30

Remoting is a framework built into Common Language Runtime (CLR) in order to provide developers classes to build distributed applications and wide range of network services. Remoting provides various features such as Object Passing, Proxy Objects, Activation, Stateless and Stateful Object, Lease Based LifeTime and Hosting of Objects in IIS. I’m not going into detail of these features because it

Remoting in C#

2011-05-06T16:34:00.002+05:30

While you are developing distributed application by csharp, you might need to have communication between objects that run in different processes..NET remoting enables client applications to use objects in other processes on the same computer or on any other computer available on its network.(MSDN)Each remoting application consist of three part: -->A remotable object. -->A host application

Location of machine.config file for .net framework

2011-05-05T17:08:00.000+05:30

The configuration files for applications are versioned using the CLR version, and not the framework library versions. .NET 3.5 uses the same CLR version as .NET 2.0 – and so share the same root web.config file. That is why putting the configuration settings there would cause conflicts.And here’s the locations for the machine.config for the different .NET Frameworks:For .NET Framework v1.1:C:\

Impersonate user to access network resources

2011-04-19T17:16:00.002+05:30

This class can be used to perform impersonation of a user over the network and can be used to access resources that are shared. copy paste the following class in a file,public class NetworkSecurity { const string USER_NAME = "Imperson_FileShare_Username"; const string PASSWORD = "Imperson_FileShare_Password"; const string LOGON_TYPE = "Imperson_logon_Type"; const

Foreground or Background Thread

2011-04-10T21:41:00.003+05:30

Types of ThreadsBasically, there are two types of threads which fall into: * Foreground Thread * Background Thread# Foreground threads have the ability to prevent the current application from terminating. The CLR will not shut down an application (which is to say, unload the hosting AppDomain) until all foreground threads have ended.# Background threads (sometimes called daemon threads) are

Garbage collector in C#

2011-04-10T20:57:00.000+05:30

The .NET garbage collector is known as generational garbage collector. The objects allocated are categorized into three generations. Most recently allocated objects are placed in generation 0.Objects in generation 0, that survive a garbage collection pass are moved to generation 1.generation 2 contains long-lived objects, that survive after the two collection passes.A garbage collection pass for

WCF Hosting methods

2011-02-07T22:14:00.003+05:30

Below is the table showcasing different ways in which WCF services can be hosted. It also explains which hosting to be used based on our requirements.

Difference Between Int32.Parse(), Convert.ToInt32(), and Int32.TryParse()

2011-02-01T16:26:00.001+05:30

IntroductionInt32.parse(string)Int32.Parse (string s) method converts the string representation of a number to its 32-bit signed integer equivalent. When s is a null reference, it will throw ArgumentNullException. If s is other than integer value, it will throw FormatException. When s represents a number less than MinValue or greater than MaxValue, it will throw OverflowException. For example:

Building a Simple FTP Application Using C# 2.0

2011-01-05T00:49:00.004+05:30

IntroductionAn addition to the Microsoft .NET Framework 2.0 to 1.x is the support for FTP. All these days we had to rely on 3rd party libraries which suited most of our needs, but for sure, there is an extra pleasure using the .net framework library classes. The code included is not designed to be a full-fledged reusable library, but rather an easy to use and reusable pieces of code which is

Cookies - background color selector

2011-01-05T00:18:00.001+05:30

Cookies are small pieces of text, stored on the client's computer to be used only by the website setting the cookies. This allows webapplications to save information for the user, and then re-use it on each page if needed. Here is an example where we save a users choice of background color: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

Page.IsValid and Page.Validate methods

2011-01-04T23:44:00.002+05:30

ASP.net ships with a couple of validator controls that allow you to determine whether the value of the input controls they are validating is valid.Here is a simple example of a TextBox control with a RequiredFieldValidator attached and a Button control. <%# Container.DataItemIndex + 1 %> ...and you will get the following output

Retrieve DIV value in ASP.NET using jQuery

2010-10-11T14:14:00.003+05:30

In this example, we will see how to retrieve and display the value of a div in an alert box, on the button click event. Retrieve Value of DIV in ASP.NET

Quick DotNet Solutions