.

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();
}
}

Introduction about ListView Control :-

It comes with ASP.NET 3.5.

In ListView we can give our own container.

Two Template are compulsory :- Layout and Item template.

Flow of template :- Layout Template->Group Template-> Item Template.

We Can Apply 11 template on ListView Control.

1) EditItemTemplate

2) AlternatingItemTemplate

3) EmptyDataTemplate

4) EmptyItemTemplate

5) GroupSeparatorTemplate

6) GroupTemplate

7) InsertItemTemplate

8) ItemSeparatorTemplate

9) ItemTemplate

10) LayoutTemplate

11) SelectedItemTemplate

In the following example i shown the pic gallery with the help of ListView Control.

Place the code given below in the Default.aspx page [Source Part] of Design

<form id="form1" runat="server">

<div>

<asp:ListView ID="ListView1" runat="server" GroupItemCount="2">

<LayoutTemplate>

<asp:PlaceHolder ID="groupPlaceHolder" runat="server"></asp:PlaceHolder>

</LayoutTemplate>

<GroupTemplate>

<asp:PlaceHolder ID="itemPlaceHolder" runat="server"></asp:PlaceHolder>

</GroupTemplate>

<ItemTemplate>

<asp:Image ID="Image1" runat="server" ImageUrl='<%#Container.DataItem%>' Width="200" Height="200" />

</ItemTemplate>

<GroupSeparatorTemplate>

<br />

</GroupSeparatorTemplate>

</asp:ListView>

</div>

</form>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

List images = new List();

images.Add("a.jpg");

images.Add("b.jpg");

images.Add("c.jpg");

images.Add("d.jpg");

images.Add("e.jpg");

images.Add("f.jpg");

ListView1.DataSource = images;

ListView1.DataBind();

}

}

We useFile Upload control when we want to upload any kind of file may be text file, doc file or else... So today i share a program with you how to upload multiple file with file upload controls on the same page.


The Following code for Default.aspx Page [Source]

<form id="form1" runat="server">
<div>

<asp:FileUpload ID="FileUpload1" runat="server" />
<br />
<br />
<asp:FileUpload ID="FileUpload2" runat="server" />
<br />
<br />
<asp:FileUpload ID="FileUpload3" runat="server" />
<br />
<br />
<br />
<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
Text="Upload Files" Width="125px" />
<br />
<br />
<br />
<asp:Label ID="Label1" runat="server"></asp:Label>
<br />
<br />


</div>
</form>


The following code for Default.aspx.cs file

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
String filepath = Server.MapPath(".");

HttpFileCollection filecollection = Request.Files;

for (int i = 0; i < filecollection.Count; i++)
{
HttpPostedFile postedfiles = filecollection[i];

try
{
if(postedfiles.ContentLength >0)
{
Label1.Text += postedfiles.ContentType + "
";
Label1.Text += postedfiles.ContentLength + "
";
Label1.Text += System.IO.Path.GetFileName(postedfiles.FileName) +"
";
postedfiles.SaveAs(filepath + "\\" + System.IO.Path.GetFileName(postedfiles.FileName));
}
}
catch(Exception exp)
{
Response.Write(exp.Message);
}

}

}
}

Both MultiView and View Control work together and provided us the capability to make the particular section on and off. It's similiar to the visibility of panel control.

The Following Code for the Default.aspx Page [Source].

<form id="form1" runat="server">
<div>

<asp:MultiView ID="MultiView1" runat="server">
<asp:View ID="View1" runat="server">
<asp:BulletedList ID="BulletedList1" runat="server">
<asp:ListItem>Cricket</asp:ListItem>
<asp:ListItem>Football</asp:ListItem>
<asp:ListItem>Hockey</asp:ListItem>
<asp:ListItem>Carrom</asp:ListItem>
</asp:BulletedList>
<br />
<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
Text="Next View" />
</asp:View>
<asp:View ID="View2" runat="server">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem>India</asp:ListItem>
<asp:ListItem>America</asp:ListItem>
<asp:ListItem>Australia</asp:ListItem>
<asp:ListItem>New Zealand</asp:ListItem>
</asp:DropDownList>
<br />
<br />
<br />
<asp:Button ID="Button3" runat="server" onclick="Button3_Click"
Text="Previous View" />

