Hello,
I'm having this problem with the sample code of the wrox book "Pro Android
programming with Mono for Android", InternalNetworkData sample.
First it creates a DB and fills it with data, with success, then tries to
read the data with a SqliteDataReader.
I tried to debug it and when it gets to the line "while (sdr.Read())" the
debug line jumps to the end of the file, no errors, and non processing,
application stil running, and I can press the button to get the data again.
What's wrong? with the code and with my debug that can't get the error.
string DatabaseName = "UserData.db3";
string documents = System.Environment.GetFolderPath(
System.Environment.SpecialFolder.Personal);
string db = Path.Combine(documents, DatabaseName);
var conn = new SqliteConnection("Data Source=" + db);
var strSql = "select Name from Customer where STATEID=@STATEID";
var cmd = new SqliteCommand(strSql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqliteParameter("@STATEID", 2));
tv.Text = "";
try
{
conn.Open();
SqliteDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
tv.Text = Convert.ToString(sdr["Name"]);
}
}
catch (System.Exception sysExc)
{
tv.Text = sysExc.Message;
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
conn.Dispose();
}
By the way, is there a way with a thirdy part software or even with vs to
create a sqlite DB and deploy it with the application? and maybe even to
access the sqlite DBs in the connected device? asking too much?
Thanks!
Mattia
--
View this message in context:
http://mono-for-android.1047100.n5.nabble.com/SQLite-error-tp5709898.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_______________________________________________
Monodroid mailing list
Monodroid@lists.ximian.com
UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid
