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.

JQuery UI autocomplete textbox with database in asp.net

Introduction:

In this article I will explain how to implement Asp.net autocomplete textbox with database using JQuery.

Description:
  
In previous articles I explained Ajax autocomplete extender example and JQuery autocomplete textbox with images in asp.net. Now I will explain another article relating to autocomplete textbox with JQuery UI in asp.net.

Dynamically create datable and bind to gridview in asp.net

Introduction:

Here I will explain how to create datatable dynamically and bind to gridview in asp.net using 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.net, Gridview, SQL Server, Ajax, JavaScript 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.

Increase/Decrease or Zoom in /out options to change font size in visual studio

Introduction:

In this article I will explain how to increase / decrease or zoom in /zoom out options to change font size in visual studio.

Description:

During work with visual studio unexpectedly I pressed some of keys in keyboard because of that my application font size increased to reduce that font size I search for options in visual studio after sometime I find different options available based on visual studio versions. 

using statement example in asp.net uses of using statement

Introduction:

In this article I will explain uses of using statement and how to declare and use using statement in asp.net.

Description:

In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. In many of articles I used connectionStrings to get data from database. 

Generally in our applications we will write code like create connection object to handle connectionstring after that open a connection and create command object etc. to interact with database to get data that would be like this 

Set Username and Password for a database in SQL Server

Introduction:

In this article I will explain how to create credentials or set userid and password for a particular database in SQL server.

Description:

In our asp.net web applications generally we used database connection strings like “Data Source=MyServer; Initial Catalog=MySampleDB;uid=test;pwd=test” to connect with SQL server database to get data.

How to reset identity column value in sql server

Introduction:

In this article I will explain how to reset identity column value of table in in SQL server.

Description:

In previous post I explained how set identity or auto increment column in SQL server. After set identity property on particular column I inserted few records in table and that value automatically increase whenever I inserted data that would be like this

JQuery Display/show average rating with decimal values from database in asp.net

Introduction:

In this article I will explain how to show average rating with decimal values in asp.net using JQuery.

Description:
  
In previous post I explained Ajax rating example with database in asp.net . If we use ajax rating control to display rating we have one disadvantage that is if we get average rating like 4.3 or 2.7 etc we don’t have chance to show rating based on that value because ajax rating supports only integer values to solve this problem I am writing this article to display average rating including decimal values using JQuery in asp.net.

save/upload files in folder and download files from folder in asp.net

Introduction:

In this article I will explain how to save/upload files in folder and download files from folder system when click on link in gridview using asp.net.

Description:
  
In many websites we will see download link whenever we click on that we will have a chance to download that files into our system.

JQuery Auto Complete textbox with Images in asp.net

Introduction:

In this article I will explain how to display images with auto complete search in asp.net using JQuery.

Description:
  
In previous posts I explained many articles relating to JQuery. Now I will explain another article relating to JQuery. If we search for user in facebook we will get user name with image. After seen that search I decided to write a post to implement auto complete search with images in asp.net.

JQuery display time in facebook/ twitter formats like minute ago, hour ago, week ago in asp.net

Introduction:

In this article I will explain how to show time in facebook/ twitter formats like minute ago, hour ago, week ago in asp.net using JQuery.

Description:
  
In previous posts I explained many articles relating to JQuery. Now I will explain another article relating to JQuery. If we share anything on facebook or twitter we will get time in different format like 1 minute ago, 1 hour ago, 1 week ago etc.

Remove or delete duplicate records from datatable/ dataset in asp.net

Introduction:

In this article I will explain how to remove duplicate records from datatable or dataset in asp.net.

Description:
  
In previous posts I explained many articles regarding Asp.net, Gridview, Ajax, JQuery and many more. During write articles on those concepts generally we bind data to datatable or dataset that data contains duplicate records of data also that would be like this

SQL Server - Create Identity Column or Auto Increment Column

Introduction:

Here I will explain how to set or create auto increment column or identity property on column in SQL server.

Description:

In many situations we will insert records in table during that time we need to set unique value for that record if we use auto increment column then automatically generate unique number for newly insert record in table (Like generate EmployeeID of each employee whenever employee record inserted).

Crystal report not showing data when click on export/ print options in asp.net

Introduction:

In this article I will explain how to solve the problem of showing data when click on export/print options in crystal report using asp.net.

Description:

In Previous posts I explained many articles relating to crystal reports. During work with crystal report I find problem to display data when click on Print/Export options in crystal report using asp.net. To solve this problem I made small modification in my code to display data when click on print/export options in crystal report. 

Dynamically display images in crystal report from database in asp.net

Introduction:

In this article I will explain how to show images in crystal reports from database in asp.net.

Description:

In Previous posts I explained many articles relating to crystal reports. Now in this post I will explain how to dynamically display images in crystal reports from database in asp.net.

Crystal Report not refreshing based on parameter values in asp.net

Introduction:

In this article I will explain how to refresh crystal reports based on parameter values to populate required data in asp.net

Description:

In Previous posts I explained crystal reports example in asp.net and pass parameters to crystal reports using asp.net. After create crystal reports with search option first time I entered text and click on search button at that time reports populate with required data after that again I entered text and click search button during that time report is showing only previous data that is not updating based on search text. 

Crystal report images in toolbar not displaying and export/print functionality not working in asp.net

Introduction:

In this article I will explain how to solve problem of “Missing toolbar images in crystal reports and Crystal report export/print functionality not working” whenever we deploy reports to server.

Description:

In Previous posts I explained crystal reports example in asp.net and pass parameters to crystal reports using asp.net. After create crystal reports if I run in my system it’s working fine whenever I deployed crystal reports to server that report toolbar images are missing and export/print functionality not working.  

Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed

