Aspdotnet-Suresh

ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,SSRS, XML examples

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Generate SQL Script in Ms SQL Server 2008 to Export Database

Jul 31, 2014 0 comments
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:

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

Jul 30, 2014 0 comments
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

Jul 28, 2014 1 comments
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

0 comments
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, SQLjQueryasp.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

Jul 27, 2014 1 comments
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

SQL Server - Get Total Records Count in Union Query

2 comments
Introduction:

Here I will explain how to get total records count of union query in
sql server 2008 or sql server query to get total records of union statement with example.
Description:

SQL Server - Difference between Union and Union All

Jul 23, 2014 6 comments
Introduction:

Here I will explain difference between UNION and UNION ALL in SQL serverUnion operator will return unique records from tables and Union All in SQL server will return all the records from the tables including duplicate values also.

Description:

In previous articles I explained SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value 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 difference between UNION and UNION ALL in SQL server.

Generally Union Operators are used to combine the result of two or more select queries into single result set.

Asp.net Create DataTable Dynamically and Bind to Gridview in C#

Jul 22, 2014 2 comments
Introduction

Here I will explain how to create datatable dynamically and bind to gridview in asp.net using c#, vb.net or bind asp.net gridview with dynamically created table in c#, vb.net or create temporary table and bind data to columns in datatable dynamically using asp.net in c#, vb.net.


Description

In Previous posts I explained lot of articles regarding 
Asp.netGridviewSQL ServerAjaxJavaScript etc. In many of articles I used datatable to bind data from database but in one situation I got requirement like dynamically build and bind data to datatable in asp.net.

Bind Asp.net Gridview with DataTable in C# Dynamically

0 comments
Introduction:

Here I will explain how to bind gridview with datatable in asp.net using C# and VB.NET or create datatable dynamically and fill / bind gridview datasource in asp.net using C# and VB.NET.

Description:

In previous articles I explained insert xml data to sql table using stored procedure, Highlight gridview rows based on search in asp.net, create online poll system with percentage graphs in asp.net and many articles relating to xml, Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to bind gridview with datatable in asp.net using C# and VB.NET.

jQuery Higlight Table Row & Column on Mouseover in Asp.net

Jul 20, 2014 2 comments
Introduction:

here I will explain how to use
jQuery to highlight table row and column on mouse over in asp.net using jQuery, c#, vb.net with example or jQuery table highlight row & column on hover in asp.net using c#, vb.net.

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 highlight table row and column on mouse hover in asp.net using jQuery, c#, vb.net with example.

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.