how insert, Edit, Update and delete data in gridview with sqldatasource using asp.net

Introduction:

In this article I will explain how to insert, edit, update and delete data in gridview with Sqldatasource using asp.net.

Description:

In my previous article I explain clearly how to insert, edit, update and delete data in gridview using asp.net. Now you may think that why he has written the same code with Sqldatasource main reason is if we Sqldatasource we have chance to reduce lot of code in code behind check two posts how much of code in reduced in this post. Now I will explain how to do the insert, edit, update and delete functionality with Sqldatasource here I used some of commands to achieve that functionality those are 

Asp.net insert, Edit, update, delete data in gridview

Introduction:

In this article I will explain how to insert, edit, update and delete data in gridview using asp.net.

Description:

I have one gridview I need to write code to insert data into gridview after that I need to edit that gridview data and update it and if I want to delete the record in grdview we need to delete record simply by click on delete button of particular row to achieve these functionalities I have used some of gridview events those are 

1        1) Onrowcancelingedit

2        2) Onrowediting

3        3) Onrowupdating

4        4) Onrowcancelingedit

5        5) Onrowdeleting

By Using above griview events we can insert, edit, update and delete the data in gridview. My Question is how we can use these events in our coding before to see those details first design  table in database and give name Employee_Details

Asp.net Pass send gridview row value to other page with hyperlink to update row values

Introduction:

In this article I will explain how to send gridview row values to other page and after update that record values return back to the gridview page using asp.net.

Description:

I have a gridview with hyperlink fields here my requirement is if I click on hyperlink of particular row I need to display that particular row values into other page in that page user will edit record values after that if he clicks on update button I need to update that record values and get back to previous home page i.e., gridview page. To achieve this first design the table in database like this

Highlight asp.net gridview rows on mouseover - out using JavaScript

Introduction:

Here I will explain how to highlight gridview rows based on mouseover and mouseout using JavaScript in asp.net.

Description:

During work with one application I got requirement like change gridview rows color based on mouseover and mouseout using asp.net for that I used JavaScript functionality to handle onmouseover and onmouseout situations to implement this one first design aspx page like this 

Trace Mobile number location and Mobile number operator in India or Trace Mobile number Details in India

If you want trace India mobile number details then enter mobile number and get details of mobile number location, mobile number service type and operator type definitely it will helps you to trace the details. Here we won’t get the user details of particular number because of privacy concern but we can get mobile number location, service provider and operation.

how to change textbox background color whenever validation fails using asp.net

Introduction:

 In this article I will explain how to change textbox background whenever validation fails using asp.net.

Description:

I have a one requirement like changing the textboxes background whenever validation fails at that time I used the custom validator and JavaScript function to validate textboxes and change the textboxes background color for that write the following code in your aspx page

how to solve Password length minimum: 7. Non-alphanumeric characters required: 1 and how to remove password restrictions, unique email requirement and question and answer options during user registration in Membership using asp.net.

Introduction:

 In this article I will explain how to solve Password length minimum: 7. Non-alphanumeric characters required: 1 and how to remove password restrictions, unique email requirement and question and answer options during user registration in Membership using asp.net.

Description:

In my previous article I explained clearly how to use Custom database for Membership and how to create user with custom database

To create user in database we need to enter password like abcd@123 then it will accept otherwise it will throw error like length minimum: 7. Non-alphanumeric characters required: 1 but I got requirement like register user without strong password restrictions and no need to enter unique email and without Question and answer options at that time I tried to remove problem by setting some properties in web.config. Follow below steps to change our application to work according our requirements.

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.