Hi, Ken.
Yes, I've read that. I was going to give that a try.
Thanks,
Mike
--
View this message in context:
http://mono-for-android.1047100.n5.nabble.com/Insert-2000-rows-into-SQLite-tp4401830p4409640.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_
I'm not shure but it uses folder like iOS, that means, folders inside your
application folder. Environment.SpecialFolder.Personal is the recommended
folder to store databases, editable files and domcuments that your app
could create/write.
Not sure about the other SpecialFolders as I'm using just
Hi, Karl.
Thanks. That worked.
How does the .Net framework SpecialFolder enumeration map to Mono-Droid?
I couldn't find any documentation on it.
Thanks again,
Mike
--
View this message in context:
http://mono-for-android.1047100.n5.nabble.com/Insert-2000-rows-into-SQLite-tp4401830p4405213.ht
I use SDF to be the same of Windows Mobile's SQL Mobile 2005. I think that
can be used anything.
Karl
On 17/05/11 19:58, "Liam" wrote:
>Is the file extension meant to be .db3 ? I use .db3 for my sqlite db.
>
>On 18/05/2011 10:56 a.m., Karl Heinz Brehme Arredondo wrote:
>> Can be:
>>
>> "Data So
Is the file extension meant to be .db3 ? I use .db3 for my sqlite db.
On 18/05/2011 10:56 a.m., Karl Heinz Brehme Arredondo wrote:
> Can be:
>
> "Data Source=" +
> Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal),
> "POS.db")
>
>
> Karl
>
> On 17/05/11 19:48, "milop" w
Can be:
"Data Source=" +
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal),
"POS.db")
Karl
On 17/05/11 19:48, "milop" wrote:
>Hi, Greg.
>
>Following your ORM way, I get an error creating the SQLConnection object
>using the connection string in your code: "Invalid Co
Hi, Greg.
Following your ORM way, I get an error creating the SQLConnection object
using the connection string in your code: "Invalid ConnectionString format
for parameter /data/data/com.mydomain.android/pos/databases/POS.db"
The name of my database is POS.db.
So, I created the database using th
Hi, Greg. Thanks for the response.
Regarding sqlite-net, it seems to be a separate open source project. How
does it relate to the Mono.Data.Sqlite.dll and Mono.Data.Tds.dll?
Also, on the following page, under the API Compatibility column for
Mono.Data.Sqlite.dll, the link for "limitations" shows
I would say that you should use whatever makes the most sense for your
application. If you want to be able to share the data calls across platforms
then ADO.NET might be a good route to go. Of course, you can mix and match
too. Personally, I like using the SQLiteOpenHelper to manage my database
ver
Hi, Karl.
I've never used SQLite either and so far I'm not a big fan.
Half of my confusion is whether I should use SQLiteOpenHelper or the SQLite
ADO.Net provider.
I'm learning Android and in all the reading, naturally it all alludes to
SQLiteOpenHelper.
This whole thing of passing the version
Let see if someone else helps you. I never used SQLiteOpenHelper, sorry...
I just:
//Open connection
Using (SqliteConnection sqlConnection = new SqliteConnection())
{
// put the connection inside sqlilte
// type of commannd = text
sqliteConnection.CommandText = 'INSERT TA
Hi, Karl. Thanks for the response.
Here's the code. I've subclassed the Application class and have a
SQLiteOpenHelper object named DBHelper in it that I access for all DB
operations:
foreach (DataRow row in ds.Tables[1].Rows)
{
Hi, I THINK the above message
>close() was never explicitly
Means that there is no Close on code?
Post your code, maybe someone can help. I put about 1200 records on a
table sweetly.
Karl
___
Monodroid mailing list
Monodroid@lists.ximian.com
UNS
13 matches
Mail list logo