Get data from database query?Solved
Hi all.
Im kinda new to databases but I managed to get a connection and querry results from a table. But im having the issue not being able to actually get the "values" from the results
my table has two collums
steamid | kills
1234      | 10
4321      | 12

When I querry the table I get two results but i cant access the values them selfs.
foreach (Dictionary<string, object> entry in list)
                {
                    newString.AppendFormat("{0}\t{1}\n", entry["steamid"], entry["kills"]);
                }​
However the string doesnt output any of the values. I used the docs to get this code above
It outputs

steamid kills
steamid kills

Any one got any ideas?
Thanks in advance
Could you show us a bit more code, like how you get list?
Thanks misticos :P you saying that solved it. I was being an idiot.
I had this
string sqlQuery = "SELECT 'steamid' FROM table";

change it to
string sqlQuery = "SELECT steamid FROM table";
All fixed
Loveit when stuff like that happens :p Thank you tho if you didnt say that i wouldnt of looked there!!!!
Such stuff happens everywhere, np
Locked automatically