> 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?
I use sqlitestudio for this matter. Don't know if there's a better one, but this one get's the work done. http://sqlitestudio.one.pl/ On 18 May 2012 11:35, mdurli <mdu...@gmail.com> wrote: > 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 > -- Gonçalo Oliveira
_______________________________________________ Monodroid mailing list Monodroid@lists.ximian.com UNSUBSCRIBE INFORMATION: http://lists.ximian.com/mailman/listinfo/monodroid
