What Is a Stored Procedure and Why Use it? - SQL Server

An SQL Server Stored Procedure is a logical collection of statements or queries packaged together to perform a particular task, repeatedly. You do not have to write the statements repeatedly and it saves not just time but also other server resources.

Continue reading...

Try… Catch – Exception Handling in SQL Server

Exception handling or Error handling in SQL Server is a process of handling errors during execution of a Stored Procedure or a Trigger. It has similarities with other programming language exception handling technique like C# or Vb.Net.

Continue reading...

SQL Server SUBSTRING Function with Examples

In our previous article, we have described the functionalities of CHARINDEX and we have briefly described the use of SQL Server SUBSTRING function too. A SUBSTRING function will extract a part of string from a string. This function will help you locate a single or multiple characters from a phrase or an entire sentence.

Continue reading...

SQL Server CHARINDEX Function with Examples

The primary use of an SQL Server CHARINDEX function is to find the first or starting location of an expression or characters in a given string. To make it simple, it is like searching a specified character or characters in a string.

Continue reading...

Restrict or Disable Browser Back Button Using JavaScript

This is one JavaScript trick out of many, which is not advisable to use in websites, though very useful in terms of security and integrity of online data. Restricting or Disabling the Browser back button can be very annoying for users who might wish to go back to the previous page from the existing page.

Continue reading...

Find the File Extension using JavaScript and JQuery

Dealing with files can be cumbersome since you will have to manage them using server side scripts. At least there are ways to find the type or extension of the files you are dealing with, using client side scripts like JavaScript and JQuery.

Continue reading...

Blink or Flash Multiple Cells in Excel using VBA’s OnTime method

Excel is a very useful application for managing data on a spreadsheet. Its VBAtools and functions have made it more dynamic and appealing. Macros can make the contents in the file more meaningful and organized.

Continue reading...

Get All The Child DIV IDs Inside a DIV Using JQuery

Sometimes we need find child element id’s inside another element. Traditionally, a “DIV” used as a container and there can be other DIV elements inside it. You can place these elements during the designing of the web page or create and insert in it dynamically.

Using JQuery ".map()" function, we can extract the child id's with out even running a single loop. 

Continue reading...

Clear all textbox values inside a container using JQuery

JQuery has definitely made the lives of programmers easy in many ways. One of the features we will discuss in this article is how to clear values in all textboxesinside a container with just a click of a button, using JQuery. The container can be either a “DIV” a “Panel” or a “Table”.

$('#btClearAll').click(function() {     });

Continue reading...

Multiple File Upload in Asp.Net

Microsoft’s .Net has a come a long way when it comes to uploading various types of files. With Asp.Net version 2.0, it has introduced the “FileUpload” server side control for the very first time. This has virtually simplified the file uploading process.

Continue reading...

SQL Server – Saving changes is not permitted.

It can be annoying when you have installed a brand new software on your PC, and it refuses to function the way you expect it to.

Continue reading ...

Asp.Net – How to do a Partial PostBack using UpdatePanel and ScriptManager Controls?

“Asynchronous Java and XML” also known as the “AJAX” has come a long way. It has always been very useful since the Classic ASP era. And it has definitely made web browsing very easy and thrilling.

Continue reading...

Asp.Net - How to Bind a DropDownList to a Database table in GridView?

An Asp.Net DropDownList control holds a collection of data which allows the user to select a single data from a drop down list. This control can either be used as standalone control on a web page or can be embedded in another control, like a GridView control.

Continue reading...

Check if Any GridView Row With RadioButton is Selected Using JQuery.

We have used the GridView control in Asp.Net for various purposes in our projects, time and again for a long very time now. But we know that most of its features are available at the server side. Using JQuery we can do some useful validations at the client side on the GridView control.

Continue reading...

Copy Data from One DataGridView to Another in Vb.Net

Single row or multiple rows can be transferred from one DataGridView to another with help of few lines of code. Why would somebody do that? We have come across a situation where we had to upgrade details about existing records with new details without changing the original one.


Continue reading...

Bind and Show a ComboBox in a DataGridView Cell – Windows Application

DataGridView control is used to display data in tabular format. Its use is not limited to just displaying data, but it’s a perfect tool for doing data manipulation by binding it with a database. With its many useful features the DataGridView can be made to function like an Excel sheet.

Continue reading...

Import data from Excel in Asp.Net

There are various ways to import data from an Excel file to a Sql Server database table. We can use either a “DataSet” to import data into a table or by using the “SqlBulkCopy” class available in the namespace System.Data.SqlClient.

Continue reading...

Export data to Excel in Asp.Net – All Excel versions

Data can be exported to other file formats using various ways. We are not talking about printing the data, but to export it to an excel file, word and even text files, so the files can be emailed or copied to any other source. One of most popular source is the Excel file and we have an example for doing that in Vb.Net.

Continue reading...

Joins in SQL Server

As a programmer we have all had access to databases and an instinct to fetch data from it. So we started looking for various means to achieve it. SQL JOINS are one of those means which allows us to fetch a combination of data from one or more tables in a database. An entire RDBMS (Relational Database Management System) relies on JOINS.

FULL OUTER JOIN

Continue reading...

Create a PDF file using Crystal Report in Asp.Net

A Portable Document Format (PDF) file can be used for various purposes particularly for sharing data on the web. Following few steps, we can create a PDF file using Crystal Report in Asp.Net.

Continue reading...