7+ jQuery Grid Plugin Examples or Datagrid Plugin Examples

Introduction: 

Here I will explain best jQuery grid plugin examples or jQuery datagrid plugin examples with demos. jQuery grid or datagrid plugins will help us to show data in table format with lot of advanced features like sorting, searching or filtering etc… If we use jQuery grid or datagrid plugins we can get all these functionalities without writing any code just by setting some properties in available plugins.   

Description:
  
In previous article I explained 7+ jQuery lightbox plugin examples, jQuery chatting application in asp.net using c#, 8+jQuery clock plugin examples, jQuery Show Youtube video in modal popup and many articles relating to jQuery Plugins, JQuery, Ajax, asp.net, SQL Server etc. Now I will explain best jQuery grid or datagrid plugin examples with demos

C# - Create a ASPX Page Dynamically in ASP.NET using C#.NET, VB.NET

Introduction:

Here I will explain how to create aspx page dynamically in asp.net using c#, vb.net or Dynamically create aspx page in your project at runtime in asp.net using c#, vb.net.

Description:

In previous articles I explained Create table dynamically in asp.net and bind to gridview, Get name of the day from date in c#, Prevent sql injection attacks in asp.net, Asp.net convert numbers to words in c#, Display list of files from folder in asp.net gridview and many articles relating to asp.net, c#, vb.net, SQL server. Now I will explain how to create aspx page dynamically in asp.net using c#, vb.net.

Get Asp.net Gridview Selected Row Values on Button click in C#

Introduction:

Here I will explain how to add checkboxes in asp.net gridview and get gridview selected rows data on button click in asp.net and get checked rows data on button click and how to work with those checked rows in asp.net using c#, vb.net.

Description:

In previous articles I explained Create table dynamically in asp.net and bind to gridview, export gridview data to excel in asp.net, Group Gridview columns with header row in asp.net and many articles relating to asp.net, c#, vb.net, SQL server. Now I will explain how to add checkboxes to gridview and get gridview selected rows data on button click in asp.net.

7+ jQuery Lightbox Plugin Examples with Demo

Introduction: 

Here I will explain best jQuery lightbox plugin examples with demos. jQuery lightbox plugins will help us to show images using modal popup with customized styles. Lightbox is simple script used to overlay on images on top of the page.   

Description:
  
In previous article I explained 8+jQuery Popup window plugin examples, jQuery Show Youtube video in modal popup, jQuery subscribe modal popup for website, 11+ best jQuery Scroll to top plugins, 8 jQuery clock plugin examples and many articles relating to jQuery Plugins, JQuery, Ajax, asp.net, SQL Server etc. Now I will explain jQuery lightbox plugin examples with demos

8 jQuery Scrollbar Plugin with Examples

Introduction: 

Here I will explain 8 best jQuery scrollbar plugins with examples. jQuery Scrollbar plugins will allow you to add fully customizable scrollbars for your application. By using jQuery scrollbar plugins we can change scrollbars style.

Description:
  
In previous article I explained 6+ jQuery Snow fall effect plugins, 11+ Best jQuery Countdown timer plugins, 12+ Best jQuery Drag and Drop Plugins, 11+ best jQuery Scroll to top plugins, 9+ JQuery AutoComplete plugins, 6+ JQuery Password Strength Plugins and many articles relating to JQuery, Ajax, asp.net, SQL Server etc. Now I will explain different type of best jQuery custom scrollbar plugin tutorials with examples.

SQL Server Cursor Example | Simple (Basic) Cursor Example in SQL Server

Introduction:

Here I will explain cursor in sql server with example or simple cursor example in sql server and how to use cursor in sql server. Cursor in sql server is used to retrieve set of data from table, loop through each record row by row, and modify the values based on requirements.

Description:

In previous articles I explained While loop example in sql server, nested while loop example in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain cursor in sql server with example.

To use cursor in sql server that syntax will be like as shown below

Bind an image slider with a folder

Introduction :

Here I will show you all how to create image slider with the images from a specific folder in asp.net  using c#. Whichever images are present in the folder it will show in the image slider.

Description :

You can do an images slider with either using ul and li and the images cone from database. But in this example I  will show you to create an image slider which will get the images from a folder without database, which contains the all images.

C# - Get (Find) Name of the Day From Date in Asp.Net

Introduction:

Here I will explain how to find or get name of the day in a week in asp.net using c#, vb.net when user will input the date.

Description:

