<%@ Page Language="VB"
Trace="False" Debug="True" %>
<%@ Register TagPrefix="wmx"
Namespace="Microsoft.Saturn.Framework.Web.UI"
Assembly="Microsoft.Saturn.Framework, Version=0.5.464.0, Culture=neutral,
PublicKeyToken=6f763c9966660626" %>
<script runat="server">
' Insert page code here
'
Sub Page_Load(sender As
Object, e As EventArgs)
SqlDataSourceControl1.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings("ColtAtAspAlliance"))
DropDownList1.DataBind()
DataGrid1.DataBind()
DataList1.DataBind()
Repeater1.DataBind()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server" ID="Form1">
<p>
<wmx:SqlDataSourceControl id="SqlDataSourceControl1" runat="server" UpdateCommand="UPDATE
[Employees] SET
[LastName]=@LastName,[FirstName]=@FirstName,[Title]=@Title,[TitleOfCourtesy]=@TitleOfCourtesy,[BirthDate]=@BirthDate,[HireDate]=@HireDate,[Address]=@Address,[City]=@City,[Region]=@Region,[PostalCode]=@PostalCode,[Country]=@Country,[HomePhone]=@HomePhone,[Extension]=@Extension,[Photo]=@Photo,[Notes]=@Notes,[ReportsTo]=@ReportsTo,[PhotoPath]=@PhotoPath
WHERE [EmployeeID]=@EmployeeID" SelectCommand="SELECT *
FROM [Employees]" AutoGenerateUpdateCommand="False" DeleteCommand="DELETE [Employees] WHERE EmployeID =
@EmployeeID"></wmx:SqlDataSourceControl>
</p>
<p>
Employee Details (MxDataGrid):
</p>
<p>
<wmx:MxDataGrid id="MxDataGrid1" runat="server" DataSourceControlID="SqlDataSourceControl1" BorderColor="#CCCCCC" AllowSorting="True" AutoGenerateFields="False" AllowPaging="True" BackColor="White" CellPadding="3" DataKeyField="EmployeeID" BorderWidth="1px" BorderStyle="None" DataMember="Employees">
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#669999"></SelectedItemStyle>
<ItemStyle forecolor="#000066"></ItemStyle>
<FooterStyle forecolor="#000066" backcolor="White"></FooterStyle>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#006699"></HeaderStyle>
<PagerStyle horizontalalign="Center" forecolor="#000066" backcolor="White" mode="NumericPages"></PagerStyle>
<Fields>
<wmx:BoundField DataField="EmployeeID" SortExpression="EmployeeID" HeaderText="EmployeeID"></wmx:BoundField>
<wmx:BoundField DataField="LastName" SortExpression="LastName" HeaderText="LastName"></wmx:BoundField>
<wmx:BoundField DataField="FirstName" SortExpression="FirstName" HeaderText="FirstName"></wmx:BoundField>
<wmx:BoundField DataField="Title" SortExpression="Title" HeaderText="Title"></wmx:BoundField>
<wmx:BoundField DataField="TitleOfCourtesy"
SortExpression="TitleOfCourtesy" HeaderText="TitleOfCourtesy"></wmx:BoundField>
<wmx:BoundField DataField="BirthDate" SortExpression="BirthDate" HeaderText="BirthDate"></wmx:BoundField>
<wmx:BoundField DataField="HireDate" SortExpression="HireDate" HeaderText="HireDate"></wmx:BoundField>
<wmx:BoundField DataField="Address" SortExpression="Address" HeaderText="Address"></wmx:BoundField>
<wmx:BoundField DataField="City" SortExpression="City" HeaderText="City"></wmx:BoundField>
<wmx:BoundField DataField="Region" SortExpression="Region" HeaderText="Region"></wmx:BoundField>
<wmx:BoundField DataField="PostalCode" SortExpression="PostalCode" HeaderText="PostalCode"></wmx:BoundField>
<wmx:BoundField DataField="Country" SortExpression="Country" HeaderText="Country"></wmx:BoundField>
<wmx:BoundField DataField="HomePhone" SortExpression="HomePhone" HeaderText="HomePhone"></wmx:BoundField>
<wmx:BoundField DataField="Extension" SortExpression="Extension" HeaderText="Extension"></wmx:BoundField>
<wmx:BoundField DataField="Photo" SortExpression="Photo" HeaderText="Photo"></wmx:BoundField>
<wmx:BoundField DataField="Notes" SortExpression="Notes" HeaderText="Notes"></wmx:BoundField>
<wmx:BoundField DataField="ReportsTo" SortExpression="ReportsTo" HeaderText="ReportsTo"></wmx:BoundField>
<wmx:BoundField DataField="PhotoPath" SortExpression="PhotoPath" HeaderText="PhotoPath"></wmx:BoundField>
</Fields>
</wmx:MxDataGrid>
</p>
<p>
</p>
<hr color="black" size="4" />
<p>
Employee Listing:<asp:DropDownList id="DropDownList1" runat="server" DataMember="Table" DataSource="<%# SqlDataSourceControl1 %>" DataTextField="FirstName" DataValueField="EmployeeID"></asp:DropDownList>
</p>
<hr color="black" size="4" />
<p>
Employee Details (DataGrid):
</p>
<p>
<asp:DataGrid id="DataGrid1" runat="server" BorderColor="#999999" BackColor="White" CellPadding="3" DataKeyField="EmployeeID" BorderWidth="1px" BorderStyle="None" DataMember="Table" DataSource="<%#
SqlDataSourceControl1 %>" GridLines="Vertical">
<FooterStyle forecolor="Black" backcolor="#CCCCCC"></FooterStyle>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#000084"></HeaderStyle>
<PagerStyle horizontalalign="Center" forecolor="Black" backcolor="#999999" mode="NumericPages"></PagerStyle>
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#008A8C"></SelectedItemStyle>
<AlternatingItemStyle backcolor="#DCDCDC"></AlternatingItemStyle>
<ItemStyle forecolor="Black" backcolor="#EEEEEE"></ItemStyle>
</asp:DataGrid>
</p>
<hr color="black" size="4" />
<p>
Employee Details (DataList):
</p>
<p>
<asp:DataList id="DataList1" runat="server" BorderColor="#999999" BackColor="White" CellPadding="3" DataKeyField="EmployeeID" BorderWidth="1px" BorderStyle="None" DataMember="Table" DataSource="<%#
SqlDataSourceControl1 %>" GridLines="Vertical" RepeatDirection="Horizontal">
<ItemStyle forecolor="Black" backcolor="#EEEEEE"></ItemStyle>
<FooterStyle forecolor="Black" backcolor="#CCCCCC"></FooterStyle>
<HeaderStyle font-bold="True" forecolor="White" backcolor="#000084"></HeaderStyle>
<SelectedItemStyle font-bold="True" forecolor="White" backcolor="#008A8C"></SelectedItemStyle>
<ItemTemplate>
<asp:Label id="Label1" runat="server" text='<%#
Container.DataItem("FirstName") %>'></asp:Label> <asp:Label id="Label2" runat="server" text='<%#
Container.DataItem("LastName") %>'></asp:Label>
</ItemTemplate>
<AlternatingItemStyle backcolor="#DCDCDC"></AlternatingItemStyle>
<SeparatorTemplate>
|
</SeparatorTemplate>
</asp:DataList>
</p>
<hr color="black" size="4" />
<p>
Employee Details (Repeater):
</p>
<p>
<asp:Repeater id="Repeater1" runat="server" DataMember="Table" DataSource="<%#
SqlDataSourceControl1 %>">
<ItemTemplate>
<%#
Container.DataItem("FirstName") %>
</ItemTemplate>
<SeparatorTemplate>
--
</SeparatorTemplate>
</asp:Repeater>
</p>
<!-- Insert content here
-->
</form>
</body>
</html>