Xamarin.android Microsoft.SQLite Always return no rows

Question

  string path = Path.Combine(
         System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal),
          "Service.db3");

            SqliteConnection cn = new SqliteConnection("Data Source=" + path + " ");

            List<String> entries = new List<string>();


            SqliteCommand sqCommand = (SqliteCommand)cn.CreateCommand();
            sqCommand.CommandText = $"SELECT ID FROM Members ";
            cn.Open();

  SqliteDataReader sqReader = sqCommand.ExecuteReader();

            if (sqReader.HasRows)
            {

            }
            else
            {

            }

that is my code I'm using but there is no row although I have 2 rows at the table and if I used

SELECT name FROM sqlite_master I got the table name that I created I don't understand??

are you using the right nuget package? The constructor for SqlConnection takes a path, not a connection string. And how are you pre-populating your database? This is a slightly non-trivial process, not something most people get right the first time. — Jason
– Jason, Commented Feb 19, 2020 at 22:18
I used sqlite-net-pcl this nuget package before but ummm I couldn't use it i was getting error no such table Members and it was created one — Emad Younan
– Emad Younan, Commented Feb 20, 2020 at 9:46
I'm Trying I don't know where is the problem at my code or at my database — Emad Younan
– Emad Younan, Commented Feb 20, 2020 at 11:11

Emad Younan · Accepted Answer · 2020-02-25 11:19:00Z

1

I know the answer now I have to make function create the db and table I was creating the db with sqlite studio and save it

answered Feb 25, 2020 at 11:19

Emad Younan

1156 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Max der 246 · Accepted Answer · 2020-02-24 10:45:56Z

0

string path = Path.Combine(
     System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal),
      "Service.db3");

        SqliteConnection cn = new SqliteConnection("Filename=" + path);

        List<String> entries = new List<string>();


        SqliteCommand sqCommand = (SqliteCommand)cn.CreateCommand();
        sqCommand.CommandText = "SELECT ID FROM Members ";
        cn.Open();

         SqliteDataReader sqReader = sqCommand.ExecuteReader();

        if (sqReader.HasRows)
        {

        }
        else
        {

        }

Try this

answered Feb 24, 2020 at 10:45

Max der 246

16

Collectives™ on Stack Overflow

Xamarin.android Microsoft.SQLite Always return no rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related