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.

Substring function example to get particular part of string in SQL Server

Introduction: 

In this article I will explain what is the substring function and uses of substring function in SQL Server.

Description:

During write query in SQL server I got requirement like split the string and get only some part of it to achieve this functionality I realized it’s better to use SubString function. 

Asp.net Refresh page after facebook login/logout or fb.login/logout examples

Introduction: 

In this article how to refresh webpage after facebook login or logout in asp.net or examples of FB.login(), FB.logout() options in asp.net.

Description:
  
In previous post I explained how to integrate facebook login to asp.net website and get user details from facebook in asp.net. During working with these concepts I got problem to refresh webpage after facebook login or logout to get updated details of user.

JSError- microsoft jscript runtime error object doesn't support property or method 'addeventlistener'

Introduction: 

In this article I will explain how to solve problem of “microsoft jscript runtime error object doesn't support property or method 'addeventlistener'” during working with click events in JavaScript.

Description:

In Previous posts I explained how to integrate facebook login button in asp.net during implement that functionality I written functions like this to handle hyperlinks click events in JavaScript

Asp.net get facebook logged in user details(Username,email,profile image)

Introduction:

In this article I will explain how to access or get Username, email, profile image of facebook logged in user using asp.net.

Description:
  
In previous post I explained how to integrate facebook login to asp.net website. In that I explained clearly how to create app in facebook and integrate facebook login in website. After create and integrate facebook login I got requirement like get facebook logged in user details those are name, email, profile image etc.

Asp.net integrate Facebook login authentication to website

Introduction:

Here I will explain how to add facebook login website in asp.net or integrate facebook login button to website in asp.net and how to create application in facebook.

Description:
  
In previous post I explained many articles relating to Asp.net, JQuery, and SQLServer etc. Now I will explain how to allow users to login with facebook accounts in website using asp.net.

Asp.net host website on local machine with custom url instead of http://localhost/ in IIS

Introduction:

