.

Introduction of FormView Control:-

FormView Control is fully customize databound control.
It has no rows and no columns.
It just display only single dataitem at a time.
Pagination is must in the formview control to view others record.
We can apply seven template on formview control.
1) ItemTemplate.
2) EditItemTemplate.
3) InsertItemTemplate.
4) HeaderTemplate.
5) FooterTemplate.
6) EmptyDataTemplate.
7) PagerTemplate.



The given program gives the idea of usage of formview control and how to use it.

Place the following code in Default.aspx page(Source Page)

<form id="form1" runat="server">
<div>
<center>
<asp:FormView ID="FormView1" runat="server" BackColor="#DEBA84"
BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2" GridLines="Both" AllowPaging="True"
onitemdeleting="FormView1_ItemDeleting"
oniteminserting="FormView1_ItemInserting"
onitemupdating="FormView1_ItemUpdating" onmodechanging="FormView1_ModeChanging"
onpageindexchanging="FormView1_PageIndexChanging">
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<EditItemTemplate>
EmpNo
<asp:Label ID="Label5" runat="server" Text='<%# Eval("empno") %>'></asp:Label>
<br />
Name
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("ename") %>'></asp:TextBox>
<br />
Address
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("eaddr") %>'></asp:TextBox>
<br />
Salary
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Eval("esal") %>'></asp:TextBox>
<br />

<asp:LinkButton ID="LinkButton4" runat="server" CommandName="update">Update</asp:LinkButton>

<asp:LinkButton ID="LinkButton5" runat="server" CommandName="cancel">Cancel</asp:LinkButton>

</EditItemTemplate>
<HeaderTemplate>
<br />
Details Of Employee
</HeaderTemplate>
<InsertItemTemplate>
EmpNo
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
<br />
Name
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
<br />
Address
<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
<br />
Salary
<asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
<br />

<asp:LinkButton ID="LinkButton6" runat="server" CommandName="insert">Save</asp:LinkButton>

<asp:LinkButton ID="LinkButton7" runat="server" CommandName="cancel">Cancel</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
EmpNo
<asp:Label ID="Label1" runat="server" Text='<%# Eval("empno") %>'></asp:Label>
<br />
Name
<asp:Label ID="Label2" runat="server" Text='<%# Eval("ename") %>'></asp:Label>
<br />
Address
<asp:Label ID="Label3" runat="server" Text='<%# Eval("eaddr") %>'></asp:Label>
<br />
Salary
<asp:Label ID="Label4" runat="server" Text='<%# Eval("esal") %>'></asp:Label>
<br />

<asp:LinkButton ID="LinkButton1" runat="server" CommandName="new" Width="40px">Insert</asp:LinkButton>

<asp:LinkButton ID="LinkButton2" runat="server" CommandName="edit" Width="40px">Edit</asp:LinkButton>

<asp:LinkButton ID="LinkButton3" runat="server" CommandName="delete"
Width="40px">Delete</asp:LinkButton>
</ItemTemplate>
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<EmptyDataTemplate>
No Data <br />
<asp:Button ID="Button1" runat="server" CommandName="new" Text="Add Data" />
</EmptyDataTemplate>
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />

<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />

</asp:FormView>
</center>
</div>
</form>


Place the following code in Default.aspx.cs page

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
{
protected void Page_Load(object sender, EventArgs e)
{
if(Page.IsPostBack == false)
{
form_bind();
}
}

private void form_bind()
{
SqlDataAdapter adp = new SqlDataAdapter("select * from tbemp", "server=baljeet\\sqlexpress;database=dbemp;uid=sa;pwd=12345");
DataSet ds = new DataSet();
adp.Fill(ds);
FormView1.DataSource = ds;
FormView1.DataBind();
}
protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e)
{
Int32 eno, es;
String en, ed;

eno = Convert.ToInt32(((TextBox)(FormView1.FindControl("TextBox4"))).Text);
en = ((TextBox)(FormView1.FindControl("TextBox5"))).Text;
ed = ((TextBox)(FormView1.FindControl("TextBox6"))).Text;
es = Convert.ToInt32(((TextBox)(FormView1.FindControl("TextBox7"))).Text);

SqlConnection con = new SqlConnection("server=baljeet\\sqlexpress;database=dbemp;uid=sa;pwd=12345");
con.Open();
SqlCommand cmd = new SqlCommand("insert into tbemp values(@eno,@en,@ed,@es)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@eno", SqlDbType.Int).Value = eno;
cmd.Parameters.Add("@en", SqlDbType.VarChar, 50).Value = en;
cmd.Parameters.Add("@ed", SqlDbType.VarChar, 50).Value = ed;
cmd.Parameters.Add("@es", SqlDbType.Int).Value = es;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
FormView1.ChangeMode(FormViewMode.ReadOnly);
form_bind();
}
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
Int32 eno, es;
String en, ed;

eno = Convert.ToInt32(((Label)(FormView1.FindControl("Label5"))).Text);
en = ((TextBox)(FormView1.FindControl("TextBox1"))).Text;
ed = ((TextBox)(FormView1.FindControl("TextBox2"))).Text;
es = Convert.ToInt32(((TextBox)(FormView1.FindControl("TextBox3"))).Text);

SqlConnection con = new SqlConnection("server=baljeet\\sqlexpress;database=dbemp;uid=sa;pwd=12345");
con.Open();
SqlCommand cmd = new SqlCommand("update tbemp set ename=@en,eaddr=@ed,esal=@es where empno=@eno", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@eno", SqlDbType.Int).Value = eno;
cmd.Parameters.Add("@en", SqlDbType.VarChar, 50).Value = en;
cmd.Parameters.Add("@ed", SqlDbType.VarChar, 50).Value = ed;
cmd.Parameters.Add("@es", SqlDbType.Int).Value = es;
cmd.ExecuteNonQuery();
cmd.Dispose();
FormView1.ChangeMode(FormViewMode.ReadOnly);
form_bind();
}
protected void FormView1_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
Int32 eno;

eno = Convert.ToInt32(((Label)(FormView1.FindControl("Label1"))).Text);

SqlConnection con = new SqlConnection("server=baljeet\\sqlexpress;database=dbemp;uid=sa;pwd=12345");
con.Open();
SqlCommand cmd = new SqlCommand("delete from tbemp where empno=@eno", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@eno", SqlDbType.Int).Value = eno;
cmd.ExecuteNonQuery();
cmd.Dispose();
form_bind();
}
protected void FormView1_ModeChanging(object sender, FormViewModeEventArgs e)
{
if(e.NewMode == FormViewMode.Edit)
{
FormView1.ChangeMode(FormViewMode.Edit);
}
else if (e.NewMode == FormViewMode.Insert)
{
FormView1.ChangeMode(FormViewMode.Insert);
}
else
{
FormView1.ChangeMode(FormViewMode.ReadOnly);
}
form_bind();
}
protected void FormView1_PageIndexChanging(object sender, FormViewPageEventArgs e)
{
FormView1.PageIndex = e.NewPageIndex;
form_bind();
}
}