Hi,
Thanks for your reply,
I do have a question regarding your example; The "C:\\Path\\To\\File" means
the path to the file on my computer right? But why's that neccesary when you
save it in your assets folder?
Further; I'm definitely going to exceed the 1MB limit.. so how does the
Resources option work? haha:P
Thanks!
2011/9/15 SRI <sri...@gmail.com>
> Hi,
>
> You can use like this
>
> using (System.IO.Stream dbStream = Assets.Open(items.db3))
> {
> using (var fileStream = File.Create("C:\\Path\\To\\File"))
> {
> appStream.CopyTo(fileStream);
> }
> }
>
> Points to Note the db3 file size should not exceed 1 MB else
> uncompression in Android hits error.
>
> You can also use Embedded Resources which does not have this
> limitation.
>
> Hope this helps
>
> Best Regards,
> Sridharan Srinivasan
>
> On Thu, Sep 15, 2011 at 8:26 PM, Mittchel Van Vliet <mittc...@gmail.com>
> wrote:
> > Hello everyone,
> > I recently started exploring around with Monodroid and now I wanted to
> work
> > with databases.
> > Finally I got that working, but what I want now is I made an database
> with
> > SQLite database browser.. and I want that file(database) to be deployed
> onto
> > the machine so that I can use the already existing data inside that
> > database.. but how do I get that to work from scratch?
> > Someone told me about Assets but how do I get the path of the asset file?
> > I've got the following to connect to a database now:
> > public static SqliteConnection GetConnection()
> > {
> > var documents =
> >
> System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
> > string db = Path.Combine(documents, "items.db3");
> > bool exists = File.Exists(db);
> > if (!exists)
> > SqliteConnection.CreateFile(db);
> > var conn = new SqliteConnection("Data Source=" + db);
> > if (!exists)
> > {
> > var commands = new[] {
> > "CREATE TABLE Items (Key ntext, Value ntext)",
> > "INSERT INTO [Items] ([Key], [Value]) VALUES ('sample', 'text1')",
> > "INSERT INTO [Items] ([Key], [Value]) VALUES
> ('sample2',
> > 'text2')",
> > "INSERT INTO [Items] ([Key], [Value]) VALUES
> ('sample3',
> > 'text3')",
> > };
> > foreach (var cmd in commands)
> > WithCommand(c =>
> > {
> > c.CommandText = cmd;
> > c.ExecuteNonQuery();
> > });
> > }
> > return conn;
> > }
> >
> >
> > Thanks in advance,
> > -- Mittchel
> > _______________________________________________
> > Monodroid mailing list
> > Monodroid@lists.ximian.com
> >
> > UNSUBSCRIBE INFORMATION:
> > http://lists.ximian.com/mailman/listinfo/monodroid
> >
> >
>
>
>
> --
> Sridharan Srinivasan
> Alias Sri
> Ph:(65)98255785/(65)63922439
> www.arshu.com
> _______________________________________________
> Monodroid mailing list
> Monodroid@lists.ximian.com
>
> UNSUBSCRIBE INFORMATION:
> http://lists.ximian.com/mailman/listinfo/monodroid
>
_______________________________________________
Monodroid mailing list
Monodroid@lists.ximian.com
UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid
