Query to use update statement with Replace function in SQL Server

Introduction:

In this article I will explain how to write query to use update statement with Replace function in SQL Server.

Description:

In previous posts I explained Replace function example and Substring function example in SQL Server and many more articles relating to SQL Server. Now I will explain how to use update statement with Replace function in SQL Server. In one application I got requirement like update particular part of the string with another value. To achieve this functionality I realized it’s better to use Replace() function with update query.

SQL Server Query to Get Count of Duplicate Records from Table

Introduction:

Here I will explain how to write a query to get duplicate records from table in sql server or Query to get count of duplicate records or rows in SQL Server or query to find duplicate records in SQL server.

Description:

In previous post I explained Query to alter table columns and Query to delete duplicate records in SQL Server. Now I will explain how to write SQL query to get duplicate records count that means how many times each duplicate record exists in datatable. In database I have one table that doesn’t contain any primary key column because of that duplicate records inserted in table that would be like this 

Query to Alter,Add,modify,delete columns in table - sql server

Introduction:

In this article I will explain how to write SQL Query to add new column to existing table in sql server and query to delete column from table in sql and query to modify column in existing table.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain how to write query to add, remove or modify column in existing table using SQL Server. During work with one application I got requirement like add new column to existing table in SQL Server at that time I realized that it’s better to write query to add new column instead of open table structure and modify to add new column in SQL Server. To add new column to existing table in SQL server the declaration of system will be like this

Ajax CalendarExtender Example In Asp.Net -Change date format and show calendar when click on button

Introduction:

In this article I will explain how to use Ajax Calendar extender control in asp.net and how to change date format in ajax calendar control and display calendar control when click on image button in asp.net.

Description:

Previously I explained many articles relating to Ajax. Now I will explain how to use ajax calendar extender control in asp.net and change date format and display calendar control when click on image button in asp.net. Before proceed to implement this have you install ajaxcontroltoolkit in visual studio or not if not install it otherwise if you already done then follow the below steps to use Ajax calendar extender control example in asp.net.

CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" in vb.net

Introduction: 

In this article I will explain alternative of CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" in vb.net.

Description:
  
In Previous article I explained move gridview rows up and down in asp.net during work with that one I mentioned CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" for button it worked perfectly with C# code and I tried to use same CommandArgument code in VB.NET but it doesn’t work for me for that I used another way like this CommandArgument="<%# CType(Container,GridViewRow).RowIndex %>" then my problem got solved with vb.net

Move asp.net gridview rows up and down with arrow button click

Introduction:

In this article I will explain how to move gridview rows up and down with arrow button clicks in asp.net.

Description: 

  

Previous I explained many articles relating to gridview in asp.net. Now in this article I will explain how to move gridview rows up and down with button clicks in asp.net. For that first design one table in database and give name as MobileDetails as shown below

Gridview inside gridview in asp.net - nested gridview example

Introduction: 

In this article I will explain how to implement gridview with in a gridview example or nested gridview with expand/collapse options in asp.net. 

Description:

In previous posts I explained asp.net gridview examples and bind data to textbox control in gridview ,Bind data to dropdownlist  in gridview in asp.net. Now I will explain how to implement gridview within gridview or nested gridview example in asp.net.

To implement this concept first design tables (Country and State) in your database as explained in this post populate dropdown based on another dropdown in asp.net. After completion of table design write following code in your aspx page like this 

Bind data to asp.net dropdownlist in gridview

Introduction:

In this article I will explain how to bind data to dropdownlist in inside of gridview in asp.net.

Description:

In previous post I explained article how to bind data to textbox control in gridview in asp.net. Now I will explain how to bind data to dropdownlist in inside of gridview in asp.net.

To implement this concept first design tables in your database as explained in this post populate dropdown based on another dropdown in asp.net . After that design your aspx page like this 

Dropdownlist examples in asp.net

Check below articles for asp.net dropdownlist control examples and samples in c#, VB.NET

Populate dropdown based on other dropdown in asp.net

Ajax Cascading Dropdownlists example with database in asp.net

Casicading dropdownlists in asp.net gridview

JQuery Bind images to asp.net dropdownlist

Add tooltip for asp.net dropdownlist items to handle long text problem

Gridview examples in asp.net

Check below articles for asp.net gridview control examples and samples in c#,VB.NET

Insert,edit,update,delete data in asp.net gridview example

Insert,edit,update,delete data in asp.net gridview with sqldatasource example

Asp.net gridview paging example with Numeric, NextPrevious, NextPreviousFirstLast and NumericFirstLast

Asp.net gridview with custom paging like Numeric, First, Previous and Last

Show asp.net gridview header even if doesnot contain any data

Change Style of Gridview with CSS in asp.net

Asp.net Display sum of columns total in gridview footer example

Show up and down arrows to sort columns in asp.net gridview

Show limited characters in asp.net gridview columns

Change asp.net gridview header text dynamically at runtime

Filter Gridview records with dropdownlist selection in asp.net

Search records in gridview and highlight results using asp.net

Asp.net gridview checkbox validation using JavaScript

Cascading dropdownlists in asp.net gridview

Scrollable gridview with fixed header in asp.net using JQuery

Maintain state of checkboxes while paging in asp.net gridview

Check/uncheck checkboxes in asp.net gridview with header checkbox selection using JavaScript

Delete multiple rows in asp.net gridview based on checkbox selection with confirmationbox

How to make single radio button selection in asp.net gridview

Make single radio button selection and Change color of selected row in asp.net gridview using Jquery

Asp.net delete gridview records with confirmbuttonextender example

Insert images in database and retrieve from database and bind to asp.net gridview

Highlight asp.net gridview rows on mouseover or out using JavaScript

Asp.net send gridview row values to another page to update record values and return back to gridview page

Save images in folder and image path in database and display images from folder in asp.net gridview based on images path in database

Display images with lightbox effect whenever user clicks on asp.net gridview images

Edit asp.net gridview records with ajax modalpopupextender example

Show ajax confirmation box with yes/no options to delete gridview records in asp.net

Save files in folder and download files from folder whenever click on link in asp.net gridview

Add dynamically created data to databatable and bind to asp.net gridview

Ajax confirmbuttonextender example with modalpopupextender to delete asp.net gridview records

Bind Arraylist elements to asp.net gridview

Bind Genric List values to asp.net gridview

Bind Data to asp.net textbox control in inside of gridview