Latest Blogs by – MindStick

SQL IF...ELSE Statement used to test a condition. IF...ELSE Statement using in execution of a Transact-SQL statement (Store Procedure or T-SQL) and Trigger.

Some of these tips are quick and easy, others with take longer to implement. Not all of them will apply to your particular environment, and some apply to some types of server more than others. They do however apply to all versions of SQL Server.

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

You might have heard many times that one should not use SELECT * as there are many disadvantages to the usage of the SELECT *.

The focus of the article is the Export to Excel functionality - the Gridview and its data binding are only for demonstrating the Export functionality.

In .NET environment we can define transaction boundary by Transaction object.

A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.

Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.

SQL Server functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use.

PostBack is an event that is triggered when an action is performed by an ASP.Net Control. For example when we click on an asp button, the data on the page is posted back to the server for processing.

Gacutil.exe allows you to install assemblies into the cache, remove them from the cache, and list the contents of the cache. The syntax for adding an assembly using gacutil.exe is as follows:- gacutil [options] [AssemblyName]

.NET 

GAC (Global Assembly Cache) in .Net GAC (Global Assembly Cache) is where all shared .NET Assembly reside. GAC is used in the several situations:

.NET 

The CLR is one of the most essential component of the .Net Framework. CLR is the environment where all the programs using .Net technologies are executed.

.NET 

Indexes in general increase performance by reducing I/O. Without indexes, SQL Server would always have to read all of the rows in a table to find the subset of rows that have the values specified in joins or WHERE clauses

Extensible Application Markup Language, or XAML (pronounced as ‘zammel’), is an XML-based markup language developed by Microsoft.

XAML 

Here, we’re going to begin with one of the most important building blocks of a LightSwitch application, the table. Simply put, a table is a way of organizing data in columns and rows.

Microsoft Visual Studio LightSwitch is a development environment designed to simplify and shorten the development of typical forms-over-data applications for businesses.

Microsoft Visual Studio LightSwitch is a development environment designed to simplify and shorten the development of typical forms-over-data applications for businesses.

One of the most popular extensions to the Apache Web server has been mod_rewrite - a filter which rewrites URLs. For example, instead of a URL such as

Often we have looking for generating random number or random string for some requirement such as captcha validation, sending password in email etc.

C#
C# 

Before discussing about ASP.Net 4 SEO Improvements methodology firstly we have focused on why SEO? Search engine optimization (SEO) is important for any publically facing web-site.

DataTable dt = new DataTable(;); DataColumn dcID = new DataColumn("ID", typeof(int)); dcID.AutoIncrement = true; dcID.AutoIncrementSeed = 1; dcID.AutoIncrementStep = 1;

C#
C# 

<script type="text/javascript"> function CurrencyFormat(amount) { amount = amount.toString().replace(/\$|\,/g, ''); if (isNaN(amount)) { amount = "0"; }

Add Google reCaptcha in Asp.Net Page

When a form is submitted in classic ASP, all form values are cleared. Suppose you have submitted a form with a lot of information and the server comes back with an error. You will have to go back to the form and correct the information.

C#
C#