I'm simple trying to get information from a MS Acces database and put it in some textboxes, but i got the error
Syntax error in FROM clause
I don't know what im doing wrong and the sql works in Access itself.
try
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = @"SELECT [CharacterID], [CharacterName], [Race], [Class], [Background], [Level], [Alignment], [Experience Points], [PlayerName]
FROM Character";
reader = cmd.ExecuteReader();
Player p = new Player();
while (reader.Read())
{
p.CharacterID = reader.GetInt32(0);
p.CharacterName = reader.GetString(1);
p.Race = reader.GetString(2);
p.Class = reader.GetString(3);
p.Background = reader.GetString(4);
p.Level = reader.GetInt32(5);
p.Alignment = reader.GetString(6);
p.ExperiencePoints = reader.GetInt32(7);
p.PlayerName = reader.GetString(8);
}
characters.Add(p);
txtCharacterName.Text = p.CharacterName;
txtClassLevel.Text = p.Class + " " + p.Level.ToString();
txtBackground.Text = p.Background;
txtPlayerName.Text = p.PlayerName;
txtRace.Text = p.Race;
txtAlignment.Text = p.Alignment;
txtExperiencePoints.Text = p.ExperiencePoints.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}