Create asp.net membership database schema in SQL Server | Create User using CreateUserWizard control in asp.net

Introduction:

 In this article I will explain how to install asp.net Membership database schema in Sql Server.

Description:

In one of my project I got requirement like using asp.net membership concept with custom database. First of all we learn what is asp.net membership? And why we need to use this one?
ASP.NET membership gives you a built-in way to validate and store user credentials. ASP.NET membership therefore helps you manage user authentication in your Web sites. You can use ASP.NET membership with ASP.NET Forms authentication or with the ASP.NET login controls to create a complete system for authenticating users.
By Using ASP.NET membership we can create new users and passwords and we can authenticate users who visit your site. You can authenticate users programmatically, or you can use the ASP.NET login controls to create a complete authentication system that requires little or no code and we can manage passwords, which includes creating, changing, and resetting them.

HttpContext.Current.User.Identity.Name returns null or empty string value

Introduction

Here I will explain how to solve problem of HttpContext.Current.User.Identity.Name returns null or empty string value.

Dsecription

I have one requirement like getting system username based on that check the permissions of user if user has sufficient permission I need to allow that person to view the particular page otherwise I don’t want give chance to show the page for that I have written code to get username like this 

SQL Server- get list of column names and datatypes of a table

Introduction:

Here I will explain how to get the column names and corresponding datatypes in particular table using SQL Server.

Description:

I have one table with lot columns in database at that time I tried to know the column names and corresponding datatypes and their maximum sizes in particular table for that I written the following query in SQL server to get column names and datatypes in particular table.

Ajax Cascading Dropdownlist Sample with database using asp.net

Introduction:

Here I will explain how to use Ajax cascading dropdownlist with database using asp.net

Description:

In my previous article I explained how to populate dropdown based on other dropdown using asp.net now I will explain how to use Ajax cascading dropdownlist in asp.net.

Here I already explained how to populate dropdown based on another dropdown but now why I am explaining about this Ajax cascading dropdownlist because if we use this Ajax cascading dropdownlist we can get the dropdown data without any postback operation and we don’t need to write extra code to disable dropdowns based on otherdropdown selection all the futures available with this Ajax cascading dropdown directly but here we need to write webservices to populate the dropdowns with data. 

how to create online poll system with percentage graphs using asp.net

Introduction

Here I will explain how to create online poll system with percentage graphs using asp.net.

Description:

In many websites we will see online polls like which browser is best browser? We can submit our votes to these polls and they will display result with graphs after seen all these polls I tried to implement simple application for online polls with percentage graphs using as.net.

Here I am using XML to store all the poll options and retrieving all the options and displaying result based on polls options. Here I need to say one thing before implement this application I don’t know the exact purpose of XML whenever I implement this application I got idea regarding XML. XML is used to store the data and we can use it in any application and it will support for all the languages. Here I explained clearly how to insert and retrieve data from XML and how to bind that data to repeater

how to get username in login control using asp.net membership

Introduction

Here I will explain how can we get username and userid of currently logged user in asp.net membership.

Description

I am working on application by using login control in asp.net at that time I got requirement like getting username and user id of logged in user for that I have written code like this to get logged in user username and userid in asp.net membership.

how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and retrieve images from database using asp.net

Introduction

Here I will explain how insert and retrieve images from database and how to bind images to gridview using asp.net.

Description:

I have worked on one social networking site at that time we save all the images in to directory folder and we save image path into database at that time I got idea to implement concept like inserting images into database and retrieving the images from database and binding images to gridview using asp.net for that we need follow below steps

Asp.net Delete gridview records with confirmationbox example

Introduction

Here I will explain how to delete records in gridview with confirmationbox message in asp.net.

Description:

I designed gridview with linkbutton that contains user information details. Here my requirement is whenever user clicks on link button at that time I need to display confirmation message and if user clicks on ok button in confirmation box I want to delete record from database otherwise no action should perform on particular record. For that we need to follow below steps 

Design your aspx page like this 

Asp.net show the confirmationbox using javascript

Introduction

Here I will explain how to show the confirmation box using JavaScript in asp.net.

Description

I have one button whenever user clicks on that button I need to show one confirmation box if user clicks on ok button I need to execute code in button click event or if he clicks on cancel button nothing to display and the page should not be postback. How we can implement that one in our application? To implement this concept follow these steps

Design your aspx page like this 

how to restrict user to enter only numbers in textbox using javascript and how to restrict user to enter only 10 digits(mobile number) in textbox using javascript or how to restrict user to enter only alphanumeric in textbox using javascript

Introduction

Here I will explain how to restrict user to allow only numbers in textbox and how to restrict user to enter only 10 digits mobile number using JavaScript and I will explain how to allow only numbers and alphabets in textbox using JavaScript.

Description

I have a one textbox now I need to allow user to enter only numbers not more than that if user try to enter characters or alphabets I don’t want to allow those characters in textbox for that I have written one JavaScript function to allow only numbers and allow only 10 numbers.

how to encrypt and decrypt password and stored in database using asp.net or encrypt or decrypt user password with c#

Introduction

Here I will explain how to encrypt data and save it in database and how to decrypt encrypted data in database using asp.net

Description

First we will learn what is encryption and decryption

Encryption is the process of translating plain text data into something that appears to be random and meaningless.

Decryption is the process of translating random and meaningless data to plain text.

Why we need to use this Encryption and decryption processes

 By using this process we can hide original data and display some junk data based on this we can provide some security for our data.

SQL Server 2008 ERROR: Saving changes are not permitted. The Changes you have made require the following tables to be dropped and re-created.

Introduction

Here I will explain how to solve problem in SQL Server 2008 Saving changes are not permitted.

Description

 I installed SQL Server 2008 and I created one new database after that I created one table and saved it everything working fine again I opened newly created table to change column name previously I entered wrong name again I changed column name and if I am trying to save that modifications I got error like this

how to bind Datagridview in windows application using c#.net

Introduction

Here I will explain how to bind Datagridview in windows application using c#.net.

Description

I have started working on windows application at that time I don’t know how to use Datagridview and other controls. I face some problems to bind data to Datagridview and to other controls that’s why I am writing this post to explain how to bind data to Datagridview in windows application. In windows application binding Datagridview is somewhat different when compared with web application Datagridview binding.

Asp.net Read/insert data into XML file and bind data to DataList

Introduction

Here I will explain how to insert data into XML and how to retrieve data from XML and how to bind data to DataList using asp.net.

Description:

XML means Extensible markup language why we need to use this one because by using XML we can store the data and we can easily retrieve and display the data without using database in our applications.if we need to display dynamic data in our application it will take time to conenct database and retrive data from database but if use XML to store data we can do operations with xml file directly without using database. If we store data in database that is incompatible to some of the computer applications but if we store data in XML format it will support for all applications. It is independent for all software applications and it is accessible with all applications.