Page 1
Page 2
Below is a screen shot of the demo database
page, along with some code snippets confirming it is just
"regular ASP" code. (full source available in
the demo).
' Open connection to the database
set oDBCon = Server.CreateObject("ADODB.Connection")
oDBCon.ConnectionString = _
"data source = \PAspPages\ModeZero\_db\TestCEDB.cdb"
oDBCon.Open
' iterate through the current records
and display
<%
Set rs = CreateObject("ADODB.RecordSet")
rs.Open "PersonalInfo", oDBCon, 1, 3
If rs.RecordCount > 0 Then
Do While Not rs.EOF
%>
<TR><TD><%= rs.Fields("Name").Value
%></TD>
<TD align="center"><%= rs.Fields("Age").Value%></TD>
<td align="center">
<a href="#del" OnClick='DelIt("<%=rs.Fields("Name").value%>");return
false;'> delete</a>
</td>
</TR>
<%
rs.MoveNext
Loop
End If
rs.Close
%>
' delete database rows
if (Request.QueryString("DelThis") <> "")
then
oDBCon.Execute( "DELETE FROM PersonalInfo WHERE Name
= '" & Request.QueryString("DelThis")
& "'")
end if
When developing the user interface,
Pocket Internet Explorer provides support for HTML 3.2,
plus the scripting engine lifted from IE4 (JavaScript 1.1,
ECMA-262), providing a set of features capable of creating
a good-looking application.
It's worth pointing out at this point
that PocketASP is not a web server, it is a small (just
100K) platform, which allows local processing and delivery
of ASP files (and html, images etc). In addition Pocket
IE does not need any special configuration or plug-ins to
start viewing the ASP pages.
The Outcome
Take your existing VB skills, liberally
mix in some HTML, client-side scripting, server-side ASP
with database connectivity and you can quickly develop a
stable application with a small footprint. What's more,
this single application version will be available to all
supported PocketASP hardware platforms.
And Finally…
So the result was I ended up creating
much more work for the team and myself. Rather than developing
some Pocket PC applications, we ended up writing the PocketASP
platform! However, in the long run this will make Pocket
PC development simpler and quicker for us and hopefully
many other Pocket PC application developers.
Footnotes:
Throughout this article I refer to ASP,
by which I mean VBScript in the ASP framework.
PocketASP was developed by ModeZero,
a privately held, independent software vendor. The evaluation
version has 100% functionality and is not time-limited.
An evaluation notice is shown when the system is first started.
More information, including the evaluation
download and commercial-usage pricing, can be found on the
PocketASP website, http://www.ModeZero.net/PocketASP/.
Previous Page