<asp:Button ID="Button2" runat="server" onclick="Button2_Click"
Text="Next View" />
</asp:View>
<asp:View ID="View3" runat="server">
<asp:CheckBoxList ID="CheckBoxList1" runat="server" AutoPostBack="True"
onselectedindexchanged="CheckBoxList1_SelectedIndexChanged">
<asp:ListItem>Keyboard</asp:ListItem>
<asp:ListItem>Mouse</asp:ListItem>
<asp:ListItem>Monitor</asp:ListItem>
<asp:ListItem>Cabinet</asp:ListItem>
</asp:CheckBoxList>
<br />
<br />
<asp:Button ID="Button4" runat="server" onclick="Button4_Click"
Text="Previous View" />

</asp:View>
<br />
<br />
</asp:MultiView>
</div>

Write the following code for the Default.aspx.cs file

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex += 1;
}
protected void Button2_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex += 1;

}
protected void Button3_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex -= 1;
}
protected void Button4_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex -= 1;
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Response.Write("Your Selected " + DropDownList1.SelectedValue);
}
protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)
{
String str ="";
for(int i=0;i {
if(CheckBoxList1.Items[i].Selected)
{
str += CheckBoxList1.Items[i].Text + ",";
}
}
if (str.Length > 0)
{
str = str.Substring(0, str.Length - 1);
Response.Write(str);
}
}
}

Friend Today again I am Here To Describe Caching in ASP.NET

CACHING:-

Caching is a technique used in computing to increase performance by keeping frequently accessed or expensive data from the memory.

The data stored in the cache memory is fast to retrieve because it does not reprocess.
Normally in the website, the developers keep home page in the cache because in the home page heavy pics are stored.


TYPES OF CACHING:-

1)Output Caching.
2)Fragment Caching
3)Data Caching
a.)File Dependency.
b.)Key Dependency.
c.)Time Dependency.


1)Output Caching :- It is used to store the whole page in the cache. Output cache depends on the duration. It may be parameterized.

2)Fragment Caching :- Store page fragment wise. We achieve fragment cache with the help of WebUserControl. In this caching, whole of the page is not cache just a small information is store in cache. For example we place an image in the WebUserControl and in the WebUserControl source page we specify the duration of cache and after that we drop WebUserControl in the .aspx page.

HOW TO PERFORM MATHEMATICAL OPERATION WITH THE HELP OF COMMON HANDLER.

CODE IN THE DEFAULT.ASPX PAGE:-



Enter the first digit
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

Enter the second digit
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

Sum of two digits
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>


<asp:Button ID="Button1" runat="server" Text="Addition" OnClick="Button1_Click">

<asp:Button ID="Button2" runat="server" Text="Subtraction" OnClick="Button1_Click">

<asp:Button ID="Button3" runat="server" Text="Division"
OnClick="Button1_Click"/>

<asp:Button ID="Button4" runat="server" Text="Multiplication" OnClick="Button1_Click"/>





WRITE CODE IN THE DEFAULT.ASPX.CS PAGE:-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default14 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
if (sender == Button1)
{
TextBox3.Text = Convert.ToString(Convert.ToInt32(TextBox1.Text) + Convert.ToInt32(TextBox2.Text));
}
else if (sender == Button2)
{
TextBox3.Text = Convert.ToString(Convert.ToInt32(TextBox1.Text) - Convert.ToInt32(TextBox2.Text));
}
else if (sender == Button3)
{
TextBox3.Text = Convert.ToString(Convert.ToInt32(TextBox1.Text) / Convert.ToInt32(TextBox2.Text));
}
else
{
TextBox3.Text = Convert.ToString(Convert.ToInt32(TextBox1.Text) * Convert.ToInt32(TextBox2.Text));
}
}
}

Today's I would discuss How to Authenticate Username and Password<


Requirement for this Application.

1)Database --- I have named "dblogin"
2)Table --- I have named "tbuser"
3)Stored Procedure --- I have named "sp_loginCheck"


------------------------------------------------------------------------------------------------

