This question was closed Dec 05, 2018 at 07:16 AM by hexagonius for the following reason:

Problems with SQL are mit Unity specific

Question by unity_BkzKW1GPXqMERw · Dec 05, 2018 at 07:07 AM · c#unity 5 sqlite

Unity3d c# load or fill dataTable from sqLite local DataBase Error: sqlite3_column_Origin_name

hello everyone i use Unity 5 for create android Game, so i use sqlite local Data base in my project. DataBase Address copy in 2 folder: 1)

\Assets\youtube.bytes

\Assets\StreamingAssets\youtube.bytes

my method to access to dataBase is:

 string newDBPath = "";
             if (Application.platform != RuntimePlatform.Android)
             {
                 newDBPath = Application.dataPath + "/" + "youtube.bytes";
             }
             else
             {
                 newDBPath = Application.persistentDataPath + "/" + "youtube.bytes";
                 if (!File.Exists(newDBPath))
                 {
                     WWW loadDB = new WWW("jar:file://" + Application.dataPath +
                          "!/assets/" + "youtube.bytes");
 
                     while (!loadDB.isDone) { }
                     File.WriteAllBytes(newDBPath, loadDB.bytes);
                 }
             }

 

 DataTable dataTable1 = new DataTable();
             SqliteConnection con_db = new SqliteConnection("URI=file:" + newDBPath);

con_db.Open(); if (con_db.State == ConnectionState.Open) { SqliteCommand cmd_db = new SqliteCommand("Select * from Users", con_db); SqliteDataReader rdr = cmd_db.ExecuteReader();

for fill DataTable:

 dataTable1.Load(rdr);

for check i use this code:

 if (dataTable1.Rows.Count > 0)
                     {
                         txtID.text = dataTable1.Rows[0][0].ToString().Trim();
                     }

but in Android Device return this Error:

 sqlite3_column_Origin_name ...
 Mono.Data.SqLite.sqLite3.ColumnOriginalName <fileName Unknown>
 so i tried this:
     SqliteDataAdapter da = new SqliteDataAdapter(sqlText, con_db);
                     da.Fill(dataTable1);

but return error Again, so i create manual Columns And Rows like :

 if (rdr.HasRows)
                     {
                         dataTable1.Columns.Add(rdr.GetName(0), typeof(string));
                         dataTable1.Columns.Add(rdr.GetName(1), typeof(string));
                         dataTable1.Columns.Add(rdr.GetName(2), typeof(string));
                         while (rdr.Read())
                         {
                             dataTable1.Rows.Add(rdr[0].ToString(), rdr[1].ToString(), rdr[2].ToString());
                         }
                     }

its working fine, but some time i dont known how much Columns count in database Table, how many number is