SQLite get data from a table

Question

SQLite get data from a table

Navigation

#1 by (1 votes)

0

Hello friends I am new working with SQLite and I have a question, I finally managed to make my table and even put data (wow), but what I would like to know is if someone knows how to confirm whether the table is empty or not? and if it is, you know how to throw another function etc ... this is my code ...

using System.Linq;
using System.Text;
using Xamarin.Forms;

namespace SqlieTest_x
{
   public class MemberDatabase
    {
        private SQLiteConnection conn;

        public MemberDatabase() {
            conn = DependencyService.Get<ISQLite>().GetConnection();        
                conn.CreateTable<Member>();    
        }

        public IEnumerable<Member> GetMembers() {
            var members = (from mem in conn.Table<Member>() select mem);
            return members.ToList();
        }

        public string AddMember(Member member) {
            conn.Insert(member);
            return "success baby bluye ;*";
        }

        public string DeleteMember(int id) {
            conn.Delete(id);
            return "success user deleted";
        }
    }
}

I need something to evaluate the GetMembers response, in this view, I'm instantiating the bd, but knowing its contents before I return it to a view, does anyone think they know how to help me?

   public MemberDatabase memberDatabase;
        public Member member;
        public FormsPage ()
		{
			InitializeComponent ();
            memberDatabase = new MemberDatabase();
            var members = memberDatabase.GetMembers();
           /* if (members != null) // o algo similar que me permita saber su contenido
           //previo a la consulta
            {
                DisplayAlert("no","no members", "i accept");
            }*/
            xlist.ItemsSource = members;
        }

c# xamarin.forms xamarin sqlite

asked by E.Rawrdríguez.Ophanim 16.02.2018 в 22:03

source

1 answer

How to traverse a variable with an internal loop without the external one affecting it in PHP? Windows 10 on 2 hard drives (dual boot)

score 1 · Accepted Answer

class A {

   SQLiteCommand cmd = new SQLiteCommand(conn);
   cmd.CommandText = "select * from table";
   cmd.CommandType = CommandType.Text;
   int RowCount = 0;

   RowCount = Convert.ToInt32(cmd.ExecuteScalar());

   if (RowCount > 0) { //hay registros... }
   else {//no hay registros}

}