In previous articles I explained SQL Query to find first & last day of month, SQL Query to get month wise & year wise data, SQL Query exclude weekends to get data, SQL Server Get only month & year from date and many articles relating to asp.net, c#, vb.net, SQL server. Now I will explain how to find or get name of the day in a week in asp.net using c#, vb.net when user will input the date.

Asp.net Preventing SQL Injection Attacks using Parameterized Queries

Introduction:

Here I will explain how to prevent SQL injection attacks in asp.net website with example using c#, vb.net. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous posts I explained SQL injection example in Asp.net, SQL Server insert multiple rows with single insert statement, how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain how to prevent SQL injection attacks in asp.net website with example using c#, vb.net.

To prevent SQL injection attacks we need to use parameterized queries to pass values from code behind to database like as shown below

SQL Injection Attack Example in Asp.net using C#, VB.NET

Introduction:

Here I will explain what are sql injection attacks in asp.net website with example and how to prevent SQL injection attacks in asp.net using c#, vb.net with example. SQL injection means injecting some SQL commands in SQL statements to hack your data or delete data or change your data in tables via web page input.

Description:

In previous post I explained jQuery scroll to particular position of div when click on link, SQL Server remove duplicate records from table, SQL Server insert multiple rows with single insert statement, how to send mail with attachment in asp.net and many more articles related to asp.net, SQL, c#, vb.net. Now I will explain what is sql injection attack in asp.net website with example.

Asp.Net Convert Numbers to Words (String) in C#

Introduction:

Here I will explain how to convert numbers to words in asp.net using c# with example or convert numbers to string in asp.net using c#.

Description:

In previous post I explained jQuery tag cloud example in asp.net, sitemap control example, send html page as mail body in asp.net, send mail with images using gmail user credentials, send multiple attachments with email in asp.net, how to send mail with attachment in asp.net and many more articles related to asp.net using c#, vb.net. Now I will explain how to convert numbers to words in asp.net using c# with example.

Generate Script in SQL Server 2008 to Export Database

Introduction:

Here I will explain how to generate script in sql server 2008 to export database or Export database in sql server with script.

Description:

In previous articles I explained SQL Server Get total rows count in union query, SQL Server Difference between Union and Union All, SQL Server Replace multiple spaces in string with single space, SQL Server Remove html tags from string and many articles relating to SQL server. Now I will explain to generate script in sql server 2008 to export database.

jQuery Limit Number of Characters in Textarea (Textbox) Even Copy Paste Text

Introduction:

here I will explain how to use jQuery to limit number of characters in textarea(textbox) even copy and paste text or  jQuery restrict textbox(textarea) length even copy and paste text in textbox with example.

Description:

In previous post I explained jQuery Tag cloud example in asp.net, jQuery show datatable on aspx page in asp.net, send html page as mail body in asp.net, how to send mail with attachment in asp.net and many more articles related to jQuery,asp.net, c# and vb.net. Now I will explain how to how to restrict textbox(textarea) length even copy and paste text in textbox with example in jQuery

SQL Server Remove Duplicate Records (Rows) from a Table

Introduction:

Here I will explain how to remove duplicate records from a table in SQL server or delete duplicate rows or records in sql server or removing duplicate records using sql server or sql server delete duplicate records or rows from table

Description:

In previous articles I explained about substring function in SQL server and Replace function in SQL Server and I explained how to delete duplicate records from datatable in asp.net. Now I will explain how to delete duplicate records from a datatable in SQL server. 

During work with one application I got requirement like get the unique records from datatable in sql server. Actually our datatable does not contain any primary key column because of that it contains duplicate records that would be like this

Asp.net Display List of Files from Server Folder in Gridview

Introduction:

Here I will explain how to display list of files from server folder in asp.net Gridview or get files from folder or directory and bind to Gridview in asp.net using C#, VB.NET.

Description:

In previous articles I explained create zip files in asp.net, Delete files from uploaded folder in asp.net, create/delete directory in asp.net, Joins in SQL Server and many articles relating to Gridview, SQL, jQuery, asp.net, C#, VB.NET. Now I will explain how to display list of files from server folder in asp.net Gridview using C#, VB.NET.

SQL Server - Insert Multiple Rows with One Insert Statement

Introduction:

Here I will explain how to insert multiple rows into table with single insert query in sql server or sql server insert multiple records in table with one insert statement with example.

Description:

In previous articles I explained SQL Server Get total rows count in union query, SQL Server Difference between Union and Union All, SQL Server Replace multiple spaces in string with single space, SQL Server Remove html tags from string and many articles relating to SQL server. Now I will explain how to insert multiple rows into table with single insert query in sql server.

To insert multiple rows into table with single insert query in sql server we can follow different methods like as shown below