Introduction:

In this article I will explain how to solve problem of “Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed” during deploy crystal reports in server.

Description:

In Previous posts I explained crystal reports example in asp.net and pass parameters to crystal reports using asp.net. After create crystal reports if I run in my system it’s working fine whenever I deployed crystal reports to server I got error like Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed.

Could not load file or assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies

Introduction:

In this article I will explain how to solve problem of “Could not load file or assembly 'CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken= 692fbea5521e1304' or one of its dependencies” during deploy crystal reports in servers.

Description:

In Previous posts I explained crystal reports example in asp.net and pass parameters to crystal reports using asp.net. After create crystal reports if I run that application in my system it’s working fine whenever I deployed crystal reports to server I got error like

Pass parameters to Crystal Reports in asp.net

Introduction:

In this article I will explain how to pass parameters to crystal reports programmatically in asp.net.

Description:

In Previous posts I explained how to install crystal reports in visual studio 2010 and crystal reports example in asp.net.

Crystal reports example/sample in asp.net

Introduction:

In this article I will explain how to create crystal reports example in asp.net.

Description:

In Previous posts I explained how to install crystal reports in visual studio 2010 and how to create rdlc reports using asp.net and pass parameters to rdlc reports using asp.net. Now I will explain how to create basic crystal reports using asp.net. Crystal Report is standard reporting tool for visual studio by using these we can display reports regarding employee details and display charts etc and crystal reports need minimal coding to display result. 

Install crystal reports in visual studio 2010 to solve problem of getting CrystalReport.mht file

Introduction:

In this article I will explain how to solve problem of getting CrystalReport.mht file after install crystal reports in visual studio 2010.

Description:

In Previous posts I explained how to create rdlc reports using asp.net and pass parameters to rdlc reports using asp.net. Now I will explain how to solve problem of getting CrystalReport.mht file after install crystal reports in visual studio.

Repeater Control example in asp.net

Introduction:

In this article I will explain what is repeater control, uses of repeater control and how to bind data to repeater control in asp.net.

Description:
  
In previous posts I explained many articles regarding Gridview, Ajax, JQuery and many more. Now I will explain about what is repeater control, uses of repeater control, bind data to repeater control in asp.net.

JQuery form validations example in asp.net

Introduction:

In this article I will explain how to show small popup or beautiful style of validation messages or inline form validation messages when validation fails in asp.net using JQuery.

Description:
  
In previous articles I explained about Display validation error messages with images and Change textbox background when validation fails and Ajax Password Strength using asp.net  and many articles on JQUery. Now I will explain how to implement inline form validations when validation fails using JQuery in asp.net.

Change user password using changepassword control in asp.net membership provider

Introduction:

In this article I will explain how to use changepassword control to change password in asp.net membership provider.

Description:

In previous posts I explained clearly how to create users using createuserwizard or programmatically create users using asp.net membership and I explained  how to get forgot password through email. In previous post Get forgot password through mail it will reset our password and sent randomly generated new password through mail. It’s very hard to remember randomly generated password. If we allow users to change their passwords directly that is very convenient. We can achieve this one easily by using changepassword control asp.net membership. 

Customize body of Email sent by passwordrecovery in asp.net

Introduction:

In this article I will explain how to customize body of email sent by passwordrecovery control in asp.net membership.

Description:

In many sites we will see option like forgot password whenever we click on that option and give username or password they will send password details to our email.

Recover forgot password using passwordrecovery control in asp.net membership

Introduction:

In this article I will explain how to reset or recover forgot password using passwordrecovery control in asp.net membership.

Description:

In previous post I explained clearly about create users using CreateUserWizard in asp.net membership or programmatically insert user details in membership and create or removes roles in asp.net membership and Assign roles to users .Now I will explain how to get forgot password using passwordrecovery control. 

Assign roles to user in asp.net membership

Introduction:

In this article I will explain how to assign roles to users and remove roles from users and how populate user roles based on username selection in asp.net membership.

Description:

In previous post I explained clearly about create users using CreateUserWizard in asp.net membership or programmatically insert user details in membership and create or removes roles in asp.net membership. Now I will explain how to populate roles based on username selection and assign or remove roles to users based on username.

Edit,update,delete user account details in asp.net membership

Introduction:

In this article I will explain how to edit, update and delete user account details programmatically in asp.net membership.

Description:

In previous post I explained clearly how to install asp.net membership database schema in SQL Server  and create users using CreateUserWizard in asp.net membership and programmatically insert user details in asp.net membership. Now I will explain how to modify user account details in asp.net membership.

Programmatically create user in asp.net membership

Introduction:

In this article I will explain how to create users programmatically using asp.net membership concept.

Description:

In previous post I explained clearly how to install asp.net membership database schema in SQL Server and create users using CreateUserWizard . In this post I will explain how to create users programmatically using asp.net membership concept.

ASP.Net Create, manage and delete roles in membership

Introduction:

In this article I will explain how to create new roles and delete roles in asp.net membership.

Description:

In previous post I explained clearly how to install asp.net membership database schema in SQL Server  and create users programmatically in asp.net membership. Now I will explain how to create new roles and delete existing roles in asp.net membership.

Asp.net login control to check user details using Membership concept

Introduction:

In this article I will explain how to use Login Control to validate user details using asp.net membership.

Description:

In previous post I explained clearly how to install asp.net membership database schema in SQL Server and create users using CreateUserWizard in asp.net membership. Here I am using these two concepts to validate user details with Login Control using asp.net membership in our login page.