In this article I will explain how to create or setup or host new site in IIS with custom URL(http://yoursitename.com) instead of http://localhost/ in asp.net.

Description:
  
In previous post I explained how to publish or deploy our application in IIS. In one situation I got requirement like setup separate new site in IIS with custom url (ex: http://aspdotnet-suresh.com ) in system not under Default website.

The installer was interrupted before application could be installed. You need to restart installer to try again

Introduction:

In this article I will explain how to solve “The installer was interrupted before application could be installed. You need to restart installer to try again” problem during installation of custom web setup projects in system.

Description:

In previous article I explained how to create setup project to deploy application in IIS. After create a create Setup project for that application I tried to install it in my system during that time I got error like “The installer was interrupted before application could be installed. You need to restart installer to try again”.

Visual Studio Create Setup project to deploy web application in IIS

Introduction:

In this article I will explain how to create setup file in visual studio 2008/2010 to deploy web application file directly in IIS or in client machine or how to place web application folder in c:\\inetpub\wwwroot folder by running setup file using asp.net.

Description:
  
In previous post I explained many articles relating to Asp.net, JQuery, and SQLServer etc. If we did any application and if it works perfectly then we will prepare published files and deploy our application in IIS.

If we want to deploy application in IIS we need prepare separate published files folder and create virtual path in IIS, point to our folder and need to change some properties to make it work through our IIS by doing all these things we will waste a lot of time.

Set Custom auto generated/increment field in SQL Server

Introduction:

In this article I will explain how to set custom auto increment or auto generated column during insertion of record in SQL server.

Description:

In previous article I explained how to set auto identity column in SQL Server to generate a unique number for newly insert records like 1, 2, 3, 4, 5…etc based on records insertion. This identity column will work only for integer values. Suppose if I want to set id value starts from 08U13000 and increase that value based on new records inserted in table like 08U13000, 08U13001, 08U13002, etc… In this case auto identity property won’t work for us because it supports only for integer values.

Asp.net change gridview header text dynamically at runtime

Introduction:

In this article I will explain how to change gridview header dynamically at runtime using asp.net

Description:
  
In previous posts I explained many articles relating to Asp.net and Gridview. Now I will explain another article relating to Gridview. During working in one of my application I got one requirement like change gridview header dynamically whenever we click on some button.

To implement this first design table in your database and give name as UserInformantion

Asp.net show alert message from code behind using javascript

Introduction:

In this article I will explain how to call JavaScript function from code behind and show JavaScript alert message from code behind using asp.net.

Description:
  
I explained many articles relating to Asp.net, C#.NET, JavaScript, Gridview, JQuery etc. During working with those articles I came across one situation that is show alert message from code behind after completion of my code execution like our JavaScript alert message.

JQuery Hide/Show DIV Elements Content Example

Introduction:

Here I will explain how to show / hide div using jQuery or jQuery Show & hide div content elements using JQuery in asp.net.

Description:
  
In previous post I explained many articles relating to JQuery. Now in this article I will explain how to show or hide div or table elements on website using JQuery in asp.net. In many websites we will be able to see functionality like whenever we click on some link automatically that div or table will hide and again if we click on same link that will be visible for us we can implement that functionality by using JQuery

JQuery Display recent/latest tweets on website using asp.net

Introduction:

In this article I will explain how to show latest or recent tweets on website using JQuery in asp.net.

Description:
  
In previous post I explained many articles relating to JQuery. Now in this article I will explain how to display or show recent tweets on website using JQuery in asp.net. In many websites we will be able to see the tweet widget and that contains recent tweets. After seen that twitter widget I decided to write a post to display latest tweets on our website using JQuery in asp.net.

Aspdotnet-Suresh.Com has Reached 1000 Facebook likes

Hi All,

Today I am happily announcing that Aspdotnet-Suresh.com has reached 1000 facebook likes. 

Convert datatable/dataset to arraylist in asp.net

Introduction:

In this article I will explain how to convert datatable or dataset data to arraylist using asp.net.

Description:
  
I explained many articles relating to Asp.net, C#.NET, Gridview, JQuery etc. During working with those articles I came across one situation that is converting datatable to arraylist and dataset to arraylist to use it in applications. During that time I realized it would helpful for others if I write post on this. Please check the below methods to convert datatable to arraylist and dataset to arraylist in asp.net. 

Read/Write appsettings from web.config file in asp net

Introduction:

In this article I will explain how to read or write appsettings in web.config file using asp.net.

Description:

In Previous article I explained clearly about how to read or write connectionstrings from web.config file in asp.net. Now I will explain how to write appsettings in web.config file and how to read appsettings from web.config file using asp.net. 

Bind data and display datatable on aspx page using Jquery/JSON in asp.net

Introduction:

In this article I will explain how to bind data to datatable and display it on our aspx page using JQuery or JSON in asp.net.

Description:
  
In previous article I explained how to bind data to gridview with JQuery. Now I am using same concept to explain how to bind data to datatable using JQuery/JSON and display it on aspx page in asp.net.

Bind data to gridview with JQuery or JSON in asp.net

Introduction:

Here I will explain how to bind data to asp.net gridview with JQuery or JSON using c#, vb.net or bind data to gridview with JQuery or JSON in asp.net using c#, vb.net.

Description:
  
In previous article I explained JQuery UI AutoComplete textbox with database and call asp.net pagemethods in JQuery. Now I am using those concepts to explain how to bind data to gridview using JQuery/JSON and display it on aspx page in asp.net.

How to call asp.net page methods from JSON or JQuery

Introduction:

In this article I will explain how to use JQuery and JSON to call asp.net page methods.

Description:
  
In previous article I explained JQuery UI AutoComplete textbox with database in that I declared page method directly in code behind and used it in our application. Now I am using same concept to create web methods and call those methods in our page using JQuery.