tbuser table 2 columns and both are varchar type.

------------------------
uname upass
------------------------
admin admin
amit amit
------------------------


Code for the stored procedure "sp_loginCheck"

CREATE PROCEDURE sp_loginCheck
(
@uname varchar(50),
@upass varchar(50)
)
AS
declare @abspwd varchar(50)
select @abspwd=upass from tbuser where uname=@uname

if @abspwd is null
return -1
else if @abspwd = @upass
return 1
else
return -2

After save the stored procedure the "create" keyword convert into "alter" keyword

-----------------------------------------------------------------------------------------------
The following code for the Design Page (Source)

<form id="form1" runat="server">
<div>

Username
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<br />
Password
<asp:TextBox ID="TextBox2" runat="server" TextMode="Password"></asp:TextBox>
<br />
<br />

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />

</div>
</form>



------------------------------------------------------------------------------------------------

Following Code For the Default.aspx.cs File (Code 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)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=monty\\baljeet;database=dblogin;uid=sa;pwd=123456789");
con.Open();
SqlCommand cmd = new SqlCommand("sp_loginCheck", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@uname", SqlDbType.VarChar, 50).Value = TextBox1.Text;
cmd.Parameters.Add("@upass", SqlDbType.VarChar, 50).Value = TextBox2.Text;
cmd.Parameters.Add("@ret", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();

Int32 i = Convert.ToInt32(cmd.Parameters["@ret"].Value);
if (i == -1)
{
Response.Write("Wrong User");
}
else if (i == 1)
{
Response.Write("Login");
}
else
{
Response.Write("Wrong Password");
}

}
}

Setting The Display Property Of Validator Controls

The Display property determines how the validation error message is rendered. This property accepts any of the following three possible values:-

1) Static
2) Dynamic
3) None

1) STATIC
By Default, the Display property has the value Static.
The validation error messagge is rendered by the validation cotnrol looks like this

Empty Field

2) DYNAMIC
But if, the Display property has the value Dynamic.
The validation error messagge is rendered by the validation cotnrol looks like this

Empty Field

Both the visibility and display attributes can be used to hide text in browser.

However, text hidden with the visibility attribute (Static) still occupies screen real estate.
On the other hand, text hidden with the display attribute (Dynamic) does not occupies screen real estate.

3) NONE
If you want to prevent the individual validation controls from displaying an error message and display the error message with a validation summary then we use None value for the display attribute

Program of CheckBox Control in ASP.NET

Write The Following Code In The HTML Part Of The ASP.NET


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:CheckBox ID="CheckBox1" runat="server" Text="Cricket" />

<asp:CheckBox ID="CheckBox2" runat="server" Text="Hockey" />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<br />

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />

</div>
</form>
</body>
</html>

Write The Following Code In The Code Part Of The ASP.NET

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;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{

if (CheckBox1.Checked)
{
TextBox1.Text = CheckBox1.Text;
if (CheckBox2.Checked)
{
TextBox1.Text = TextBox1.Text + "," + CheckBox2.Text;
}
}
else if(CheckBox1.Checked)
{
TextBox1.Text = CheckBox1.Text;
}
else if(CheckBox2.Checked)
{
TextBox1.Text = CheckBox2.Text;
}
else
{
TextBox1.Text = "";
}
}
}

Code Snippet For How To Apply Validators In ASP.NET

Create a grammatically-correct sentence in which the following repeating word pair fits:

"hope that hope that"

Hello Friends, Once again I am here to share one of the ADO.NET application,
that are generally used in our daily routine.
Guess it.......Guess........ Yes
How To Apply Template At Runtime

For this application we require: -
1) A table as I had named "tbemp" and its columns are
a) empno
b) ename
c) eaddr
d) esal

2) Two Web User Control named
"WebUserControl.ascx" and "WebUserControl2.ascx"

3) One Web Form called "Default.aspx"

4) RepeaterControl on the WebForm.

------------------------------------------------------------------------------------------------------
In First WebUserControl called "WebUserContro.ascx"

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="WebUserControl.ascx.cs" Inherits="WebUserControl" %>

