建立这个日志。
I will publish news about all TOP projects here.
Here is a simple list of current TOP projects:
1)
Top Widgets(https://topwidgets.googlecode.com/)2)
Top Runner All(https://sourceforge.net/projects/servclipse)3)And I will hold all other simple library here.
The first will be "Top Proxy".
It is made for Top Widgets to realize SSO function.
I will update code soon.
某子，以下代码是一个典型的用户注册页，使用了AccessDataSource，请参考，注意.Net framework一定调到v2：
<%@ Page Language="C#" Title="Add new user" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<script runat="server" type="text/C#">
void ButtonSubmit_Click(object sender, EventArgs e)
{
//提交提示语, 需要翻译
LabelFeedback1.Text = "Your name is: " + TextBoxUsername.Text;
LabelFeedback2.Text = "Your e-mail address is: " + TextBoxEmail.Text;
LabelFeedback3.Text = "Your address is: " + TextBoxStreet.Text + " " + TextBoxSuburb + "," + DropDownListState.Text + " " + TextBoxPostcode.Text;
LabelFeedback4.Text = "Your blog is: " + TextBoxURL.Text;
//提交参数赋值
UsersDataSource.InsertParameters[0].DefaultValue = TextBoxUsername.Text;
UsersDataSource.InsertParameters[1].DefaultValue = TextBoxPassword.Text;
UsersDataSource.InsertParameters[2].DefaultValue = TextBoxEmail.Text;
UsersDataSource.InsertParameters[3].DefaultValue = RadioButtonListGender.Text;
UsersDataSource.InsertParameters[4].DefaultValue = ListBoxAge.Text;
UsersDataSource.InsertParameters[5].DefaultValue = TextBoxStreet.Text;
UsersDataSource.InsertParameters[6].DefaultValue = TextBoxSuburb.Text;
UsersDataSource.InsertParameters[7].DefaultValue = DropDownListState.Text;
UsersDataSource.InsertParameters[8].DefaultValue = TextBoxPostcode.Text;
UsersDataSource.Insert();
}
</script>
<html>
<head>
<title></title>
<style type="text/css">
</style>
</head>
<body>
<form runat="server" id="form1">
<table>
<!--提示|输入|验证-->
<!--提示和验证错误消息需要翻译-->
<tr>
<td colspan="3" align="center">
<asp:Label ID="Label1" runat="server" Text="User Registration"></asp:Label>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelUsername" runat="server" Text="Username:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxUsername" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator runat="server" ID="ValidateUsername" ErrorMessage="<p><b>Please enter a valid username.</b>"
ControlToValidate="TextBoxUsername">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelEmail" runat="server" Text="E-mail address:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxEmail" runat="server"></asp:TextBox>
</td>
<td>
<asp:RegularExpressionValidator ID="ValidateEmail2" runat="server" ControlToValidate="TextBoxEmail"
ValidationExpression=".*@.*\..*" ErrorMessage="Invalid E-mail address." Display="Dynamic">
</asp:RegularExpressionValidator>
<asp:RequiredFieldValidator ID="ValidateEmail1" runat="server" ControlToValidate="TextBoxEmail"
ErrorMessage="<p><br>Please enter valid e-mail address.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelPassword" runat="server" Text="Password:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxPassword" runat="server" TextMode="Password"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="ValidatePassword" runat="server" ControlToValidate="TextBoxPassword"
ErrorMessage="<p><br>Please enter password.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelConPassword" runat="server" Text="Confirm password:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxConPassword" runat="server" TextMode="Password"></asp:TextBox>
</td>
<td>
<asp:CompareValidator ID="ValidateConPassword2" runat="server" ControlToValidate="TextBoxConPassword"
ControlToCompare="TextBoxPassword" Type="String" Operator="Equal" ErrorMessage="<p><br>Two passwords do not match.</br>">
</asp:CompareValidator>
<asp:RequiredFieldValidator ID="ValidateConPassword1" runat="server" ControlToValidate="TextBoxConPassword"
ErrorMessage="<p><br>Please confirm your password.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelGender" runat="server" Text="Gender:"></asp:Label>
</td>
<td>
<asp:RadioButtonList ID="RadioButtonListGender" runat="server">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:RadioButtonList>
</td>
<td>
<asp:RequiredFieldValidator runat="server" ID="ValidateGender" ControlToValidate="RadioButtonListGender"
ErrorMessage="<p><br>Please select your gender.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelAge" runat="server" Text="Age:"></asp:Label>
</td>
<td>
<asp:ListBox ID="ListBoxAge" runat="server">
<asp:ListItem>1-9</asp:ListItem>
<asp:ListItem>10-19</asp:ListItem>
<asp:ListItem>20-29</asp:ListItem>
<asp:ListItem>30-39</asp:ListItem>
<asp:ListItem>40-49</asp:ListItem>
<asp:ListItem>50-59</asp:ListItem>
<asp:ListItem>60 above</asp:ListItem>
</asp:ListBox>
</td>
<td>
<asp:RequiredFieldValidator ID="ValidateAge1" runat="server" ControlToValidate="ListBoxAge"
ErrorMessage="<p><br>Please enter your age.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelStreet" runat="server" Text="No.&Street:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxStreet" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator runat="server" ID="ValiteStreet" ControlToValidate="TextBoxStreet"
ErrorMessage="<p><br>Please enter valid number and street.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelSuburb" runat="server" Text="Suburb:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxSuburb" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="ValidateSuburb" runat="server" ControlToValidate="TextBoxSuburb"
ErrorMessage="<p><br>Please enter valid suburb.</br>"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelState" runat="server" Text="State:"></asp:Label>
</td>
<td>
<!--需要替换为中国省份-->
<asp:DropDownList ID="DropDownListState" runat="server">
<asp:ListItem>AL</asp:ListItem>
<asp:ListItem>AK</asp:ListItem>
<asp:ListItem>AZ</asp:ListItem>
<asp:ListItem>AR</asp:ListItem>
<asp:ListItem>CA</asp:ListItem>
<asp:ListItem>CO</asp:ListItem>
<asp:ListItem>CT</asp:ListItem>
<asp:ListItem>DE</asp:ListItem>
<asp:ListItem>FL</asp:ListItem>
<asp:ListItem>GA</asp:ListItem>
<asp:ListItem>HI</asp:ListItem>
<asp:ListItem>ID</asp:ListItem>
<asp:ListItem>IL</asp:ListItem>
<asp:ListItem>IN</asp:ListItem>
<asp:ListItem>IA</asp:ListItem>
<asp:ListItem>KS</asp:ListItem>
<asp:ListItem>KY</asp:ListItem>
<asp:ListItem>LA</asp:ListItem>
<asp:ListItem>ME</asp:ListItem>
<asp:ListItem>MD</asp:ListItem>
<asp:ListItem>MA</asp:ListItem>
<asp:ListItem>MI</asp:ListItem>
<asp:ListItem>MN</asp:ListItem>
<asp:ListItem>MS</asp:ListItem>
<asp:ListItem>MO</asp:ListItem>
<asp:ListItem>MT</asp:ListItem>
<asp:ListItem>NE</asp:ListItem>
<asp:ListItem>NV</asp:ListItem>
<asp:ListItem>NH</asp:ListItem>
<asp:ListItem>NJ</asp:ListItem>
<asp:ListItem>NM</asp:ListItem>
<asp:ListItem>NY</asp:ListItem>
<asp:ListItem>NC</asp:ListItem>
<asp:ListItem>ND</asp:ListItem>
<asp:ListItem>OH</asp:ListItem>
<asp:ListItem>OK</asp:ListItem>
<asp:ListItem>OR</asp:ListItem>
<asp:ListItem>PA</asp:ListItem>
<asp:ListItem>RI</asp:ListItem>
<asp:ListItem>SC</asp:ListItem>
<asp:ListItem>SD</asp:ListItem>
<asp:ListItem>TN</asp:ListItem>
<asp:ListItem>TX</asp:ListItem>
<asp:ListItem>UT</asp:ListItem>
<asp:ListItem>VT</asp:ListItem>
<asp:ListItem>VA</asp:ListItem>
<asp:ListItem>WA</asp:ListItem>
<asp:ListItem>WV</asp:ListItem>
<asp:ListItem>WI</asp:ListItem>
<asp:ListItem>WY</asp:ListItem>
<asp:ListItem>Out of USA</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelPostcode" runat="server" Text="Postcode:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxPostcode" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="ValidatePostcode1" runat="server" ControlToValidate="TextBoxPostcode"
ErrorMessage="<p><br>Please enter your postcode.</br>">
</asp:RequiredFieldValidator>
<asp:RangeValidator ID="ValidatePostcode2" runat="server" ControlToValidate="TextBoxPostcode"
MinimumValue="10000" MaximumValue="99999" Type="Integer" ErrorMessage="<p><br>Please enter valid postcode.</br>">
</asp:RangeValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="LabelURL" runat="server" Text="Personal Blog:"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBoxURL" runat="server">http://</asp:TextBox>
</td>
<td>
<asp:RegularExpressionValidator ID="ValidateURL2" runat="server" ControlToValidate="TextBoxURL"
ValidationExpression="http://.+(\..+)+" ErrorMessage="Invalid URL." Display="Dynamic">
</asp:RegularExpressionValidator>
<asp:RequiredFieldValidator ID="ValidateURL1" runat="server" ControlToValidate="TextBoxURL"
ErrorMessage="<p><br>Please enter valid URL.</br>">
</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td colspan="3" align="center">
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Label ID="LabelFeedback1" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Label ID="LabelFeedback2" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Label ID="LabelFeedback3" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Label ID="LabelFeedback4" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td colspan="3" align="center">
<asp:Button ID="ButtonSubmit" runat="server" Text="Submit" OnClick="ButtonSubmit_Click" />
<!--
数据库名：Users.mdb
表名：UsersInfo
表结构：id(自动编号即可) username password email gender age street suburb state postcode
-->
<asp:AccessDataSource ID="UsersDataSource" runat="server" DataFile="Users.mdb" SelectCommand="SELECT [username], [password], [email], [gender], [age], [street], [suburb], [state], [postcode], [id] FROM [UsersInfo]"
InsertCommand="INSERT INTO [UsersInfo] ([username], [password], [email], [gender], [age], [street], [suburb], [state], [postcode]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)">
<InsertParameters>
<asp:Parameter Name="username" Type="String" />
<asp:Parameter Name="password" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="gender" Type="String" />
<asp:Parameter Name="age" Type="String" />
<asp:Parameter Name="street" Type="String" />
<asp:Parameter Name="suburb" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="postcode" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</td>
</tr>
</table>
</form>
</body>
</html>
