How to access asp.net master page controls from content page

Introduction: 

In this article I will explain how to access or get master page controls from child or content page in asp.net

Description:

In previous posts I explained many articles relating to asp.net, gridview, SQL Server, JQuery, JavaScript and etc. Now I will explain how to access master page controls from child page or content page in asp.net.

update delete statement with inner join in sql server

Introduction:

In this article I will explain how to use delete or update statement with inner join in SQL Server.

Description:

In previous post I explained how to use update statement with replace function in SQL Server and many articles relating to SQL Server. Now I will explain how to use delete or update statement with inner join in SQL Server.  In one application I got requirement like delete data from database based on multiple table column values in SQL Server. Generally we will use joins concept to get data from multiple tables and if we want to delete data based on the column values of multiple tables we will use subqueries instead of use multiple subqueries we can reduce it by using inner join with delete statement.

Get Find control inside of asp.net gridview in rowdatabound event

Introduction: 

In this article I will explain how to find controls (textbox, dropdownlist, checkbox,radio button etc..) in inside of gridview and how to get values from controls which is inside of gridview in rowdatabound condition in asp.net.

Description:

In previous posts I explained many articles relating to gridview now I will explain how to find or get values of controls which is inside of gridview in asp.net.

Generally if we want to find or get value from controls which is inside of gridview in rowdatabound condition we will write code like this

Get multiple datakeyname values from gridview rowcommand in asp.net

Introduction: 

In this article I will explain how to declare multiple datakeynames in gridview and how to get multiple datakey values in gridview rowcommand event in asp.net. 

Description:

In previous posts I explained many articles relating to gridview now I will explain how to declare multiple datakeyname values in gridview and how to get datakeyname values from gridview in gridview rowcommand event in asp.net.

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