Hi,
Any way Jon has allready answered your question and i did
not see it. Lack of sleep and too much good food (:-.
Best Regards,
Sridharan Srinivasan
On Sun, Sep 18, 2011 at 6:55 PM, SRI <[email protected]> wrote:
> Hi,
> Sorry for not reply earlier, since I was at a Lenovo Hackthon.
>
> The C: was a cut and paste error. You should use
>
> pathToSave =
> Environment.GetFolderPath(Environment.SpecialFolder.Personal)
>
> which will give you the /data/data/AndroidPackageName/ directory
>
> Just select the file as a Embedded Resources (Not Android
> Resources) and use the following (Normal Resource Handling ) to
> retrieve the file
>
> string[] resNames =
> resourceAssembly.GetManifestResourceNames();
>
> //Process the resource names from the manifest
> foreach (string resName in resNames)
> {
> if
> (resName.ToLower().Contains(fullResourcePattern.ToLower()) == true)
> {
> }
> }
>
> Hope this helps
>
> Best Regards,
> Sridharan Srinivasan
>
> On Fri, Sep 16, 2011 at 1:59 AM, Mittchel Van Vliet <[email protected]>
> wrote:
>> 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 <[email protected]>
>>>
>>> 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 <[email protected]>
>>> 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
>>> > [email protected]
>>> >
>>> > UNSUBSCRIBE INFORMATION:
>>> > http://lists.ximian.com/mailman/listinfo/monodroid
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Sridharan Srinivasan
>>> Alias Sri
>>> Ph:(65)98255785/(65)63922439
>>> www.arshu.com
>>> _______________________________________________
>>> Monodroid mailing list
>>> [email protected]
>>>
>>> UNSUBSCRIBE INFORMATION:
>>> http://lists.ximian.com/mailman/listinfo/monodroid
>>
>>
>> _______________________________________________
>> Monodroid mailing list
>> [email protected]
>>
>> UNSUBSCRIBE INFORMATION:
>> http://lists.ximian.com/mailman/listinfo/monodroid
>>
>>
>
>
>
> --
> Sridharan Srinivasan
> Alias Sri
> Ph:(65)98255785/(65)63922439
> www.arshu.com
>
--
Sridharan Srinivasan
Alias Sri
Ph:(65)98255785/(65)63922439
www.arshu.com
_______________________________________________
Monodroid mailing list
[email protected]
UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid
