Paging in Grid View using Slider ExtenderThis article demonstrates how to implement paging in GridView using Ajax Slider Extender.
Send email in asp.net with attachmentSend email in asp.net with attachment in asp.net
Caching in ASP.NetCaching is a feature of ASP.NET that can dramatically improve the performance of your application by storing the page output or application data across HTTP requests.
Find Date Difference using Java ScriptEnter two dates (including the time!) and this script will display the number of weeks, days, hours, minutes, and seconds between the two. The second’s field is optional, too. For an example, try entering your birthdates and compare it to today.
Various functions for validation in javascriptJavaScript can be used to validate data in HTML forms before sending off the content to a server.
Animation Using JavaScriptit is possible to use JavaScript to create animated images. The trick is to let a JavaScript change between different images on different events.
JavaScipt Timing EventsIt is possible to execute some code after a specified time-interval. This is called timing events.
Insert Special Characters Using JavaScriptThe backslash (\) is used to insert apostrophes, new lines, quotes, and other special characters into a text string.
Compare two dates in java scriptThe Date object is also used to compare two dates.
How to use cookie in java scriptA cookie is a variable that is stored on the visitor's computer.
Update, Delete, Cancel in GridviewIn this Article you can learn how to edit, update, delete, and cancel in gridview.
Browser DetectionIt can be very useful to detect the visitor's browser.
Error Handling by using JavaScriptError is caught by the catch argument and the proper error message is displayed.
Mathematical Methods in JavaScriptThe following example uses the round() method of the Math object to round a number to the nearest integer.
Defining RegExp in JavaScriptThe RegExp object is used to store the search pattern.
How to crop images using JQuery in ASP.NETBy this article we came to know that how to put jQuery, JCrop and a FileUpload control together to allow users to upload images and crop them.
Transferring page values to another pageWe always come into situations in which we need to transfer values from one page to another page. In this article, I will show you some ways of transferring values from page to page.
Dynamically Adding TextBox Control to asp.net Tablehow to generate Table with TextBoxes dynamically based from the number of Columns and Rows entered from the TextBox control
How to use XSLTwhat is XSLT and how to use it to transform a xml document using a simple example
Instant Messenger Status Indicator - AIM, Yahoo, ICQ, MSN, SkypeIM status indicator is as an easy and reliable way to check online status of certain instant messeng
Hashtable in CSharpHashtable is a collection that stores information using a mechanism called hashing. In hashing, we have key and value. Each value in the hashtable is determined by its key associated with it.
List in CSharpList is a generic collection that implements a dynamic array. Its conceptually similar to the non-generic ArrayList. Sometimes we need an array to store large number of generic elements but at runtime we don’t know how large or how small it can be. To handle this situation C# has introduced List that expands and shrinks at runtime
Introduction to LINQLINQ is a new technology in .NET 3.5 that offers a unique way of querying data from diverse types of data sources.
Validation Controls in ASP.NETASP.NET has a series of validation controls that help you to validate the data entered by user before submitting to the web server.
How to pass the values from aspx page to asp page in a same projectIn this article I will show you how asp.net and asp pages can exchange information from each other in the same project
How to use Pointer in CSharpHow to use Pointer in c#
Call CSharp Method by JavaScript in ASP.NETThis article will explain how to call c# method using a JavaScript method in asp.net.
GridView with SelectAll CheckBox using JavaScript and XMLIn this article i am explaining how to bind GridView by a xml file and a common function that we need in gridview i.e. a check box that select all the check box of every row in grid without postback using JavaScript.
Looping Through Controls in ASP.NETIn my recent development I have badly needed to read all the controls from asp.net page. After searching I have found lots of solution. Now I want share with you one of these solution. In this solution we read all the control from asp.net page with out using master page.
Creating Object to a Class dynamically using ReflectionReflection is the feature in .Net, which enables us to get some information about object in run time. That information contains data of the class. Also it can get the names of the methods that are inside the class and constructors of that object.
How to get the CheckBoxlist Value using JavascriptHow to get the CheckBoxlist Value using Javascript in ASP.NET
How to get visitors Country, longitude, latitude from IP address is asp.netHere I will show you to how to get visitor's Country,longitude,latitude from IP address is asp.net
.Net Coding StandardsIt is very easy to understood your code to another programmer if you write it in a managed manner and follow some standards.
Custom Date Text Box in VB.NETIn this article you will learn how to use Custom Date Text Box in VB.NET.
DatagridView on which Enter key works as TabCustom DatagridView on which Enter key works as Tab
How can we write in App.config file at run time?We can write in App.config file at run time.
An introduction to JSONJSON is a very lightweight data format based on a subset of the JavaScript syntax, namely array and object literals. JSON allows communicating with server in a standard way. JSON is used as communication notation instead of XML.
How to get MAC address using CSharpIn this article I want to share with you some simple but important for our rapid development.
Here I want to discuss how to get system MAC address using c# ,
How to show Page loading progress with modal backgroundHow to show Page loading progress with modal background
Request format is unrecognized for URL unexpectedly ending in Web Method()It was about web service related error.
XML Parsing Error-no element foundThe common reason for XML Parsing Error: no element found is missing closing tag for one or two html element.
How to import data from an XML file to a table in SQL server 2005 or 2008In this article I will show you how to import xml data into a table in SQL server 2005 or 2008.
SQL server has strong querying capabilities to extract information from XML files.
How to remove html tag from string using RegexThis article shows how easily we can remove html tag from string using Regular Expression
Upload file using web serviceThis article is all about to uploading a file using web service.
List Control in Asp.NetSometimes we need a lookup (dropdown) from where we can select multiple items. For example, an emplo
How to get the online Users Count in ASP.NETToday I wish to get the how many users in online codegain.com, base on that idea, I come cross to a
How To Play SWF File In Asp.NetThis article demostrates how to play an swf (flash) file in asp.net.
Http HandleThe HttpHandler are used by ASP.NET to handle requests.
Hosting WCF service in Windows Azure and consuming in Window 7 phone appThis article will give step by step walkthrough of hosting a WCF service in windows azure and then consuming that in windows7 phone application.
Disable Backspace key using java scriptThis code shows how to disable backspace key and enter key using java script
Converting a .doc file to .txt file using CSharp.NETThis article is all about converting a .doc file to .txt file or in other format.
How to dynamically add and change meta tags in MasterPage using ASP.NET and CSharpThis article demostrates how to dynamically add and change meta tags in masterpage.
How to show dropdown list items in multiple colors in asp.netIn this article I will explain how to show dropdown list items in multiple colors in asp.net
How to export listview in excel in asp.netThis article will show you how to export list view in excel sheet in asp.net.
How to create primary key on a tableIn this codesnippet I will explain how you can create a primary key on a new as wel as on an existing table.
How to set default value in a column in Database tableSometimes we need to set some default value in the table column when a row is created. Here I will show how to we can achieve it.
How to cleare login history of user from sql serverHow to cleare login history of user from sql server
How to get IP address of a client machine in csharpIn my recent project I was told keep track of the IP address of all the visitors. Here I will show you how to get IP address of the client machine in csharp in asp.net.
how to generate random number in csharpHere I will show how to generate random number in csharp.
How to create file in csharpIn this code snippet I will show you how to create file in csharp.
How to copy or move a file from one location to another location in csharpIn this code snippet I will show you How to copy or move a file from one location to another location in csharp.
Check whether an expression is numeric type in sql serverHow to check whether an expression is numeric type in sql server.
Pass Viewstate across pages in ASP.NETYes, we can access the viewstate variables across pages. This is only possible if Cross Page Posting or Server.transfer is used to redirect the user to other page.
How to add remove and change css class using JQueryHere in this code snippet I will show how you can add, remove and change css class in JQuery dynamically.
how to count number of elements in array using LINQ in CSharphow to count number of elements in array using LINQ in CSharp.
How to find min max and avg in an integer array using LINQ in CSharpHow to find min max and avg in an integer array using LINQ in CSharp.
How to move the scroll bar by java script functionMove the scroll bar by java script function
LinqDatasource A Great Control for declarative programmingI have used data source control many times and its great it provides us great features for declarative binding. LinqDataSource Control is a great control and it allows us to bind linq queries without writing any code declaratively.
Difference between int.Parse and Convert.ToInt32Difference between int.Parse and Convert.ToInt32
What is difference between HTTP Handler and HTTP ModuleDifference between HTTP Handlers and HTTP Modules.
GUID Vs Int data type as primary keyRecently one of my friend ask me when I should go for GUID and When I should go for Int as primary key in table. So decided to write a blog post for it. Here are advantages and disadvantage of the GUID and INT.
Find lowest number in an array in LINQFind lowest number in an array in LINQ
Managing Session State in a SQL ServerIn this article we will see how to configure Out-of-Process Session State through SQL-Server
How to make GridView Individual Cells SelectableIn some situations we need to make GridView each cell of the GridView selectable to fetch the cell i
Distinct operator in LinqDistinct operator in Linq
Programmatically creating asp.net request and handling responseProgrammatically creating asp.net request and handling response
Multi Monitor Support in Visual Studio 2010Multi Monitor Support in Visual Studio 2010
HTML and Java Script code snippets in Visual Studio 2010HTML and Java Script code snippets in Visual Studio 2010
Ctrl K D for source code formatting in Visual StudioCtrl+K+D for source code formatting in Visual Studio
Ajax ComboBox in ASP.NETI have created a ComboBox control that mimics the functionality of Google suggest. As you type a search phrase, it automatically displays a list of matching entries in a dropdown.
Conveting Number to Word in C#This is a c# function to convert numbers into words.
Removing outer table elements from Server Control's generated HTML in Asp.net 4.0Removing outer table elements from Server Control's generated HTML in Asp.net 4.0
Refresh parent window after closing pop up window through Java ScriptYou can use this JS code to close the child window and then refresh the parent window.
How to check case sensitivity in sql-serverHere we describe the way to check case sensitivity in sql-server
File Downloading Code in C#Generally we provide the facility to download certain file on some event like button click. So here I am providing simple c#.net code to do this.
How to call button click event from java script functionIn many cases we need to call button click event from java script. So in this article I am going to describe how can we achieve this..
Reading PDF file to text in c#This article shows how you can read a pdf file and put their content in a string variable very simpl
Filtered index in SQL Server 2008A filtered index in an optimised nonclustered index, specially designed to index a sub set of data i.e, a portion of rows in as table.
Playing with dapper Micro ORM and ASP.NET MVC 3.0Playing with dapper Micro ORM and ASP.NET MVC 3.0
Insert with Dapper Micro ORM and ASP.NET MVC 3Insert with Dapper Micro ORM and ASP.NET MVC 3
Edit/Update with dapper ORM and ASP.NET MVC 3Edit/Update with dapper ORM and ASP.NET MVC 3
Delete with Dapper ORM and ASP.NET MVC 3Delete with Dapper ORM and ASP.NET MVC 3
Masked TextBox In WPFIn this article I am going to show how we can create a masked textbox in wpf.
MyCollegeMyFriend - An Open Source Project developed using ASP.NET 2.0MyCollegeMyFriend is a small but open source project developed using ASP.NET 2.0 and C#.
Finding Saturday,Sunday between date range in C#/ASP.NETFinding Saturday,Sunday between date range in C#/ASP.NET
Merge statement in SQL SERVER 2008Merge is a great feature introduced in SQL server 2008 to perform multiple DML operations like INSERT, UPDATE and DELETE in a single statement very efficiently.
Maintaining Browser History for Ajax events through script manager in asp.netMaintaining Browser History for Ajax events through script manager in asp.net
Introduction to viewbox in WPFIf we want to select a specific area from an image then how we will do it. The solution for this is ViewBox.
Inner join in LINQInner Join returns a set of rows from two or multiple tables where there is match in join condition. Join in LINQ is a great feature introduced in .NET 3.0.
Get started with ASP.NET MVC and PetaPocoGet started with ASP.NET MVC and PetaPoco.
Social Networking Website in ASP.NET - Open Source ProjectThe attached project is an open source social networking Web application project written in ASP.NET 3.5 and C#. Some of the features are for creating profiles, searching users, making friends, chatting and communication.
PetaPoco with stored proceduresPetaPoco with stored procedures in MVC.
Group join in LINQA join clause with an into expression is called a group join.
A group join breaks up the joined table into sequences of objects each matching/corresponding to an object from the other table.
A look on Layout in XAMLIn designing UI, layout is very important. In XAML in designing UI we have differenet type of layout such as Grid, StackPannel, Canvas, DockPannel etc.
A Project Report In WPF (R-Office Management System)This is a small office management system. With the help of this project all office employee can connect with each other, request online leave, get birthday reminders, get status of present/absent employees and use an automatic attendence system when logged in and logged out. Just need to install and setup of this project to every machine.
Code refactoring with Visual Studio 2010 Part-1Visual studio 2010 is a Great IDE(Integrated Development Environment) and we all are using it in day by day for our coding purpose. There are many great features provided by Visual Studio 2010 and Today I am going to show one of great feature called for code refactoring.
Printing the content of div or panelIn general, we required to print the content of a portion of page. We don't need that whole page will get printed. So here I am going to provide a small java script function that can solve this problem.
Creating Countdown function in C sharpHere I am going to give a function in c# that display the countdown in a label control.
How to take backup and restore database in Microsoft SQL Server 2005 or 2008 using wizard.Here in this article I am going to explain how to take backup and restore database in Microsoft SQL Server 2005 or 2008 pictorially using wizard.
An Open Source Project - R-Bank Management SystemThis is an open source project based on a Bank Management System. This project covers all functionality related to a bank. This project uses WPF.
Sql Server function to convert comma separated value into tabular formatSome times when writing sql query we have comma separated values and we want to convert it into tabular format so that we can apply in clause easily. So for that purpose I am giving a function that can perform this task very easily. You need to pass only the comma separated values as argument and it return the tabular format.
Making a button default clickable when enter key is pressedJava-Script function to make a button default clickable on enter key press.
Composite key join in LINQIn this article I will show how to use composite key join to perform join operation in which you want to use more than one key to define a match.
Introduction to Windows AzureWell simplest answer in this simple language to above question is “ It’s a operating system which hosts number of services on cloud”.
Parallel for loop in C# 4.0Parallel for loop in C# 4.0
Create setup of a window application in .Net step by stepHow to make a executable file of a window application? How we can restrict other user to read our application source code?
Garbage Collector AlgorithmAn algorithm on garbage collector in .NET
Code refactoring in C# with Visual Studio 2010 Part-2Code refactoring in C# with Visual Studio 2010 Part-2
Code refactoring in C# with Visual Studio 2010-Part 3Code refactoring in C# with Visual Studio 2010-Part 3
How to get current maximum value of an identity column in a tableThere is a command DBCC CHECKIDENT, which can be used to get the current maximum value of an identity column in a table.
Function to Check illegal characters for preventing Sql Injection AttackHere I have written a c# function to check illegal characters for preventing Sql Injection Attack.
Hello World application with ASP.NET pages and WebMatrixHello World application with ASP.NET pages and WebMatrix
Introduction to stuff in SQL ServerStuff function in SQL server replaces a specified length of characters with a new set of characters from a string at a given starting location.
Gradient Effect in SilverlightIn this article I am going to show how we can show graident effect in silverlight. This is my XAML code in which I am going to show gradient effect.
Genarate an Excel Sheet from a XML fileIn this article I am going to show that how we can show the data of a XML file in an Excel sheet. For doing this we have to use a XSLTFile.
Exception handling in WCF using SOAP FaultThis article is all about exception handling in WCF Service using Fault Exception. Here I am describing how to throw and handle Fault Exception.
C# function to remove illegal characters in a filenameThis function remove all the illegal characters from a filename and return a valid filename so that you can perform file handling operation smoothly.
Convert Code from C# to VB.NetMany time we need to convert certain c# code to vb.net or vice versa. So there is a tool available on net which can perform this task very easily.
AJAX Accordion Control in ASP.NETThe Accordion is a web control that allows us to provide multiple panes and display them one at a time. It is like having several CollapsiblePanels where only one can be expanded at a time.
Ajax DropShadowExtendeDropShadow is an extender which applies a "Drop Shadow" to a Panel.
Reading and Parsing a CSS file in ASP.NetIn this article I am going to show how we can read and parse a CSS file in asp.net.
Using some Mouse Property Of a Rectangle in XAMLThis article is showing that how a rectangle control use in XAML.How we can perform mouse operation on rectangle?
Scroll Banner or Text in SilverlightIn this article I am going to show how we can scroll text or banner in silverlight.
AJAX Text Box Watermark ExtenderThis article shows how to use two new AJAX Controls, TextBoxWatermarkExtender and ValidatorCalloutExtender in ASP.NET 3.5.
WebBrowser Control in WPFIn this article, I am going to show how we can use WebBrowser control in WPF application.
On-line Address Book in ASP.NET 2.0This is a small project on On Line Address Book. This small project will be very useful for those who are going to start or new in ASP.NET.
How to encrypt password or data in c#This code snippet is useful for encrypting password or any other data.
COUNT VS EXISTS in SQL SERVERIf you want to check wether a rows or rows exists in a table for a given search criteria, which would be better choice between COUNT and EXISTS to check?
And the answer is EXISTS.
Get query string value using JavaScriptThis is simple codesnippet to get query string value in JS.
How to convert a class library project into web applicationHow to convert a class library project into web application? What is web application? Difference between website and web application?
Three common mistake while creating application with ajaxThree common mistake while creating application with ajax
How to get day name in JavascriptHere i will show you how to get day name in javascript.
Disconnect all other user from SQL Server DBIn this codesnippet I will show you how you can disconnect all other user from SQL Server DB except your own.
Disconnect all other user from DBMany times we need all connections to be closed except our query and try the following methods.a) Search and kill all the connected users.b)Stop and restart the database server, then issue the command.d)Take the database offline etc. For example we want to restore datbase but system does not allow because some one is connected.
This is really a pain though has to be done.
Top 20 Interview Questions of Asp.net and Sql-ServerIn this article, I am giving 20 most commonly ask interview questions of asp.net and sql-server.
How to drop multiple tables in a single drop command in SQL SERVERHow to drop multiple tables in a single drop command.
Using IN clause to search in multiple columns of a table in SQL ServerIts possible to search a text in multiple columns of a table in SQL Server using a single IN instead of using multiple OR command.
Ordering data in LINQ queries by more than one columnIn this post I am going to show how to do ordering when you require to order data by using multiple columns.
Jquery Ajax Calling functionsJquery Ajax Calling functions
Validate integer value in java scriptThis is simple codesnippet to chech interger value is valid or not
how to get no of days in a month in javascripttips to get no of days in a month in javascript
how to get if an year is a leap year.codesnippet to get if an year is a leap year.
How to check if a string contains special charachter in javascriptHow to check if a string contains special charachter in javascript
How to compare 2 dates in javascripthow to compare 2 dates in javascript
Call Virtual Functions From Constructors?it is an important concept and not a just a puzzle or a brain teaser.
Printing Silverlight UIIn this article I am going to explain how to print a Silverlight UI
How to set default value to a column in a table in sql serverHere I will explain how you can set a default value to a column in an table in sql server.
LINQ TO SQL GridView (Enhanced Gridview)LINQ TO SQL Enhanced Gridview
asdfasdfasdsdfasdffsdfsdfsdfsdfsdfasdfsadfsadf
Programming Practice for Server Side State Maintenance VariableProgramming Practice for Server Side State Maintenance Variable
Validate radio button list in javascript in asp.netThis code snippet will check if any of the radio button in the radio button list is selected or not in javascript in asp.net
Jquery and ASP.NET- Set and Get Value of Server controlJquery and ASP.NET- Set and Get Value of Server control
Windows Azure Table Storage in detailWindows Azure table storage provides two kind of storage 1) SQL Azure and other one is 2) Table,queue,blob and other storage like drives etc. In this blog post I am going to explain Table storage in details.
Understanding JSONThe JavaScript Object Notation, or JSON, is a lightweight format syntax for representing data used for exchanging data between client and server. JSON's elegance comes from the fact that it's a subset of the JavaScript language itself.
Ajax rounded corner control in ASP.NETThere is a very good control in AJAX to make rounded type shape. We can create rounded shape in many design by using Corners property of this control.
Uploading Multiple Files in ASP.NET 2.0In ASP.NET 2.0, the FileUpload control enables the users to upload the files from your web pages. Here, I going to show, "how can you upload multiple files on a single click in ASP.NET 2.0
Transaction in .NETThis article shows how we can achieve successful transaction maintaining consistency of records in the database.
BigInteger in C# 4.0In C# 4.0 Microsoft has added so many features and I love all most all the features. In today’s post we are going to discuss BigInteger Class.
Understanding JSON serialization and deserialization in ASP.NETWhile working on an ajax application we need to transfer data from server to client anynchnously. This data transfer from server to client can be done in variety of formats. The common data formats are XML and JSON.
An introduction to Windows CardSpaceIn this article I am going to show that, what is new Security mechanism in .NET 3.0, It named as Windows CardSpace.
Geographical Information by IP Address in ASP.NET and C#This article and attached code demonstrates how to get a website visitor's geographical information such as country, region, city, latitude, longitude, zip code, time zone by using his or her IP address.
NuGet package with multiple projectsNuGet package with multiple projects
Replicate function in Sql ServerReplicate fucntion in Sql server repeats a string for a number of times specified by the user. For example if you want to repeat 'A' five times then just use replication function REPLICATE('A',5). It will produce 'AAAAA' as an output.
Simple function to check beginning or end of monthSimple function to check beginning or end of month
Take Backup of a DataBase By CodingIn this article I am going to show how we can show all Data Server in a network and on selecting a Data Server, how to show all DataBase of that selected Data Server and how to take backup of selected database on a particular location by code.
Creating a Breadcrumb like Menu using CSS and JQueryCreating a Breadcrumb like Menu using CSS and JQuery
First Review of Visual Studio11 Developer PreviewRecently before some days at Build Conference on September 14,2011 Microsoft has announced release of “Visual Studio 2011 Developer Preview.
First Review of ASP. NET MVC 4.0 Developer PreviewAfter so much buzz Microsoft has launched some of the new tools at build conference and ASP.NET MVC 4.0 Developer preview is one of them
How we can consume/read RSS of a site in asp.netIn this article I am going to explain what is RSS and how we can consume/read RSS of a site in asp.net.
Introduction to Twitter Control in Ajax Control ToolkitWith twitter control you can display the recent tweets from a particular user by supplying the user's twitter screen name. Apart from this you can also display the result of the tweeter search.
Uploading file with Progress Bar in asp.netIn this article I am going to show how we can upload file with progress bar in asp.net
using treeview to show table data in hierarchical structureIn this article I am going to show how we can have table data in a tree view format.
Generic Code of Validating Fields with JqueryGeneric Code of Validating Fields with Jquery
New solution explorer feature in visual studio11 developer previewNew solution explorer feature in visual studio11 developer preview
Online shopping website in ASP.NET-open sourcethis project is online shopping cart made in .net 4.0 in which admin can update about the products and its description and the user can buy the products online
Save and retrieve image to and from database in asp.netIn this article I am going to demostrate how we can store and retrieve image to and database in asp.net.
Show money in international format in sql serverCodesnippet to show money in international format in sql server. For example converting 26583912.1254 number as 26,583,912.13 which is in international number format.
Increase Linq query performance by Compling itIn this article I will show how you can increase Linq query performance by Compling it
How to use DataLoadOptions in Compiled Linq queryIn this article I am going to explain how to use DataLoadOptions in Compiled Linq query
Magnifying Glass Effect in SilverlightMagnifying Glass Effect in Silverlight
ASP.NET MVC 4.0 Mobile TemplateMicrosoft has released the much awaited ASP.NET MVC 4.0 developer preview and there are lots of features bundle with it.
Default Extension methodsIn this post I am going to discuss about Default extension method(s) which are use full when we query the data form the collection,array or performing operation while code using linq to sql.
Store Page ViewState in Session with asp.netStore Page ViewState in Session with asp.net
Database operations in WPF applicationIn this article I demonstrated a small project report on School management System in WPF.
Month and Year Picker UserControlMonth and Year Picker UserControl
How to check table structure in SQL server 2008How to check table structure in SQL server 2008
Get comma seperated values instead of resultset in sql serverGet comma seperated values instead of resultset in sql server
C# introduces a concept known as IndexersWhich are used for treating an object as an array
Extend your existing classes with extension method in asp.net 3.5Extend your existing classes with extension method in asp.net 3.5
How to exposing custom event from custom control in asp.netIn this post I m going to discuss about registering custom event in custom control in asp.net
ASP.NET Error Handling: Creating an extension method to send error emailASP.NET Error Handling: Creating an extension method to send error email
Cannot insert an explicit value into a timestamp columnWhenever we try to insert a value in a Timestamp column in a table using insert statement we get this error, "Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.". Here I will explain why we get this error.
Cannot alter column 'CreatedOn' because it is 'timestamp'Cannot alter column 'CreatedOn' because it is 'timestamp'
Get current zone time using GETUTCDATE() function in instance of SQL Server.Sometime we need to get the current datetime of the system where the instance of SQL server(client) is running regadless of SQL server placed in other country or different time zone. Here I will explain how you can get local datetime where the client(instance of the SQL server) is running.
Number : A new Input type in HTML5I have been writing few series of new HTML5 input types and this is another post on same series. In this post I am going to explain Number input types. The number type is for numeric values. When you use number input type it will have spinner with up and down arrow and with the help of this you can increase or decrease of value.
URL–New HTML5 input elementIn earlier post we have seen how the email input tag work in the browser. HTML5 comes with lots of new goodies and today we are going to see one of another new html5 input types URL.
Easy URL routing in ASP.NET 4.0 web formsIn this post I am going to explain URL routing in greater details. This post will contain basic of URL routing and will explain how we can do URL routing in fewer lines of code.
Redirection in URL RoutingIn one of the my earlier post I have written How easily we do URL rewriting in ASP.NET Web forms. In this post I am going to explain redirection in URL Routing.
Using TryParse Methods in C#TryParse methods which is provided by the .net framewok is one of the important method when you are converting string data into perticular primary datatype and wants to verify that it is convertable in given type or not.
C# generics with primary datatypeGeneric is feature which is useful when you have set of types which is going to perform some set of the functions which are same but the output differ from one type to another type.
How to upload file in ASP.NET MVC3If you are a web developer you often need to upload file on the web server or database. In this post I am going explain how we can upload file in ASP.NET MVC 3 with razor syntax.
Get the Way of ReflectionWhat is Reflection? How we use Reflection? What are the advantages of using Reflection? Get the way of saving memory by using Reflection.
Extension Methods in C#Method allow programmer to "add" methods to existing types without creating a new derived type, recompiling, or by modifying the original type. Methods are static methods they are called as if they were instance methods on the extended type.
Difference between SkipWhile and Where in linqBefore some time I have written a blog post about the SkipWhile operator and a reader of my blog asked me that we can do the same thing with Where also but there is a difference between this two. So In this post I am going to explain you difference between those two.
Tuple in C# 4.0C# 4.0 language includes a new feature called Tuple. Tuple provides us a way of grouping elements of different data type. That enables us to use it a lots places at practical world like we can store a coordinates of graphs etc.
Namespace In C#This article explain you about the Namespace in C#
ASP.NET Web API BasicsASP.NET Web API is a framework for building web API on the top of .NET framework. It’s a framework for building and consuming web services that can be use at broad range of clients like browsers,tablets phones etc. You can expose JSON or XML whatever you want to use.
C# State machine - YieldYield keyword introduced in C#2.0. Yield keyword allow to create state machine and allow to iterate through the collection of objects one by one
Format Number To DisplayNumber of time the end user / client require to display numeric data in different format. In this post I am going to discuss about the various type of the custom format that provided by C#.net to achieve requirement.
Here I am going to discuss each format one by one
Dividing web.config into multiple files in asp.netWhen you are having different people working on one project remotely you will get some problem with web.config, as everybody was having different version of web.config. So at that time once you check in your web.config with your latest changes the other people have to get latest that web.config and made some specific changes as per their local environment. Most of people who have worked things from remotely has faced that problem. I think most common example would be connection string and app settings changes.
Multiple file upload with asp.net 4.5 and Visual Studio 2012In earlier version of ASP.NET there is no way to upload multiple files at same time. We need to use third party control or we need to create custom control for that. But with asp.net 4.5 now its possible to upload multiple file with file upload control.
Calling Server Side function from Client Side ScriptThe post is about how you can call your code behind file function i.e server side written function from your client side code i.e using jQuery.
Model binding with ASP.NET 4.5 and Visual Studio 2012In earlier version of the asp.net we have to bind controls with data source control like SQL Data source, Entity Data Source, Linq Data Source if we want to bind our server controls declaratively. Some developers prefer to write whole data access logic and then bind the data source with databind method. Model binding is something similar to asp.net mvc binding.
How to define Classes in JavaScriptIn this article we will see different ways of defining and instantiating an object.
Extending Enum to return attached stringNo of time there is requirement of getting string of Enum value to display purpose or to perform other task. So to deal with this requirement I wrote one extension function that get the string attached with the enum value.
Enhance String type to get Converted In Given TypeConverting string into a given type with C# Convert.ChangeType method.
TitleDescription
Multiple file upload with asp.net mvc and HTML5Multiple file upload with asp.net mvc and HTML5
Call Sql Server inbuilt functions using LinqThe post is about the the new class introduce in .net framwork for support of built in SQL-Server function. The SqlFunctions class allows to call SQL-Server function from linq queries while using EntityFramwork.
Delegate and Action and Func and lamdaThis post is about the new delegate types included in .net framework which are Action and Function. How to use this type and what is difference between this two type. Also to resolve confusion between Action, Function, Delegate and Lamda.
Responsive WCF service With ICallbackEventHandler InterfaceIn this post I am going to discuss about the development of the WCF(duplex) callback service which replay back to consumer i.e client of service and about ICallbackEventHandler Interface implementation which provide response to the user on screen.
Fill Combo Box from the XMLFill Combo Box by fetching the data from XML.
Assign ToolTip to dynamically created colum of silverlight GridviewAssign ToolTip to dynamically created colum of silverlight Gridview and How to create style for element runtime
Return Anonymous typeIn this post I am going to discuss about returning the anonymous type and how to handle in code. Following is list of fact about anonymous type.
title of the article of maximum 100 charachter length.title of the article of maximum 100 charachter length. title of the article of maximum 100 charachter length.
Convert DateTime string to DateTime variableIn this post I am going to discuss about Conversion of String data in to DateTime.
Lazy in C# 4.0Before C# 4.0 there was no on demand initialization by default. So at the time of declaration we need to create a value or object will be null or we have to create on demand initialization via coding.. But with C# 4.0 we now have lazy class. As per MSDN it support lazy initialization so it means if we use lazy class then it will initialize the object at the time of demand.
Parallel task in C# 4.0In today’s computing world is all about Parallel processing. You have multicore CPU where you have different core doing different work parallel or its doing same task parallel. For example I am having 4-core CPU as follows. So the code that I write should take care of this.
How to sort a data table in C# with LINQOne of friend today ask how we can sort data table based on particular column? So I thought it’s a good idea to write a blog post about it. In this blog post we learn how we can learn how we can sort database with LINQ queries without writing much more long code.
Replace line breaks in C#In recent days I was working on a project want to replace \r\n to a new character but it was giving very strange behaviour. It was not replacing proper.
Visual Studio 2012 Tip- Closed All But Pinned featureVisual studio 2012 is one of best IDE I have ever used. Everyday I am discovering something new with that IDE which is more productive. Today I have discovered “Closed All But Pinned” feature. I thought It’s a good idea to write a quick tip post.
Store data at browser using HTML5 Web StorageStore data at browser using HTML5 Web Storage
DistinctBy in LinqIn this post I am going to discuss about how to get distinct object using property of it from collection. Here I am going to show three different way to achieve it easily.
Creating PDF file in ASP.Net MVC using RazorPDFIn this post we are going to learn how we can easily create PDF from ASP.Net application with the help of Razor PDF NuGet package.
Difference between Deferred and Immediate execution in LinqIn this post, We are going to learn about Deferred vs Immediate execution in Linq. There an interesting variations how Linq operators executes and in this post we are going to learn both Deferred execution and immediate execution.
Generate Sequcen Diagram (Visual Studio)Following post is about feature provided by MS Visual Studio to generate sequence diagram from already written code.
Enhanced Scroll bar in Visual Studio 2013In this post we are going to learn about Enhanced scroll bar in visual studio 2013. This part will also be part of Visual Studio 2013 feature series.
Knockout.js IntroductionWe all know about jQuery It makes Java Script developers life very easy. But in Some scenarios jQuery does not help. For example there is no way where UI and data communicates with each other without writing complex code. Here JavaScript library knockout comes very handy. Knockout.js implement Model-View-View-Model pattern to JavaScript.
SelectMethod in ASP.NET 4.5 Model bindingIn asp.net 4.5, It is also possible to bind controls with SelectMethod attribute. This method specify the data that you want to bind with data controls like grid view and repeater controls.
Code Lens in Visual Studio 2013Microsoft has recently launched a Preview version of Visual Studio 2013 and I am using that more then a month now and discovering new features every day. In this blog post we will learn about code lens in Visual Studio 2013.
WCF Application Security in ASP.NETWCF Application Security
throw vs. throw(ex) best practice and difference - c#This article is all about showing the differences between throw and throw(ex) and what are the best practices when using it.
WaterMark or hint text in WPF by using DependencyPropertyWaterMark or hint text in WPF by using DependencyProperty
Export two list to CSV fileIn this article we will convert two list to csv file.
How to pass parameters to a method executing by a thread in c-sharpHow to pass parameters to a method executing by a thread in c#.
Dynamic Keyword in CsharpDynamic Keyword in Csharp
int.Parse and Convert.ToInt32 and int.TryParse in cSharpint.Parse and Convert.ToInt32 and int.TryParse
How to check and uncheck a checkbox in jquery.Here is code to check and uncheck a checkbox in JQuery.
To check a checkbox
$('.#Checkbox1').prop('checked', true);
To Uncheck a checkbox
$('#Checkbox1').prop('checked', false);
How to check if a checkbox is checked or not using JQueryHow to check if a checkbox is checked or not using JQuery
Unable to update the EntitySet-because it has a DefiningQuery and no element exists to support the current operationToday I was struggling to solve this strange error in entity framework while saving a new record in a table. "Unable to update the EntitySet - because it has a DefiningQuery and no UpdateFunction element exist to support the current operation."
How to convert bitmap to image in csharpHow to convert bitmap to image in csharp.
Use XSL in csharpUse XSL in csharp
Create hidden field at run time using JqueryHere is the code to create hidden field at run time using Jquery.
Search files based on created date in c-sharpSearch files based on created date in c-sharp
Creating PDF with ASP.Net MVC and RazorPDFIn this post we are going to learn how we can easily create PDF from ASP.Net application with the help of Razor PDF NuGet package.
HashSet in C#In this blog post we are going to learn about HashSet collection in C#.
ASP.NET WEB API BEST PRACTICESIn this blog we will see that what all things we should keep in our mind while creating Web API project and what are the best practices of using ASP.NET Web API.
Why coding standards are important?Why coding standards are important?
Shared project in Visual Studio 2015Shared project is new feature that was added in Visual Studio 2013 update 2 but in visual studio 2015 it is coming by default. In this post we are going to learn about Shared Project and how it is different from class library.
NSubstitute Introduction and Why I like itNSubstitute Introduction and Why I like it
How to use NuGet PackagesThis is the fundamental article about what is NuGet packages, the benefit of NuGet, how to install, update and remove NuGet packages using GUI and Command line.
Fluent Migrator for Database MigrationFluent Migrator makes the database migration very easy. It is a database migration framework for .NET and uses fluent interface to manipulate database.
Visual Studio 2015 Github toolsThis article is about new Visual Studio 2015 Github tools and how to use it.
Inversion of Control and Dependency Injection using UnityInversion of Control (IOC) and Dependency Injection by using Unity
Deference between Debug and Release modeDeference between Debug and Release mode
Why it's the right time to learn TypeScriptWhy it's the right time to learn TypeScript.
Best way to do code review with GITBest way to do code review with GIT
How to create shapes in cssLets create different types of shapes with powerful and amazing css
A Better Solution to create PDF with Rotativa and ASP.NET MVCIn this blog post we are going to learn about creating PDF with ASP.NET MVC with the use of Rotativa as open source framework for creating PDF with ASP.NET MVC.
How to check opened connection in sql serverHere is the code snippet to check how many database connections are opened in sql server.
Asp.net: Get the current Date Time of systemIn this article I am going to explain how to get the current date time of system in asp.net.
C# code:
lbldatetime.Text = DateTime.Now.ToString();
VB.net code:
lbldatetime.Text = DateTime.Now.ToString()
How is a .NET Distributed Cache Superior to Key Value Store?ASP.NET web applications, .NET web services applications, and other .NET server applications need to handle extreme transaction loads without slowing down. And, although their application tier scales linearly, the data storage and database tier does not scale and therefore becomes a bottleneck. As a result, the entire application cannot scale.