<table>
<tr style="background-color:Yellow">
<td>
<b>EmpNo :</b><%#Eval("empno")%><br />
<b>Name :</b><%#Eval("ename")%><br />
<b>Address :</b><%#Eval("eaddr")%><br />
<b>Salary :</b><%#Eval("esal")%><br />
</td>
</tr>
</table>


In Second WebUserControl called "WebUserControl2.ascx"

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="WebUserControl2.ascx.cs" Inherits="WebUserControl2" %>

<table>
<tr style="background-color:ThreeDShadow">
<td>
<b>EmpNo :</b><%#Eval("empno")%><br />
<b>Name :</b><%#Eval("ename")%><br />
<b>Address :</b><%#Eval("eaddr")%><br />
<b>Salary :</b><%#Eval("esal")%><br />
</td>
</tr>
</table>


Code for the Default.aspx [Source Mode]

<form id="form1" runat="server">
<div>

<asp:Repeater ID="Repeater1" runat="server">
</asp:Repeater>

</div>
</form>

Code for the Default.aspx.cs

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)
{
Repeater1.ItemTemplate = Page.LoadTemplate("WebUserControl.ascx");
Repeater1.AlternatingItemTemplate = Page.LoadTemplate("WebUserControl2.ascx");

SqlDataAdapter adp = new SqlDataAdapter("select * from tbemp", "server=monty\\baljeet;database=dbemp;uid=sa;pwd=123456789");
DataSet ds = new DataSet();
adp.Fill(ds);
Repeater1.DataSource = ds;
Repeater1.DataBind();

}
}

How to Use Own Command Name in GridView Control

The following Code for the Default.aspx page (Source Page):-

<form id="form1" runat="server">

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

ShowFooter="True" onrowcancelingedit="GridView1_RowCancelingEdit"

onrowcommand="GridView1_RowCommand" onrowediting="GridView1_RowEditing"

onrowupdating="GridView1_RowUpdating" BackColor="#DEBA84"

BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"

CellSpacing="2" onrowdeleting="GridView1_RowDeleting" Width="775px">

<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />

<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />

<Columns>

<asp:TemplateField HeaderText="EmpNo">

<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%#Eval("empno")%>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%#Eval("empno")%>'></asp:Label>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="TextBox1" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name">

<ItemTemplate>

<asp:Label ID="Label3" runat="server" Text='<%#Eval("ename")%>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("ename")%>'></asp:TextBox>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="TextBox3" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Address">

<ItemTemplate>

<asp:Label ID="Label4" runat="server" Text='<%#Eval("eaddr")%>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="TextBox4" runat="server" Text='<%#Eval("eaddr")%>'></asp:TextBox>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="TextBox5" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Salary">

<ItemTemplate>

<asp:Label ID="Label5" runat="server" Text='<%#Eval("esal")%>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="TextBox6" runat="server" Text='<%#Eval("esal")%>'></asp:TextBox>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="TextBox7" runat="server" Text=""></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField>

<ItemTemplate>

<asp:LinkButton ID="LinkButton1" runat="server" Text="EDIT" CommandName="edit"></asp:LinkButton>

<asp:LinkButton ID="LinkButton2" runat="server" Text="DELETE" CommandName="delete"></asp:LinkButton>

</ItemTemplate>

<EditItemTemplate>

<asp:LinkButton ID="LinkButton3" runat="server" Text="UPDATE" CommandName="update"></asp:LinkButton>

<asp:LinkButton ID="LinkButton4" runat="server" Text="CANCEL" CommandName="cancel"></asp:LinkButton>

</EditItemTemplate>

<FooterTemplate>

<asp:LinkButton ID="LinkButton5" runat="server" Text="SAVE" CommandName="save"></asp:LinkButton>

</FooterTemplate>

</asp:TemplateField>

</Columns>

<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />

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

<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />

</asp:GridView>

</div>

</form>

The following Code for the 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)

    {

        grid_bind();

    }

}



public void grid_bind()

{

    SqlDataAdapter adp = new SqlDataAdapter("select * from tbemp",

"server=monty\\baljeet;database=dbemp;uid=sa;pwd=123456789");

    DataSet ds = new DataSet();

    adp.Fill(ds);

    GridView1.DataSource = ds;

    GridView1.DataBind();

}



