<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DataBindingShow.aspx.cs"
Inherits="DemoClassExample.DataBindingShow" %>
<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="style1">
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="RegistrationId" DataSourceID="SqlDataSource1"
PageSize="5">
<Columns>
<asp:TemplateField ShowHeader="False">
<EditItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
Text="Update"></asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit"></asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Delete"
Text="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="RegistrationId" HeaderText="RegistrationId" ReadOnly="True"
SortExpression="RegistrationId" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
<asp:BoundField DataField="MobileNo" HeaderText="MobileNo" SortExpression="MobileNo" />
<asp:BoundField DataField="Course" HeaderText="Course" SortExpression="Course" />
<asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
<asp:BoundField DataField="EmailID" HeaderText="EmailID" SortExpression="EmailID" />
<asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Decofloore2ConnectionString1 %>"
SelectCommand="SELECT * FROM [ShowOnePage]" DataSourceMode="DataSet"
UpdateCommand="Update ShowOnePage set Name=@Name,Address=@Address,MobileNo=@MobileNo,Course=@Course,Sex=@Sex,EmailID=@EmailID,DOB=@DOB where RegistrationId=@RegistrationId"
DeleteCommand="Delete from ShowOnePage where RegistrationId=@RegistrationId"
InsertCommand="Insert into ShowOnePage(RegistrationId,Name,Address,MobileNo,Course,Sex,EmailID,DOB) values(@RegistrationId,@Name,@Address,@MobileNo,@Course,@Sex,@EmailID,@DOB)">
<UpdateParameters>
<asp:Parameter Type="String" Name="Name" />
<asp:Parameter Type="String" Name="Address" />
<asp:Parameter Type="String" Name="MobileNo" />
<asp:Parameter Type="String" Name="Course" />
<asp:Parameter Type="String" Name="Sex" />
<asp:Parameter Type="String" Name="EmailID" />
<asp:Parameter Type="String" Name="DOB" />
<asp:Parameter Type="String" Name="RegistrationId" />
</UpdateParameters>
</asp:SqlDataSource>
<td valign="top">
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
CellPadding="4" DataKeyNames="RegistrationId" DataSourceID="SqlDataSource1" ForeColor="#333333"
GridLines="None" Height="50px" Width="125px">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
<EditRowStyle BackColor="#999999" />
<FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
<Fields>
<asp:BoundField DataField="RegistrationId" HeaderText="RegistrationId" ReadOnly="True"
SortExpression="RegistrationId" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />
<asp:BoundField DataField="MobileNo" HeaderText="MobileNo" SortExpression="MobileNo" />
<asp:BoundField DataField="Course" HeaderText="Course" SortExpression="Course" />
<asp:BoundField DataField="Sex" HeaderText="Sex" SortExpression="Sex" />
<asp:BoundField DataField="EmailID" HeaderText="EmailID" SortExpression="EmailID" />
<asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
</asp:DetailsView>
<tr>
<td rowspan="3">
<asp:ListView ID="ListView1" runat="server" DataKeyNames="RegistrationId" DataSourceID="SqlDataSource1"
InsertItemPosition="LastItem" OnSelectedIndexChanged="ListView1_SelectedIndexChanged">
<AlternatingItemTemplate>
<li style="">RegistrationId:
<asp:Label ID="RegistrationIdLabel" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
<br />
Address:
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
<br />
MobileNo:
<asp:Label ID="MobileNoLabel" runat="server" Text='<%# Eval("MobileNo") %>' />
<br />
Course:
<asp:Label ID="CourseLabel" runat="server" Text='<%# Eval("Course") %>' />
<br />
Sex:
<asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' />
<br />
EmailID:
<asp:Label ID="EmailIDLabel" runat="server" Text='<%# Eval("EmailID") %>' />
<br />
DOB:
<asp:Label ID="DOBLabel" runat="server" Text='<%# Eval("DOB") %>' />
<br />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
</li>
</AlternatingItemTemplate>
<EditItemTemplate>
<li style="">RegistrationId:
<asp:Label ID="RegistrationIdLabel1" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
Address:
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
<br />
MobileNo:
<asp:TextBox ID="MobileNoTextBox" runat="server" Text='<%# Bind("MobileNo") %>' />
<br />
Course:
<asp:TextBox ID="CourseTextBox" runat="server" Text='<%# Bind("Course") %>' />
<br />
Sex:
<asp:TextBox ID="SexTextBox" runat="server" Text='<%# Bind("Sex") %>' />
<br />
EmailID:
<asp:TextBox ID="EmailIDTextBox" runat="server" Text='<%# Bind("EmailID") %>' />
<br />
DOB:
<asp:TextBox ID="DOBTextBox" runat="server" Text='<%# Bind("DOB") %>' />
<br />
<asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
</li>
</EditItemTemplate>
<EmptyDataTemplate>
No data was returned.
</EmptyDataTemplate>
<InsertItemTemplate>
<li style="">RegistrationId:
<asp:TextBox ID="RegistrationIdTextBox" runat="server" Text='<%# Bind("RegistrationId") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
Address:
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
<br />
MobileNo:
<asp:TextBox ID="MobileNoTextBox" runat="server" Text='<%# Bind("MobileNo") %>' />
<br />
Course:
<asp:TextBox ID="CourseTextBox" runat="server" Text='<%# Bind("Course") %>' />
<br />
Sex:
<asp:TextBox ID="SexTextBox" runat="server" Text='<%# Bind("Sex") %>' />
<br />
EmailID:
<asp:TextBox ID="EmailIDTextBox" runat="server" Text='<%# Bind("EmailID") %>' />
<br />
DOB:
<asp:TextBox ID="DOBTextBox" runat="server" Text='<%# Bind("DOB") %>' />
<br />
<asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
</li>
</InsertItemTemplate>
<ItemSeparatorTemplate>
<br />
</ItemSeparatorTemplate>
<ItemTemplate>
<li style="">RegistrationId:
<asp:Label ID="RegistrationIdLabel" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
<br />
Address:
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
<br />
MobileNo:
<asp:Label ID="MobileNoLabel" runat="server" Text='<%# Eval("MobileNo") %>' />
<br />
Course:
<asp:Label ID="CourseLabel" runat="server" Text='<%# Eval("Course") %>' />
<br />
Sex:
<asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' />
<br />
EmailID:
<asp:Label ID="EmailIDLabel" runat="server" Text='<%# Eval("EmailID") %>' />
<br />
DOB:
<asp:Label ID="DOBLabel" runat="server" Text='<%# Eval("DOB") %>' />
<br />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
</li>
</ItemTemplate>
<LayoutTemplate>
<ul id="itemPlaceholderContainer" runat="server" style="">
<li runat="server" id="itemPlaceholder" />
</ul>
<div style="">
<asp:DataPager ID="DataPager1" runat="server">
<Fields>
<asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" />
</Fields>
</asp:DataPager>
</div>
</LayoutTemplate>
<SelectedItemTemplate>
<li style="">RegistrationId:
<asp:Label ID="RegistrationIdLabel" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
<br />
Address:
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
<br />
MobileNo:
<asp:Label ID="MobileNoLabel" runat="server" Text='<%# Eval("MobileNo") %>' />
<br />
Course:
<asp:Label ID="CourseLabel" runat="server" Text='<%# Eval("Course") %>' />
<br />
Sex:
<asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' />
<br />
EmailID:
<asp:Label ID="EmailIDLabel" runat="server" Text='<%# Eval("EmailID") %>' />
<br />
DOB:
<asp:Label ID="DOBLabel" runat="server" Text='<%# Eval("DOB") %>' />
<br />
<asp:Button ID="EditButton" runat="server" CommandName="Edit" Text="Edit" />
<asp:Button ID="DeleteButton" runat="server" CommandName="Delete" Text="Delete" />
</li>
</SelectedItemTemplate>
</asp:ListView>
<td valign="top">
<asp:FormView ID="FormView1" runat="server" AllowPaging="True" CellPadding="4" DataKeyNames="RegistrationId"
DataSourceID="SqlDataSource1" ForeColor="#333333" OnPageIndexChanging="FormView1_PageIndexChanging">
<EditItemTemplate>
RegistrationId:
<asp:Label ID="RegistrationIdLabel1" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
Address:
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
<br />
MobileNo:
<asp:TextBox ID="MobileNoTextBox" runat="server" Text='<%# Bind("MobileNo") %>' />
<br />
Course:
<asp:TextBox ID="CourseTextBox" runat="server" Text='<%# Bind("Course") %>' />
<br />
Sex:
<asp:TextBox ID="SexTextBox" runat="server" Text='<%# Bind("Sex") %>' />
<br />
EmailID:
<asp:TextBox ID="EmailIDTextBox" runat="server" Text='<%# Bind("EmailID") %>' />
<br />
DOB:
<asp:TextBox ID="DOBTextBox" runat="server" Text='<%# Bind("DOB") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False"
CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<InsertItemTemplate>
RegistrationId:
<asp:TextBox ID="RegistrationIdTextBox" runat="server" Text='<%# Bind("RegistrationId") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
Address:
<asp:TextBox ID="AddressTextBox" runat="server" Text='<%# Bind("Address") %>' />
<br />
MobileNo:
<asp:TextBox ID="MobileNoTextBox" runat="server" Text='<%# Bind("MobileNo") %>' />
<br />
Course:
<asp:TextBox ID="CourseTextBox" runat="server" Text='<%# Bind("Course") %>' />
<br />
Sex:
<asp:TextBox ID="SexTextBox" runat="server" Text='<%# Bind("Sex") %>' />
<br />
EmailID:
<asp:TextBox ID="EmailIDTextBox" runat="server" Text='<%# Bind("EmailID") %>' />
<br />
DOB:
<asp:TextBox ID="DOBTextBox" runat="server" Text='<%# Bind("DOB") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False"
CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
RegistrationId:
<asp:Label ID="RegistrationIdLabel" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Bind("Name") %>' />
<br />
Address:
<asp:Label ID="AddressLabel" runat="server" Text='<%# Bind("Address") %>' />
<br />
MobileNo:
<asp:Label ID="MobileNoLabel" runat="server" Text='<%# Bind("MobileNo") %>' />
<br />
Course:
<asp:Label ID="CourseLabel" runat="server" Text='<%# Bind("Course") %>' />
<br />
Sex:
<asp:Label ID="SexLabel" runat="server" Text='<%# Bind("Sex") %>' />
<br />
EmailID:
<asp:Label ID="EmailIDLabel" runat="server" Text='<%# Bind("EmailID") %>' />
<br />
DOB:
<asp:Label ID="DOBLabel" runat="server" Text='<%# Bind("DOB") %>' />
<br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit" />
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
Text="Delete" />
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
Text="New" />
</ItemTemplate>
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
</asp:FormView>
<tr>
<td valign="top">
<asp:DataList ID="DataList1" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"
BorderWidth="1px" CellPadding="2" DataKeyField="RegistrationId" DataSourceID="SqlDataSource1"
ForeColor="Black">
<AlternatingItemStyle BackColor="PaleGoldenrod" />
<FooterStyle BackColor="Tan" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<ItemTemplate>
RegistrationId:
<asp:Label ID="RegistrationIdLabel" runat="server" Text='<%# Eval("RegistrationId") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
<br />
Address:
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' />
<br />
MobileNo:
<asp:Label ID="MobileNoLabel" runat="server" Text='<%# Eval("MobileNo") %>' />
<br />
Course:
<asp:Label ID="CourseLabel" runat="server" Text='<%# Eval("Course") %>' />
<br />
Sex:
<asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' />
<br />
EmailID:
<asp:Label ID="EmailIDLabel" runat="server" Text='<%# Eval("EmailID") %>' />
<br />
DOB:
<asp:Label ID="DOBLabel" runat="server" Text='<%# Eval("DOB") %>' />
<br />
<br />
</ItemTemplate>
<SelectedItemStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
</asp:DataList>
<tr>
<td valign="top">
<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1">
<Series>
<asp:Series ChartType="StackedColumn" Name="Series1" XValueMember="Course" YValueMembers="MobileNo"
YValuesPerPoint="2">
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
</table>
</div>
</form>
</body>
</html>
0 comments
Post a Comment