Select SQLite field with index in C# without having ID field

Question

My database is like this:

As you can see, I have no ID field. So, the question is, how can I select "Ann Joyle" ( with index 1), or "Gregor Leon" with index 3), and copy his/her number to `textBox` in C#?

Are You using EF or pure SQL? – blogprogramisty.net Mar 05 '16 at 14:13 — blogprogramisty.net, Mar 05 '16 at 14:13
I am using System.Data.SQLite Reference. – midler Mar 05 '16 at 14:17 — midler, Mar 05 '16 at 14:17
IMO my answer will help You – blogprogramisty.net Mar 05 '16 at 14:21 — blogprogramisty.net, Mar 05 '16 at 14:21
SQL tables are unordered. How is the index defined? – CL. Mar 05 '16 at 15:04 — CL., Mar 05 '16 at 15:04

score -1 · Accepted Answer · edited May 23 '17 at 12:23

If You want to have number by first name and surname from table this is simple:

 SELECT Numbers WHERE Names= "Ann" and Surnames ="Joyle"

You get what You want.

If You want special index You can use in SQLLite syntax like this:

SELECT Numbers,Names,Surnames  WHERE LIMIT 1 OFFSET 1

It is mean take 1 row and skip 1 row is equivalent to take index 1.

More info here: Sqlite LIMIT / OFFSET query

BUT

Your SQL table are unordere and the result of this query may be difrrent when You change something.

Good to do is use SQL ORDER BY keyword

SELECT Numbers,Names,Surnames  WHERE ORDER BY Surnames LIMIT 1 OFFSET 1

Select SQLite field with index in C# without having ID field

1 Answers1