Alter query to add column with default value in SQL Server

Introduction:

In this article I will explain how to write Query to add new column with default value to existing datatable in SQL server.

Description:

In previous post I explained how to alter or add new column in datatable using SQL Server. Now I will explain how to write query to add new column with default value to existing datatable in SQL Server. During work with one application I got requirement like alter existing table structure to add new column with default value 0(zero). If we want to add new column with some default value to existing table we need to write the query in a format as shown below

Use Case Statement with Select Query in SQL Server | Case Statement Example in SQL Server

Introduction:

In this article I will explain how to write SQL  query to use case statement with select in SQL Server or case statement example in SQL Server.

Description:

In previous posts I explained Distinct keyword with top statement, Replace function, substring function to get particular part of string and many articles relating to SQL Server. Now I will explain how to write query to use case statement in SQL Server.

Generally case statement is conditional statement that will return column value based on the evaluation of set conditions. We can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE, ORDER BY, and HAVING.

Jquery autocomplete textbox with multiple words separated by comma or semicolon in asp.net

Introduction:

In this article I will explain how to implement JQuery UI autocomplete textbox with multiple words or values with comma separated or semi colon separated in asp.net.

Description:

In previous articles I explained JQuery autocomplete textbox with asp.net and JQuery autocomplete textbox with images in asp.net and many articles relating to JQuery. Now I will explain how to implement autocomplete textbox with multiple word selection in asp.net.

SQL Server - Query to use Distinct Keyword with Top Statement in SQL Server

Introduction:

In this article I will explain how to write SQL query to use distinct keyword with Top statement in SQL Server.

Description:

In previous posts I explained Replace function, substring function to get particular part of string and many articles relating to SQL Server. Now I will explain how to use distinct keyword with top statement in sql server.

Generally by using Distinct keyword we can get distinct records from datatable that declaration will be like this

SQL Server - Query to Get Last Inserted Record Id

Introduction:

In this article I will explain how to write query to get last inserted record id in sql server or last modified record id value in SQL Server.

Description:

In previous post I explained how to set identity property or auto increment column in data table and many articles relating to SQL Server. Now I will explain how to write a query to get last inserted record id value or last modifies record id in SQL Server. Generally if we create data table we will set identity column or auto increment column in table to increase column id value automatically whenever new record inserted in SQL Server. In one situation I got requirement like to get last inserted record Id from data table in SQL Server.

JQuery html or asp button click event in asp.net

Introduction

In this article I will explain how to use html button click event or asp button click events in asp.net using JQuery.

Description:

In previous article I explained how to show session timeout message before session expires in JQuery. In one situation I got requirement like implement some functionality in html button click event for that I used JQuery button click events. Here I will explain how to implement button click functionality in JQuery for html and asp button controls for that first open visual studio create new application and design your aspx page like this 

JQuery Show Session Timeout message before session expires in asp.net

Introduction: 

In this article I will explain how to show session timeout message before session expires or redirect to login page when user inactive on website using JQuery in asp.net.

Description:
  
In previous article I explained show alert message when user idle or inactive on website using JQuery. I am using that concept here to show session timeout message before session expires when user idle or inactive on website using JQuery in asp.net.

Generally in banking sites if we stay idle for sometime automatically we will get alert like your session is going to expire and it will show options like do you want to continue or Signout. Whenever we click on continue our session will active in that site without any session expire if we click on Sign Out option it will signout from that site and return to home page. We can implement this functionality easily by using available JQuery plug-in.

JQuery show alert when user idle on website for sometime in asp.net

Introduction: 

In this article I will explain how to show alter message when user idle or inactive for sometime on website in asp.net using JQuery.

Description:
  
In previous articles I explained many articles on JQuery. Now I will explain how to show alert message when user idle for sometime on website in asp.net using JQuery.

Generally in banking sites if we stay ideal for sometime automatically we will get alert like your idle for this much time on site and your session is going to expire within 5 minutes or something else we can implement this functionality easily by using available JQuery plug-in. For that first create new website write the following code in your aspx page 

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

Introduction: 

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

Description:

In previous post I explained how to access master page controls from content page in asp.net. Now I will explain how to access content page controls from master page in asp.net.

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

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

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

Introduction:

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

Description:

In previous post I explained how to bind xml data to dropdownlist or gridview in asp.net. Now I will explain how to bind data to textbox in gridview in asp.net. To implement this concept first design your aspx page like this 

