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)
{
var values = new ContentValues();
values.Put("CountyCode",
Convert.ToInt32(row["Cnty"]));
values.Put("TransType",
Convert.ToString(row["TrnTyp"]));
values.Put("ResidentialTaxPct",
Convert.ToDouble(row["ResTax"]));
values.Put("CommercialTaxPct",
Convert.ToDouble(row["ComTax"]));
values.Put("ExemptUserTaxPct",
Convert.ToDouble(row["ExmTax"]));
AppMain.getInstance().DBHelper.WritableDatabase.Insert("tblTax", null,
values);
}
--
View this message in context:
http://mono-for-android.1047100.n5.nabble.com/Insert-2000-rows-into-SQLite-tp4401830p4401854.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_______________________________________________
Monodroid mailing list
[email protected]
UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid
