How To Get Windows Mobile Application Pre-Requisite CAB

When you debug and deploy your mobile application with visual studio 2008, you will get some information may help on your real deployment process.

Eg. the out here below will show the cab you needed for client, get those cab from the specific path and deploy it with your program together in order to make it work.

For database, you might need to be aware of the path of database. Default location is device program files.

------ Deploy started: Project: Ringamon, Configuration: Debug Any CPU ------

'// For my HP IPAQ RW 6828 on Windows Mobile 5 qVGA 320x240
Deploying 'C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\windowsce\NETCFv35.wm.ARMV4I.cab'

'// SQL Server Compact Edition ( PPC WCE5 )
Deploying '%CSIDL_PROGRAM_FILES%\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\ARMV4i\sqlce.ppc.wce5.armv4i.CAB'

'// SQL Server Compact Edition ( Repl ppc version )
Deploying '%CSIDL_PROGRAM_FILES%\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\ARMV4i\sqlce.repl.ppc.wce5.armv4i.CAB'

'// SQL Server Compact Edition ( DEV enu version )
Deploying '%CSIDL_PROGRAM_FILES%\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\ARMV4i\sqlce.dev.enu.ppc.wce5.armv4i.CAB'

'// My Ringamon Database
Deploying 'C:\Users\Ethan Liew\Desktop\Ethan.Mobile.Ringamon\trunk\Ethan.Mobile.Ringamon\bin\Debug\db.sdf'

'// My Ringamon program :P
Deploying 'C:\Users\Ethan Liew\Desktop\Ethan.Mobile.Ringamon\trunk\Ethan.Mobile.Ringamon\bin\Debug\Ringamon.exe'

Deploying 'C:\Program
'// Result of diagnostics message / error message
Files\Microsoft.NET\SDK\CompactFramework\v3.5\windowsce\diagnostics\NETCFv35.Messages.EN.wm.cab'

========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========

DBNETLIB SQL Server Error 17 with SQL2000 Windows Authentication

If your SQL Server 200 had been initially installed using Windows Authentication ( Windows only ) option as above figure, you may have hard to to connect via Odbc or Sql Management Studio 2005.

You might get the error bellow.



Solution might be getting windows authentication before you connect your machine to sql 2000 server.

You can type in machine name or IP and try to key in the sql2000 server administrator and password ( authenticated user ) for sql 2000.


Then you will able to attach the sql server 2000 on your sql server management 2005.

Validate Input Values With Message List

Private Function ValidateInputValues(ByVal control As Control, ByVal pageType As PageType) As ArrayList
Dim messageList As ArrayList = New ArrayList()
DataFormat.SetDateSeparator("/")
If (pageType <> PageType.Search) Then ' Add/Edit Validation
Dim fullName As TextBox = TryCast(control.FindControl("fullName"), TextBox)
If (fullName IsNot Nothing) Then
If (Not DataFormat.CheckString(fullName.Text)) Then
messageList.Add("Invalid Value (String): fullName")
End If
End If
Dim phoneNumber As TextBox = TryCast(control.FindControl("phoneNumber"), TextBox)
If (phoneNumber IsNot Nothing) Then
If (Not DataFormat.CheckInt32(phoneNumber.Text)) Then
messageList.Add("Invalid Value (Int32): Phone Number")
End If
End If
End If
Return IIf(messageList.Count = 0, Nothing, messageList)
End Function


' Powerful TIPs !
Dim source As WebControl = TryCast(sender, WebControl)

Page Load Function Tips

Get some idea or tips from others work in their page load():

Protected Sub Page_Load(ByVal s As Object, ByVal e As System.EventArgs)

' Registering external javascript file, so that we can have more neater js file management.
Page.ClientScript.RegisterClientScriptInclude("ethan", "ethan.js")

' Cache Setting, I just know about
' ASP Caching can be set manually on the virtual directory property
Response.Cache.SetCacheability(HttpCacheability.NoCache)

' Auto-find control and set focus to it;
' I just know got such a syntax, which really near to human language syntax "IsNot"
' and about ClientID property which is very useful in some case.
If (tblpwdDetailsView.FindControl("fullName") IsNot Nothing) Then
Page.Form.DefaultFocus = tblpwdDetailsView.FindControl("fullName").ClientID
End If

' The way they check for QueryString exist or not
If (Not Page.IsPostBack) Then
If (Request.QueryString.Count > 0) Then
......

Team Viewer Remote Access

http://www.teamviewer.com/download/index.aspx


File Transfer Mode


File Transfering


Login ID

MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.

Case:
When you click on "SQL Server Enterprise Manager" shortcut,
you get "MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file."

First I try to check the NTFS Security Permission and is already set to administrator.
Probably the file had corrupted.

Suggested solution:

1. Select Start - Run.
2. At the Open prompt enter: mmc
3. Click OK
4. Select File - Add/Remove Snap-in...
5. Click Add...
6. Select Microsoft SQL Enterprise Manager
7. Click Add, then Close
8. Click Ok to return to the mmc.
9. Select File - Save As...
10. Delete or rename the original (offending) file out the way.
11. Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC

Now your original shortcut should work.

Alternatively you can always access Enterprise Manager from within the Computer Management mmc.

Reference From: http://geekswithblogs.net/timh/archive/2005/08/09/49716.aspx
Thanks to Tim Huffam (geekswithblogs) and Sin Huei ( my college)

Converting Valid XML String To Dataset

Imports System.Text
Imports System.Xml
Imports System.Data
Imports System.IO

Dim sb As New System.Text.StringBuilder
sb.Append("")
sb.Append("")
sb.Append("" & "Ethan Liew" & "")
sb.Append("" & "info@ethanliew.com" & "")
sb.Append("")
sb.Append("")

' Covert to string reader then to xmltextreader
Dim reader As New XmlTextReader(New StringReader(sb.ToString))
Dim ds As New DataSet
ds.ReadXml(reader)

' Return dataset
Return ds

1. First you need to use StringReader to read the string.
2. Convert it to XmlTextReader
3. Create a new dataset to