Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as C# by asdasdeeefgg ( 13 years ago )
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();

 

Revise this Paste

Your Name: Code Language: