Creates a new UltraLite database.
Visual Basic Public Sub CreateDatabase( _ ByVal connString As String, _ ByVal collationData As Byte(), _ ByVal createParms As String _ )
C# public void CreateDatabase( string connString, byte[] collationData, string createParms );
connString The parameters for identifying a database in the form of a semicolon-separated list of keyword-value pairs. For more information, see ULConnectionParms class.
collationData The collation data specifying how the database will store and compare strings.
createParms The parameters used to configure the new database in the form of a semicolon-separated list of keyword-value pairs. For more information, see ULCreateParms class.
To specify a collation, you must first include the appropriate collation data source file from the UltraLite\Collations\cs (for C# projects) or UltraLite\Collations\vb.net (for Visual Basic projects) subdirectory of your SQL Anywhere installation directory. Once included in your project, use the collation's Data property to supply the collation data to the CreateDatabase() method.
The following code creates the database \UltraLite\MyDatabase.udb on a Windows Mobile device then opens a connection to it.
' Visual Basic Dim openParms As ULConnectionParms = New ULConnectionParms openParms.DatabaseOnCE = "\UltraLite\MyDatabase.udb" ' Assumes file UltraLite\Collations\vb.net\coll_1250LATIN2.vb is ' also compiled in the current project ULConnection.DatabaseManager.CreateDatabase( _ openParms.ToString(), _ iAnywhere.UltraLite.Collations.Collation_1250LATIN2.Data, _ "" _ ) Dim conn As ULConnection = _ New ULConnection( openParms.ToString() ) conn.Open() |
// C# ULConnectionParms openParms = new ULConnectionParms(); openParms.DatabaseOnCE = @"\UltraLite\MyDatabase.udb"; // Assumes file UltraLite\Collations\cs\coll_1250LATIN2.cs is // also compiled in the current project ULConnection.DatabaseManager.CreateDatabase( openParms.ToString(), iAnywhere.UltraLite.Collations.Collation_1250LATIN2.Data, "" ); ULConnection conn = new ULConnection( openParms.ToString() ); conn.Open(); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |