Programming Notes – Matt Jorgensen

November 1, 2007

.NET ajax autosave

Filed under: ajax, dotNet — Tags: — flexprimer @ 1:36 pm

Ajax list application for .NET. First download the ajax template for visual studio (or visual web dev).
master page:

<%@ Master Language=”C#” AutoEventWireup=”true” CodeFile=”MasterPage.master.cs” Inherits=”MasterPage” %>

<!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>Untitled Page</title>
</head>
<body>
<h2>List App</h2>
<form id=”form1″ runat=”server”>
<div>
<asp:contentplaceholder id=”ContentPlaceHolder1″ runat=”server”>
</asp:contentplaceholder>
</div>
</form>
</body>
</html>

default.aspx page:

<%@ Page Language=”C#” MasterPageFile=”~/MasterPage.master” AutoEventWireup=”true” CodeFile=”Default.aspx.cs” Inherits=”_Default” Title=”Untitled Page” %>

<asp:Content ID=”Content1″ ContentPlaceHolderID=”ContentPlaceHolder1″ Runat=”Server”>

<div class=”body”>

<asp:ScriptManager ID=”ScriptManager1″ runat=”server”>
</asp:ScriptManager>

<p>This application lets users build to-do lists. It was built in .NET and utilizes Ajax interaction.</p><br />

<strong>List items:</strong>

<br /><br />

Status
<asp:DropDownList ID=”DropDownList1″ runat=”server” AutoPostBack=”True” style=”background-color: beige”>
<asp:ListItem Selected=”True” Value=”False”>View Active Items</asp:ListItem>
<asp:ListItem Value=”True”>View Completed Items</asp:ListItem>
</asp:DropDownList>

<br /><br />

<asp:UpdatePanel ID=”UpdatePanel1″ runat=”server”>
<ContentTemplate>
<asp:GridView ID=”GridView1″ runat=”server” AllowPaging=”True” AllowSorting=”True” AutoGenerateColumns=”False” DataKeyNames=”TaskId”
DataSourceID=”ObjectDataSource1″ AlternatingRowStyle-BackColor=Beige GridLines=”Vertical” BackColor=”White” BorderColor=”#DEDFDE” BorderStyle=”None” BorderWidth=”1px” CellPadding=”4″ ForeColor=”Black”>
<Columns>
<asp:CommandField ShowEditButton=”True” />
<asp:BoundField DataField=”TaskId” HeaderText=”TaskId” InsertVisible=”False” ReadOnly=”True”
SortExpression=”TaskId” />
<asp:BoundField DataField=”Name” HeaderText=”Name” SortExpression=”Name” />
<asp:CheckBoxField DataField=”Complete” HeaderText=”Complete” SortExpression=”Complete” />
</Columns>
<FooterStyle BackColor=”#CCCC99″ />
<RowStyle BackColor=”#F7F7DE” />
<SelectedRowStyle BackColor=”#CE5D5A” Font-Bold=”True” ForeColor=”White” />
<PagerStyle BackColor=”#F7F7DE” ForeColor=”Black” HorizontalAlign=”Right” />
<HeaderStyle BackColor=”#6B696B” Font-Bold=”True” ForeColor=”White” />
<AlternatingRowStyle BackColor=”White” />
</asp:GridView>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID=”DropDownList1″ EventName=”SelectedIndexChanged” />
</Triggers>
</asp:UpdatePanel>

<p></p><br />

<strong>Insert new item:</strong>

<br /><br />

<asp:UpdatePanel ID=”UpdatePanel2″ runat=”server” UpdateMode=Conditional>
<ContentTemplate>
<asp:DetailsView ID=”DetailsView1″ runat=”server” Height=”50px” Width=”125px” AutoGenerateRows=”False” DataKeyNames=”TaskId” DataSourceID=”ObjectDataSource1″ DefaultMode=”Insert” GridLines=None>
<Fields>
<asp:BoundField DataField=”TaskId” HeaderText=”TaskId” InsertVisible=”False” ReadOnly=”True”
SortExpression=”TaskId” />
<asp:BoundField DataField=”Name” HeaderText=”Name” SortExpression=”Name” />
<asp:CheckBoxField DataField=”Complete” HeaderText=”Complete” SortExpression=”Complete” />
<asp:CommandField ShowInsertButton=”True” />
</Fields>
</asp:DetailsView>
</ContentTemplate>
</asp:UpdatePanel>

<asp:ObjectDataSource ID=”ObjectDataSource1″ runat=”server” DeleteMethod=”Delete”
InsertMethod=”Insert” OldValuesParameterFormatString=”original_{0}” SelectMethod=”GetTasksByStatus”
TypeName=”TasksDataSetTableAdapters.TasksTableAdapter” UpdateMethod=”Update”>
<DeleteParameters>
<asp:Parameter Name=”Original_TaskId” Type=”Int32″ />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name=”Name” Type=”String” />
<asp:Parameter Name=”Complete” Type=”Boolean” />
<asp:Parameter Name=”Original_TaskId” Type=”Int32″ />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID=”DropDownList1″ Name=”IsComplete” PropertyName=”SelectedValue”
Type=”Boolean” />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name=”Name” Type=”String” />
<asp:Parameter Name=”Complete” Type=”Boolean” />
</InsertParameters>
</asp:ObjectDataSource>

<br /><br />-Matt Jorgensen (http://excession.wordpress.com/about/)

</div>

</asp:Content>

October 29, 2007

.NET data access layer

Filed under: dotNet — Tags: — flexprimer @ 4:09 pm

Good overview of the .NET data access layer, by Scott Mitchell:

http://www.asp.net/learn/data-access/tutorial-01-cs.aspx

Theme: Silver is the New Black. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.