Formview control

Hi Rajkamal,

Default.aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

Untitled Page

                DataKeyNames="EmployeeID"
                Gridlines="Both" AllowPaging="true"

                RunAt="server" onitemdeleting="EmployeeFormView_ItemDeleting"
        onpageindexchanging="EmployeeFormView_PageIndexChanging"
        onitemupdating="EmployeeFormView_ItemUpdating"
        oniteminserted="EmployeeFormView_ItemInserted"
        oniteminserting="EmployeeFormView_ItemInserting"
        onitemupdated="EmployeeFormView_ItemUpdated"
        onmodechanging="EmployeeFormView_ModeChanging" BackColor="#FFFF66"
        BorderColor="#FF8080">

                                  forecolor="#999966"/>

Employee ID:	<%# Eval("EmployeeID") %>
First Name:	<%# Eval("FirstName") %>
Last Name:	<%# Eval("LastName") %>
Address:	<%# Eval("Address")%>
Designation:	<%# Eval("Designation")%>
Text="Edit" CommandName="Edit" RunAt="server"/> Text="New" CommandName="New" RunAt="server"/> Text="Delete" CommandName="Delete" RunAt="server"/>

Employee ID:	Text='<%# Bind("EmployeeID") %>' RunAt="Server" />
First Name:	Text='<%# Bind("FirstName") %>' RunAt="Server" />
Last Name:	Text='<%# Bind("LastName") %>' RunAt="Server" />
Address:	Text='<%# Bind("Address") %>' RunAt="Server" />
Designation:	Text='<%# Bind("Designation") %>' RunAt="Server" />
Text="Update" CommandName="Update" RunAt="server"/> Text="Cancel" CommandName="Cancel" RunAt="server"/>

Employee ID:	Text='<%# Bind("EmployeeID") %>' RunAt="Server" />
First Name:	Text='<%# Bind("FirstName") %>' RunAt="Server" />
Last Name:	Text='<%# Bind("LastName") %>' RunAt="Server" />
Address:	Text='<%# Bind("Address") %>' RunAt="Server" />
Designation:	Text='<%# Bind("Designation") %>' RunAt="Server" />
Text="Insert" CommandName="Insert" RunAt="server"/> Text="Cancel" CommandName="Cancel" RunAt="server"/>

Default.aspx.cs code

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    SqlDataAdapter sqlda = new SqlDataAdapter();
    SqlCommand com = new SqlCommand();
    DataTable dt;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindgrid();
        }
    }
    private void bindgrid()
    {
        SqlConnection conn = new SqlConnection(connStr);
        dt = new DataTable();
        com.Connection = conn;
        com.CommandText = "SELECT * FROM Employees";
        sqlda = new SqlDataAdapter(com);
        sqlda.Fill(dt);
        EmployeeFormView.DataSource = dt;
        EmployeeFormView.DataBind();

    }
    protected void EmployeeFormView_PageIndexChanging(object sender, FormViewPageEventArgs e)
    {
        EmployeeFormView.PageIndex = e.NewPageIndex;
        bindgrid();
    }
    protected void EmployeeFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
    {
        DataKey key = EmployeeFormView.DataKey;
        SqlConnection conn = new SqlConnection(connStr);
        com.Connection = conn;
        com.CommandText = "DELETE FROM Employees WHERE EmployeeID='" + key.Value.ToString() + "'";
        conn.Open();
        com.ExecuteNonQuery();
        conn.Close();
        Response.Write( "Record deleted successfully");
        bindgrid();
    }
    protected void EmployeeFormView_ItemUpdating(object sender, FormViewUpdateEventArgs e)
    {

        DataKey key = EmployeeFormView.DataKey;
        TextBox txtFirstName = (TextBox)EmployeeFormView.FindControl("txtFirstName2");
        TextBox txtLastName = (TextBox)EmployeeFormView.FindControl("txtLastName2");
        TextBox txtAddress = (TextBox)EmployeeFormView.FindControl("txtAddress2");
        TextBox txtDesignation = (TextBox)EmployeeFormView.FindControl("txtDesignation2");

        SqlConnection conn = new SqlConnection(connStr);
        com.Connection = conn;
        com.CommandText = "UPDATE Employees SET FirstName ='" + txtFirstName.Text + "',LastName ='" + txtLastName.Text + "',Address ='" + txtAddress.Text + "',Designation ='" + txtDesignation.Text + "'   WHERE EmployeeID='" + key.Value.ToString() + "'";
        conn.Open();
        com.ExecuteNonQuery();
        Response.Write("Record updated successfully");
        bindgrid();
        conn.Close();
    }
    protected void EmployeeFormView_ModeChanging(object sender, FormViewModeEventArgs e)
    {
        EmployeeFormView.ChangeMode(e.NewMode);
        bindgrid();
        if (e.NewMode == FormViewMode.Edit)
        {
            EmployeeFormView.AllowPaging = false;
        }
        else
        {
            EmployeeFormView.AllowPaging = true;
        }
    }
    protected void EmployeeFormView_ItemInserted(object sender, FormViewInsertedEventArgs e)
    {
        EmployeeFormView.ChangeMode(FormViewMode.ReadOnly);
    }
    protected void EmployeeFormView_ItemUpdated(object sender, FormViewUpdatedEventArgs e)
    {
        EmployeeFormView.ChangeMode(FormViewMode.ReadOnly);
    }
    protected void EmployeeFormView_ItemInserting(object sender, FormViewInsertEventArgs e)
    {

        TextBox txtEmployeeID = (TextBox)EmployeeFormView.FindControl("txtEmployeeID1");
        TextBox txtFirstName = (TextBox)EmployeeFormView.FindControl("txtFirstName1");
        TextBox txtLastName = (TextBox)EmployeeFormView.FindControl("txtLastName1");
        TextBox txtAddress = (TextBox)EmployeeFormView.FindControl("txtAddress1");
        TextBox txtDesignation = (TextBox)EmployeeFormView.FindControl("txtDesignation1");

        SqlConnection conn = new SqlConnection(connStr);
        com.Connection = conn;
        com.CommandText = "INSERT INTO Employees Values('" + txtEmployeeID.Text + "','" + txtFirstName.Text + "', '" + txtLastName.Text + "', '" + txtAddress.Text + "', '" + txtDesignation.Text + "')";
        conn.Open();
        com.ExecuteNonQuery();
        Response.Write("Record inserted successfully");
        bindgrid();
        conn.Close();
    }
}

Thanks
If this post helps you mark it as answer