SQL Server Query to Delete Duplicate Records (Rows) from Table

Introduction:

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

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

Query to Replace part of string in sql server | Replace function example

Introduction:

In this article I will explain what is the replace function in SQL Server and how to use Replace() function in SQL Server.

Description:

In previous post I explained article substring function in SQL server. Now I will explain what is Replace () function in SQL server and how to use it in our applications. In one application I got requirement like replace particular part of the string with another value to achieve this functionality I realized it’s better to use Replace () function.

how to bind xml data to dropdownlist/gridview in asp.net

Introduction:

Here I will explain how to read data from xml file and bind xml data to dropdownlist or gridview in asp.net.

Description:

In previous articles I explained articles relating to XML some of those are read xml node values and bind data to gridview and how to insert and read data from xml in asp.net. In situation I got requirement like read data from xml file and display it on webpage. My XML File Name as “Sample.xml” and that would contains data like this

Asp.net- Ajax ConfirmbuttonExtender example with modalpopupextender

Introduction:

Here I will explain ajax confirmbuttonextender example with modalpopupextender in gridview using asp.net.

Description:

Previously I explained many articles relating to Asp.net and Ajax and use customized style of confirmation box to delete gridview records. Now I will explain how to use ajax confirmbuttonextender control in gridview to delete records with modalpopupextender in asp.net. Here I am using same concept (use customized style of confirmation box to delete gridview records) but only change is I am using confirmbuttonextender to implement this concept in asp.net.

Asp.net use link button in gridview example

Introduction

Here I will explain how to use linkbutton in gridview in asp.net.

Description:

In previous posts I explained many articles relating to Asp.net, JavaScript, Jquery, gridview etc. Now in this post I will explain how to use linkbutton in gridview to delete gridview records in asp.net.

Generally if we want to place any control inside of gridview we need to use asp:TemplateField.

Asp.net Read xml node values and bind data to gridview

Introduction:

Here I will explain how to read node values from XML document using asp.net.

Description:

In previous article I explained how to insert and read data from xml in asp.net. During working with XML I got requirement like read child node values from xml file and display it on webpage. My XML File Name as “SampleXML.xml” and that would be like this

Add twitter login authentication to website in asp.net

Introduction: 

In this article I will explain how to create app in twitter and implement twitter login authentication for website in asp.net.

Description:
  
In previous post I explained article how to integrate facebook login authentication for website in asp.net. Now I will explain how to allow users to login with twitter accounts in website using asp.net.

Before implement twitter login authentication we need to get consumerKey and consumerSecret key from twitter for that we need to create application in twitter by using this link https://dev.twitter.com/apps/new  once open that will display window like this

Change/Set date format in jquery ui datepicker using asp.net

Introduction: 

In this article I will explain how to set or change date format in JQuery calendar control like dd/mm/yy or mm/dd/yy or DD/MM/YYYY etc. using asp.net.

Description:
  
In previous post I explained many articles relating to JQuery Datepicker in asp.net. Now I will explain how to change date format in JQuery calendar control like dd/mm/yy or mm/dd/yy or etc based on our requirement.

Asp.net set watermark text for password textbox in JavaScript

Introduction

In this article I will explain how to set watermark text for password textbox using JavaScript in asp.net.

Description:

In previous article I explained how to set watermark text for textbox using JavaScript. In one situation I got requirement like implement watermark text for password textbox which contains TextMode=”Password”. After did some research I realized that we don’t have a chance to implement watermark text for password textbox because it won’t support in all the browsers. 

Ajax updatepanel example with triggers in asp.net

Introduction:

In this article I will explain what is Ajax updatepanel control, advantages of updatepanel control and how to use multiple updatepanels in asp.net.

Description:

Previously I explained many articles relating to Ajax. Now I will explain what is ajax updatepanel control and use of ajax updatepanel control in asp.net.

During work with our applications if we entered any values in textbox controls and click on a button in form we will see full postback of our page and we will lost all the controls values whatever we entered previously this happend because of postback. If we want to avoid this full postback of page and round trip to server we need to write much code instead of writing much code we can use ajax updatepanel control.

Clear ajax asyncfileupload textbox after file upload in asp.net

Introduction:

Here I will explain how to clear the Ajax AsyncFileUpload control after upload files to folder or server using asp.net

