Re: [mono-android] Insert 2000 rows into SQLite

2011-05-19 Thread milop
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. _

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread Karl Heinz Brehme Arredondo
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread milop
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread Karl Heinz Brehme Arredondo
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread Liam
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread Karl Heinz Brehme Arredondo
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread milop
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread milop
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread Greg Shackles
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-17 Thread milop
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-16 Thread Karl Heinz Brehme Arredondo
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

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-16 Thread milop
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) {

Re: [mono-android] Insert 2000 rows into SQLite

2011-05-16 Thread Karl Heinz Brehme Arredondo
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