sqlCmd.CommandText = "SELECT [TileTexture_FK] FROM [Tile] WHERE [Id]=" + Main.iSelectedTileId.ToString();
sqlCmd.ExecuteNonQuery();
int iTileTex_FK = 0, iTexId = 0;
Point ptTilePos = new Point();
SQLiteDataReader sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
iTileTex_FK = Convert.ToInt32(sqlReader[0]);
} sqlReader.Dispose();
sqlCmd.CommandText = "SELECT [X], [Y], [Texture_FK] FROM [TileTexture] WHERE [Id]="+iTileTex_FK.ToString();
sqlCmd.ExecuteNonQuery();
sqlReader=sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
ptTilePos=new Point(Convert.ToInt32(sqlReader[0]), Convert.ToInt32(sqlReader[1]));
iTexId = Convert.ToInt32(sqlReader[2]);
} sqlReader.Dispose();
sqlCmd.CommandText = "SELECT [Path] FROM [Texture] WHERE [Id]=" + iTexId.ToString();
sqlCmd.ExecuteNonQuery();Add a code snippet to your website: www.paste.org