protected void GridView1_RowUpdating(object sender,

GridViewUpdateEventArgs e)

{

    Int32 empno,esal;

    String ename, eaddr;



    empno = Convert.ToInt32(((Label)

(GridView1.Rows[e.RowIndex].FindControl("Label2"))).Text);

    ename = ((TextBox)

(GridView1.Rows[e.RowIndex].FindControl("TextBox2"))).Text;

    eaddr = ((TextBox)

(GridView1.Rows[e.RowIndex].FindControl("TextBox4"))).Text;

    esal = Convert.ToInt32(((TextBox)

(GridView1.Rows[e.RowIndex].FindControl("TextBox6"))).Text);



    SqlConnection con = new

SqlConnection("server=monty\\baljeet;database=dbemp;uid=sa;

pwd=123456789");

    SqlCommand cmd = new

SqlCommand("update tbemp set ename=@ename,eaddr=@eaddr,esal=@esal

where empno=@empno",con);

    con.Open();

    cmd.Parameters.Add("@empno", SqlDbType.Int).Value = empno;

    cmd.Parameters.Add("@ename", SqlDbType.VarChar,50).

Value = ename;

    cmd.Parameters.Add("@eaddr", SqlDbType.VarChar,50).

Value = eaddr;

    cmd.Parameters.Add("@esal", SqlDbType.Int).Value = esal;

    cmd.ExecuteNonQuery();

    cmd.Dispose();

    con.Close();

    GridView1.EditIndex = -1;

    grid_bind();

}

protected void GridView1_RowEditing(object sender,

GridViewEditEventArgs e)

{

    GridView1.EditIndex = e.NewEditIndex;

    grid_bind();

}

protected void GridView1_RowCancelingEdit(object sender,

GridViewCancelEditEventArgs e)

{

    GridView1.EditIndex = -1;

    grid_bind();

}

protected void GridView1_RowCommand(object sender,

GridViewCommandEventArgs e)

{

    if (e.CommandName == "save")

    {

        Int32 empno, esal;

        String ename, eaddr;



        empno = Convert.ToInt32(((TextBox)

(GridView1.FooterRow.FindControl("TextBox1"))).Text);

        ename = ((TextBox)

(GridView1.FooterRow.FindControl("TextBox3"))).Text;

        eaddr = ((TextBox)

(GridView1.FooterRow.FindControl("TextBox5"))).Text;

        esal = Convert.ToInt32(((TextBox)

(GridView1.FooterRow.FindControl("TextBox7"))).Text);



        SqlConnection con = new

SqlConnection("server=monty\\baljeet;database=dbemp;uid=sa;

pwd=123456789");

        SqlCommand cmd = new

SqlCommand("insert into tbemp values(@empno,@ename,@eaddr,@esal)",

 con);

        con.Open();

        cmd.Parameters.Add("@empno", SqlDbType.Int).Value = empno;

        cmd.Parameters.Add("@ename", SqlDbType.VarChar,50)

.Value = ename;

        cmd.Parameters.Add("@eaddr", SqlDbType.VarChar,50)

.Value = eaddr;

        cmd.Parameters.Add("@esal", SqlDbType.Int).Value = esal;

        cmd.ExecuteNonQuery();

        cmd.Dispose();

        con.Close();

        GridView1.EditIndex = -1;

        grid_bind();

    }



}

protected void GridView1_RowDeleting(object sender,

 GridViewDeleteEventArgs e)

{

    Int32 empno;



    empno = Convert.ToInt32(((Label)

(GridView1.Rows[e.RowIndex].FindControl("Label1"))).Text);



    SqlConnection con = new

SqlConnection("server=monty\\baljeet;database=dbemp;uid=sa;

pwd=123456789");

    SqlCommand cmd = new

SqlCommand("delete from tbemp where empno=@empno", con);

    con.Open();

    cmd.Parameters.Add("@empno", SqlDbType.Int).Value = empno;

    cmd.ExecuteNonQuery();

    cmd.Dispose();

    con.Close();

    GridView1.EditIndex = -1;

    grid_bind();



}

}