The FormView control is used to display a
single record from a data source in a table. FormView control Display Data with
the FormView Control. The FormView control is similar to the DetailsView. Rather
than using field tags like <asp:BoundField>, the FormView specifies its data
using template tags like <ItemTemplate>. Use the itemTemplate to display
database records. The FormView control allows you to edit, delete, and insert
records.
- Open Visual Studio.
- Add a webForm to your website, name it formView.aspx.
Now drag and drop a FormView control from the
Toolbox on the form.
Figure1
The ASP. NET code for the DataView control.
| <form id="form1" runat="server"> <div style="width: 262px"> <asp:FormView ID="FormView1" runat="server" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" Height="137px" Width="380px" Caption="User Detail" CaptionAlign="Top"> <EditRowStyle /> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <ItemTemplate> UserId: <asp:Label ID ="userid" runat ="server" Text ='<%# Bind("UserId") %>'></asp:Label> <br /> Username: <asp:Label ID ="username" runat ="server" Text ='<%# Bind("Username") %>'></asp:Label> <br /> Email: <asp:Label ID ="useremail" runat ="server" Text ='<%# Bind("Email") %>'></asp:Label> <br /> Address: <asp:Label ID ="useraddress" runat ="server" Text ='<%# Bind("Address") %>'></asp:Label> <br /> </ItemTemplate> <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /> <RowStyle BackColor="#FFFBD6" ForeColor="#333333" /> </asp:FormView> |
Now The following code snippet shows how to connect SQL
database.
Imports
System.Data.SqlClient
Public Class WebForm1
Inherits
System.Web.UI.Page
Dim conn
As New SqlConnection("Data
Source=.;uid=sa;pwd=Password$2;database=master")
Dim ad
As New SqlDataAdapter()
Dim cmd
As New SqlCommand()
Dim
dataTable As
DataTable
Protected Sub Page_Load(ByVal
sender As Object,
ByVal e As
System.EventArgs)
Handles Me.Load
dataTable =
New DataTable()
cmd.Connection = conn
cmd.CommandText =
"SELECT * FROM userinfo1"
ad = New SqlDataAdapter(cmd)
ad.Fill(dataTable)
FormView1.DataSource = dataTable
FormView1.DataBind()
End Sub
End Class
Now run the application.
Figure2
Paging, Border Style and caption.
The ASP. NET code for DataView control property.
<asp:FormView ID="FormView1" runat="server" CellPadding="4"
ForeColor="#333333" Height="137px"
Width="380px"
AllowPaging="True" BorderColor="#FF3399" BorderStyle="Solid"
Caption="User Detail" CaptionAlign="Top">
Now run the application again and test it.
Figure3
Note: You can see a demo of this article by
downloading this application.