Description:

In previous article I explained Ajax AsyncFileUpload example to upload files using asp.net.  

During work with Ajax AsyncFileUpload control even after upload files to folder still that is containing the path of the file which is uploaded to folder. To clear the path of file from Ajax AsyncFileUpload we need to write some custom code for that check the below code.

Ajax the operation could not be completed invalid formatetc structure in visual studio

Introduction:

Here I will explain how to solve the problem the operation could not be completed invalid formatetc structure during the time of working with Ajax AsyncFileUpload control in asp.net.

Description:

In previous post I explained Ajax AsyncFileUpload control example in asp.net. During working with that one suddenly I got error like “the operation could not be completed invalid formatetc structure”. 

Ajax AsyncFileUpload control example in asp.net to upload files to server

Introduction:

Here I will explain how to use Ajax AsyncFileUpload control to upload files to folder and show progress bar during upload files to server using asp.net

Description:

Previously I explained many articles relating to Ajax. Now I will explain how to use ajax AsyncFileUpload control to upload files to folder in asp.net. Before proceed to implement sample have you install ajaxcontroltoolkit in visual studio or not if not install it otherwise if you already done then follow the below steps to implement Ajax AsyncFileUpload control example in asp.net.

Show Jquery datepicker when click on image in asp.net

Introduction: 

In this article I will explain how to show JQuery calendar control when click on image instead of focus on textbox in asp.net.

Description:
  
In previous post I explained many articles relating to JQuery Datepicker in asp.net. Now I will explain how to show JQuery calendar control instead of focus on textbox using asp.net.

Till now I explained JQuery Datepicker articles relating to show the datepicker whenever we place or focus courser in textbox.

End Date should be greater than Start Date using jQuery Date Picker

Introduction: 

Here I will explain how to set jQuery validation like end date should be greater than start date and allow user to select dates only within particular dates range using jquery datepicker control in asp.net.

Description:
  
In previous post I explained many articles relating to JQuery Datepicker in asp.net. Now I will explain how to set end date is greater than start date in jquery datepicker control using asp.net.

Sometimes we will get situation like allow user to enter start date, end date and end date should be greater than start date and another thing if we want to allow user to select only within 1 week or 10 days or 15 days or 1 month range we can set these things easily with set month/year range in JQuery datepicker. If we want to implement this one using Ajax calendar control we need to write much code in that case if we use JQuery datepicker control we can make it easily by setting some properties.

Set month/year date range in JQuery datepicker control using asp.net

Introduction: 

In this article I will explain how to set months range or years range in JQuery calendar control in asp.net.

Description:
  
In previous post I explained show multiple months in calendar control and calendar control with dropdownlist selection for month and year. Now I will explain how to set months and years range in jquery calendar control.

Suppose now if we want to allow user to select only within 10 or 15 days or 1 month range then we can set those values very easily and previously I explained calendar control with dropdownlist selection for month and year for that we can set how many years range we display it in year dropdown.

jQuery- Show multiple months in datepicker

Introduction: 

In this article I will explain how to implement JQuery calendar control with multiple months in asp.net.

Description:
  
In previous post I explained JQuery datepicker calendar control and calendar control with dropdownlist selection for month and year. Now I will explain how to show JQuery calendar with multiple months in asp.net.

If we use Ajax calendar control we don’t have a chance to display these type custom options and need to write some custom css classes to change ajax calendar control style other Ajax calendar will be like this

JQuery dropdownlist selection for month/year in calender using asp.net

Introduction: 

In this article I will explain how to implement JQuery calendar control with dropdownlist selection for month and year example in asp.net.

Description:
  
In previous post I explained JQuery datepicker calendar control example in asp.net. Now I will explain how to use dropdownlist selection for month and year in JQuery calendar control using asp.net.

If we use Ajax calendar control we don’t have a chance to display these type custom options and need to write some custom css classes to change ajax calendar control style other Ajax calendar will be like this

JQuery Datepicker Example | jQuery Calendar Example with asp.net textbox

Introduction: 
  
Here I will explain JQuery UI datepicker or calendar control example in asp.net or how to display or show the JQuery UI Date picker control when click on textbox in asp.net.

Description:
  
In previous post I explained many articles relating to JQuery. Now in this article I will explain how to show JQuery UI calendar control when click on textbox using asp.net.