Change icon in Games Table from Attachment to OLE Object

diff --git a/NEA/NEA.accdb b/NEA/NEA.accdb
index c7048ab67275277e5df000cbaf087ce09d522fa3..e4baf044f67aa467b7a1b6bc77b7e1e7c4dc9e02 100644 (file)
Binary files a/NEA/NEA.accdb and b/NEA/NEA.accdb differ

diff --git a/NEA/NEADataSet.Designer.vb b/NEA/NEADataSet.Designer.vb
index aa6cc4f92b057c6c4cafd5f3ee0f081d4b8e5512..17f52ea8071f15a2f4a18c344ec85cf6ad1c779a 100644 (file)
--- a/NEA/NEADataSet.Designer.vb
+++ b/NEA/NEADataSet.Designer.vb
@@ -1604,12 +1604,12 @@ Partial Public Class NEADataSet
         
         Private columnPublisher As Global.System.Data.DataColumn
         
         
         Private columnPublisher As Global.System.Data.DataColumn
         

-        Private columnIcon As Global.System.Data.DataColumn
-        

         Private columnTags As Global.System.Data.DataColumn
         
         Private columnTheme_Colour As Global.System.Data.DataColumn
         
         Private columnTags As Global.System.Data.DataColumn
         
         Private columnTheme_Colour As Global.System.Data.DataColumn
         

+        Private columnIcon As Global.System.Data.DataColumn
+        

         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         Public Sub New()
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         Public Sub New()


@@ -1703,25 +1703,25 @@ Partial Public Class NEADataSet
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public ReadOnly Property IconColumn() As Global.System.Data.DataColumn
+        Public ReadOnly Property TagsColumn() As Global.System.Data.DataColumn

             Get
             Get

-                Return Me.columnIcon
+                Return Me.columnTags

             End Get
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
             End Get
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public ReadOnly Property TagsColumn() As Global.System.Data.DataColumn
+        Public ReadOnly Property Theme_ColourColumn() As Global.System.Data.DataColumn

             Get
             Get

-                Return Me.columnTags
+                Return Me.columnTheme_Colour

             End Get
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
             End Get
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public ReadOnly Property Theme_ColourColumn() As Global.System.Data.DataColumn
+        Public ReadOnly Property IconColumn() As Global.System.Data.DataColumn

             Get
             Get

-                Return Me.columnTheme_Colour
+                Return Me.columnIcon

             End Get
         End Property
         
             End Get
         End Property
         


@@ -1762,9 +1762,9 @@ Partial Public Class NEADataSet
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public Overloads Function AddGamesRow(ByVal Name As String, ByVal Price As Decimal, ByVal Rating As Integer, ByVal Certificate As Integer, ByVal Dev As String, ByVal Publisher As String, ByVal Icon As String, ByVal Tags As String, ByVal Theme_Colour As Integer) As GamesRow
+        Public Overloads Function AddGamesRow(ByVal Name As String, ByVal Price As Decimal, ByVal Rating As Integer, ByVal Certificate As Integer, ByVal Dev As String, ByVal Publisher As String, ByVal Tags As String, ByVal Theme_Colour As Integer, ByVal Icon() As Byte) As GamesRow

             Dim rowGamesRow As GamesRow = CType(Me.NewRow,GamesRow)
             Dim rowGamesRow As GamesRow = CType(Me.NewRow,GamesRow)

-            Dim columnValuesArray() As Object = New Object() {Nothing, Name, Price, Rating, Certificate, Dev, Publisher, Icon, Tags, Theme_Colour}
+            Dim columnValuesArray() As Object = New Object() {Nothing, Name, Price, Rating, Certificate, Dev, Publisher, Tags, Theme_Colour, Icon}

             rowGamesRow.ItemArray = columnValuesArray
             Me.Rows.Add(rowGamesRow)
             Return rowGamesRow
             rowGamesRow.ItemArray = columnValuesArray
             Me.Rows.Add(rowGamesRow)
             Return rowGamesRow


@@ -1800,9 +1800,9 @@ Partial Public Class NEADataSet
             Me.columnCertificate = MyBase.Columns("Certificate")
             Me.columnDev = MyBase.Columns("Dev")
             Me.columnPublisher = MyBase.Columns("Publisher")
             Me.columnCertificate = MyBase.Columns("Certificate")
             Me.columnDev = MyBase.Columns("Dev")
             Me.columnPublisher = MyBase.Columns("Publisher")

-            Me.columnIcon = MyBase.Columns("Icon")

             Me.columnTags = MyBase.Columns("Tags")
             Me.columnTheme_Colour = MyBase.Columns("Theme Colour")
             Me.columnTags = MyBase.Columns("Tags")
             Me.columnTheme_Colour = MyBase.Columns("Theme Colour")

+            Me.columnIcon = MyBase.Columns("Icon")

         End Sub
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
         End Sub
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _


@@ -1822,12 +1822,12 @@ Partial Public Class NEADataSet
             MyBase.Columns.Add(Me.columnDev)
             Me.columnPublisher = New Global.System.Data.DataColumn("Publisher", GetType(String), Nothing, Global.System.Data.MappingType.Element)
             MyBase.Columns.Add(Me.columnPublisher)
             MyBase.Columns.Add(Me.columnDev)
             Me.columnPublisher = New Global.System.Data.DataColumn("Publisher", GetType(String), Nothing, Global.System.Data.MappingType.Element)
             MyBase.Columns.Add(Me.columnPublisher)

-            Me.columnIcon = New Global.System.Data.DataColumn("Icon", GetType(String), Nothing, Global.System.Data.MappingType.Element)
-            MyBase.Columns.Add(Me.columnIcon)

             Me.columnTags = New Global.System.Data.DataColumn("Tags", GetType(String), Nothing, Global.System.Data.MappingType.Element)
             MyBase.Columns.Add(Me.columnTags)
             Me.columnTheme_Colour = New Global.System.Data.DataColumn("Theme Colour", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
             MyBase.Columns.Add(Me.columnTheme_Colour)
             Me.columnTags = New Global.System.Data.DataColumn("Tags", GetType(String), Nothing, Global.System.Data.MappingType.Element)
             MyBase.Columns.Add(Me.columnTags)
             Me.columnTheme_Colour = New Global.System.Data.DataColumn("Theme Colour", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
             MyBase.Columns.Add(Me.columnTheme_Colour)

+            Me.columnIcon = New Global.System.Data.DataColumn("Icon", GetType(Byte()), Nothing, Global.System.Data.MappingType.Element)
+            MyBase.Columns.Add(Me.columnIcon)

             Me.Constraints.Add(New Global.System.Data.UniqueConstraint("Constraint1", New Global.System.Data.DataColumn() {Me.columnGameID}, true))
             Me.columnGameID.AutoIncrement = true
             Me.columnGameID.AutoIncrementSeed = -1
             Me.Constraints.Add(New Global.System.Data.UniqueConstraint("Constraint1", New Global.System.Data.DataColumn() {Me.columnGameID}, true))
             Me.columnGameID.AutoIncrement = true
             Me.columnGameID.AutoIncrementSeed = -1


@@ -1837,7 +1837,6 @@ Partial Public Class NEADataSet
             Me.columnName.MaxLength = 536870910
             Me.columnDev.MaxLength = 536870910
             Me.columnPublisher.MaxLength = 536870910
             Me.columnName.MaxLength = 536870910
             Me.columnDev.MaxLength = 536870910
             Me.columnPublisher.MaxLength = 536870910

-            Me.columnIcon.MaxLength = 536870910

             Me.columnTags.MaxLength = 536870910
         End Sub
         
             Me.columnTags.MaxLength = 536870910
         End Sub
         


@@ -4366,46 +4365,46 @@ Partial Public Class NEADataSet
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public Property Icon() As String
+        Public Property Tags() As String

             Get
                 Try 
             Get
                 Try 

-                    Return CType(Me(Me.tableGames.IconColumn),String)
+                    Return CType(Me(Me.tableGames.TagsColumn),String)

                 Catch e As Global.System.InvalidCastException
                 Catch e As Global.System.InvalidCastException

-                    Throw New Global.System.Data.StrongTypingException("The value for column 'Icon' in table 'Games' is DBNull.", e)
+                    Throw New Global.System.Data.StrongTypingException("The value for column 'Tags' in table 'Games' is DBNull.", e)

                 End Try
             End Get
             Set
                 End Try
             End Get
             Set

-                Me(Me.tableGames.IconColumn) = value
+                Me(Me.tableGames.TagsColumn) = value

             End Set
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
             End Set
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public Property Tags() As String
+        Public Property Theme_Colour() As Integer

             Get
                 Try 
             Get
                 Try 

-                    Return CType(Me(Me.tableGames.TagsColumn),String)
+                    Return CType(Me(Me.tableGames.Theme_ColourColumn),Integer)

                 Catch e As Global.System.InvalidCastException
                 Catch e As Global.System.InvalidCastException

-                    Throw New Global.System.Data.StrongTypingException("The value for column 'Tags' in table 'Games' is DBNull.", e)
+                    Throw New Global.System.Data.StrongTypingException("The value for column 'Theme Colour' in table 'Games' is DBNull.", e)

                 End Try
             End Get
             Set
                 End Try
             End Get
             Set

-                Me(Me.tableGames.TagsColumn) = value
+                Me(Me.tableGames.Theme_ColourColumn) = value

             End Set
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
             End Set
         End Property
         
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _

-        Public Property Theme_Colour() As Integer
+        Public Property Icon() As Byte()

             Get
                 Try 
             Get
                 Try 

-                    Return CType(Me(Me.tableGames.Theme_ColourColumn),Integer)
+                    Return CType(Me(Me.tableGames.IconColumn),Byte())

                 Catch e As Global.System.InvalidCastException
                 Catch e As Global.System.InvalidCastException

-                    Throw New Global.System.Data.StrongTypingException("The value for column 'Theme Colour' in table 'Games' is DBNull.", e)
+                    Throw New Global.System.Data.StrongTypingException("The value for column 'Icon' in table 'Games' is DBNull.", e)

                 End Try
             End Get
             Set
                 End Try
             End Get
             Set

-                Me(Me.tableGames.Theme_ColourColumn) = value
+                Me(Me.tableGames.IconColumn) = value

             End Set
         End Property
         
             End Set
         End Property
         


@@ -4481,18 +4480,6 @@ Partial Public Class NEADataSet
             Me(Me.tableGames.PublisherColumn) = Global.System.Convert.DBNull
         End Sub
         
             Me(Me.tableGames.PublisherColumn) = Global.System.Convert.DBNull
         End Sub
         

-        <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
-         Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
-        Public Function IsIconNull() As Boolean
-            Return Me.IsNull(Me.tableGames.IconColumn)
-        End Function
-        
-        <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
-         Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
-        Public Sub SetIconNull()
-            Me(Me.tableGames.IconColumn) = Global.System.Convert.DBNull
-        End Sub
-        

         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         Public Function IsTagsNull() As Boolean
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         Public Function IsTagsNull() As Boolean


@@ -4517,6 +4504,18 @@ Partial Public Class NEADataSet
             Me(Me.tableGames.Theme_ColourColumn) = Global.System.Convert.DBNull
         End Sub
         
             Me(Me.tableGames.Theme_ColourColumn) = Global.System.Convert.DBNull
         End Sub
         

+        <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
+         Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
+        Public Function IsIconNull() As Boolean
+            Return Me.IsNull(Me.tableGames.IconColumn)
+        End Function
+        
+        <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
+         Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
+        Public Sub SetIconNull()
+            Me(Me.tableGames.IconColumn) = Global.System.Convert.DBNull
+        End Sub
+        

         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         Public Function GetAchievementRows() As AchievementRow()
         <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(),  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")>  _
         Public Function GetAchievementRows() As AchievementRow()


@@ -6903,9 +6902,9 @@ Namespace NEADataSetTableAdapters
             tableMapping.ColumnMappings.Add("Certificate", "Certificate")
             tableMapping.ColumnMappings.Add("Dev", "Dev")
             tableMapping.ColumnMappings.Add("Publisher", "Publisher")
             tableMapping.ColumnMappings.Add("Certificate", "Certificate")
             tableMapping.ColumnMappings.Add("Dev", "Dev")
             tableMapping.ColumnMappings.Add("Publisher", "Publisher")

-            tableMapping.ColumnMappings.Add("Icon", "Icon")

             tableMapping.ColumnMappings.Add("Tags", "Tags")
             tableMapping.ColumnMappings.Add("Theme Colour", "Theme Colour")
             tableMapping.ColumnMappings.Add("Tags", "Tags")
             tableMapping.ColumnMappings.Add("Theme Colour", "Theme Colour")

+            tableMapping.ColumnMappings.Add("Icon", "Icon")

             Me._adapter.TableMappings.Add(tableMapping)
             Me._adapter.DeleteCommand = New Global.System.Data.OleDb.OleDbCommand()
             Me._adapter.DeleteCommand.Connection = Me.Connection
             Me._adapter.TableMappings.Add(tableMapping)
             Me._adapter.DeleteCommand = New Global.System.Data.OleDb.OleDbCommand()
             Me._adapter.DeleteCommand.Connection = Me.Connection


@@ -6926,7 +6925,7 @@ Namespace NEADataSetTableAdapters
             Me._adapter.InsertCommand = New Global.System.Data.OleDb.OleDbCommand()
             Me._adapter.InsertCommand.Connection = Me.Connection
             Me._adapter.InsertCommand.CommandText = "INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`"& _ 
             Me._adapter.InsertCommand = New Global.System.Data.OleDb.OleDbCommand()
             Me._adapter.InsertCommand.Connection = Me.Connection
             Me._adapter.InsertCommand.CommandText = "INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`"& _ 

-                ", `Icon`, `Tags`, `Theme Colour`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
+                ", `Tags`, `Theme Colour`, `Icon`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"

             Me._adapter.InsertCommand.CommandType = Global.System.Data.CommandType.Text
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Name", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Name", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Price", Global.System.Data.OleDb.OleDbType.Currency, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Price", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.CommandType = Global.System.Data.CommandType.Text
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Name", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Name", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Price", Global.System.Data.OleDb.OleDbType.Currency, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Price", Global.System.Data.DataRowVersion.Current, false, Nothing))


@@ -6934,13 +6933,13 @@ Namespace NEADataSetTableAdapters
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Certificate", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Certificate", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Dev", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Dev", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Publisher", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Publisher", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Certificate", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Certificate", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Dev", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Dev", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Publisher", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Publisher", Global.System.Data.DataRowVersion.Current, false, Nothing))

-            Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Icon", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Icon", Global.System.Data.DataRowVersion.Current, false, Nothing))

             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Tags", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Tags", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Theme_Colour", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Theme Colour", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Tags", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Tags", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Theme_Colour", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Theme Colour", Global.System.Data.DataRowVersion.Current, false, Nothing))

+            Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Icon", Global.System.Data.OleDb.OleDbType.LongVarBinary, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Icon", Global.System.Data.DataRowVersion.Current, false, Nothing))

             Me._adapter.UpdateCommand = New Global.System.Data.OleDb.OleDbCommand()
             Me._adapter.UpdateCommand.Connection = Me.Connection
             Me._adapter.UpdateCommand.CommandText = "UPDATE `Games` SET `Name` = ?, `Price` = ?, `Rating` = ?, `Certificate` = ?, `Dev"& _ 
             Me._adapter.UpdateCommand = New Global.System.Data.OleDb.OleDbCommand()
             Me._adapter.UpdateCommand.Connection = Me.Connection
             Me._adapter.UpdateCommand.CommandText = "UPDATE `Games` SET `Name` = ?, `Price` = ?, `Rating` = ?, `Certificate` = ?, `Dev"& _ 

-                "` = ?, `Publisher` = ?, `Icon` = ?, `Tags` = ?, `Theme Colour` = ? WHERE ((`Game"& _ 
+                "` = ?, `Publisher` = ?, `Tags` = ?, `Theme Colour` = ?, `Icon` = ? WHERE ((`Game"& _ 

                 "ID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rat"& _ 
                 "ing` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Cer"& _ 
                 "tificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?))"& _ 
                 "ID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rat"& _ 
                 "ing` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Cer"& _ 
                 "tificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?))"& _ 


@@ -6952,9 +6951,9 @@ Namespace NEADataSetTableAdapters
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Certificate", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Certificate", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Dev", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Dev", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Publisher", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Publisher", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Certificate", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Certificate", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Dev", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Dev", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Publisher", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Publisher", Global.System.Data.DataRowVersion.Current, false, Nothing))

-            Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Icon", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Icon", Global.System.Data.DataRowVersion.Current, false, Nothing))

             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Tags", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Tags", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Theme_Colour", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Theme Colour", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Tags", Global.System.Data.OleDb.OleDbType.LongVarWChar, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Tags", Global.System.Data.DataRowVersion.Current, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Theme_Colour", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Theme Colour", Global.System.Data.DataRowVersion.Current, false, Nothing))

+            Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Icon", Global.System.Data.OleDb.OleDbType.LongVarBinary, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Icon", Global.System.Data.DataRowVersion.Current, false, Nothing))

             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Original_GameID", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "GameID", Global.System.Data.DataRowVersion.Original, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("IsNull_Price", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Price", Global.System.Data.DataRowVersion.Original, true, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Original_Price", Global.System.Data.OleDb.OleDbType.Currency, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Price", Global.System.Data.DataRowVersion.Original, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Original_GameID", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "GameID", Global.System.Data.DataRowVersion.Original, false, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("IsNull_Price", Global.System.Data.OleDb.OleDbType.[Integer], 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Price", Global.System.Data.DataRowVersion.Original, true, Nothing))
             Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.OleDb.OleDbParameter("Original_Price", Global.System.Data.OleDb.OleDbType.Currency, 0, Global.System.Data.ParameterDirection.Input, CType(0,Byte), CType(0,Byte), "Price", Global.System.Data.DataRowVersion.Original, false, Nothing))


@@ -6979,8 +6978,8 @@ Namespace NEADataSetTableAdapters
             Me._commandCollection = New Global.System.Data.OleDb.OleDbCommand(0) {}
             Me._commandCollection(0) = New Global.System.Data.OleDb.OleDbCommand()
             Me._commandCollection(0).Connection = Me.Connection
             Me._commandCollection = New Global.System.Data.OleDb.OleDbCommand(0) {}
             Me._commandCollection(0) = New Global.System.Data.OleDb.OleDbCommand()
             Me._commandCollection(0).Connection = Me.Connection

-            Me._commandCollection(0).CommandText = "SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Icon, Tags, [The"& _ 
-                "me Colour] FROM Games"
+            Me._commandCollection(0).CommandText = "SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Tags, [Theme Col"& _ 
+                "our], Icon FROM Games"

             Me._commandCollection(0).CommandType = Global.System.Data.CommandType.Text
         End Sub
         
             Me._commandCollection(0).CommandType = Global.System.Data.CommandType.Text
         End Sub
         


@@ -7089,7 +7088,7 @@ Namespace NEADataSetTableAdapters
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"),  _
          Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"),  _
          Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Insert, true)>  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"),  _
          Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"),  _
          Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Insert, true)>  _

-        Public Overloads Overridable Function Insert(ByVal Name As String, ByVal Price As Global.System.Nullable(Of Decimal), ByVal Rating As Global.System.Nullable(Of Integer), ByVal Certificate As Global.System.Nullable(Of Integer), ByVal Dev As String, ByVal Publisher As String, ByVal Icon As String, ByVal Tags As String, ByVal Theme_Colour As Global.System.Nullable(Of Integer)) As Integer
+        Public Overloads Overridable Function Insert(ByVal Name As String, ByVal Price As Global.System.Nullable(Of Decimal), ByVal Rating As Global.System.Nullable(Of Integer), ByVal Certificate As Global.System.Nullable(Of Integer), ByVal Dev As String, ByVal Publisher As String, ByVal Tags As String, ByVal Theme_Colour As Global.System.Nullable(Of Integer), ByVal Icon() As Byte) As Integer

             If (Name Is Nothing) Then
                 Me.Adapter.InsertCommand.Parameters(0).Value = Global.System.DBNull.Value
             Else
             If (Name Is Nothing) Then
                 Me.Adapter.InsertCommand.Parameters(0).Value = Global.System.DBNull.Value
             Else


@@ -7120,20 +7119,20 @@ Namespace NEADataSetTableAdapters
             Else
                 Me.Adapter.InsertCommand.Parameters(5).Value = CType(Publisher,String)
             End If
             Else
                 Me.Adapter.InsertCommand.Parameters(5).Value = CType(Publisher,String)
             End If

-            If (Icon Is Nothing) Then
-                Me.Adapter.InsertCommand.Parameters(6).Value = Global.System.DBNull.Value
-            Else
-                Me.Adapter.InsertCommand.Parameters(6).Value = CType(Icon,String)
-            End If

             If (Tags Is Nothing) Then
             If (Tags Is Nothing) Then

-                Me.Adapter.InsertCommand.Parameters(7).Value = Global.System.DBNull.Value
+                Me.Adapter.InsertCommand.Parameters(6).Value = Global.System.DBNull.Value

             Else
             Else

-                Me.Adapter.InsertCommand.Parameters(7).Value = CType(Tags,String)
+                Me.Adapter.InsertCommand.Parameters(6).Value = CType(Tags,String)

             End If
             If (Theme_Colour.HasValue = true) Then
             End If
             If (Theme_Colour.HasValue = true) Then

-                Me.Adapter.InsertCommand.Parameters(8).Value = CType(Theme_Colour.Value,Integer)
+                Me.Adapter.InsertCommand.Parameters(7).Value = CType(Theme_Colour.Value,Integer)

             Else
             Else

+                Me.Adapter.InsertCommand.Parameters(7).Value = Global.System.DBNull.Value
+            End If
+            If (Icon Is Nothing) Then

                 Me.Adapter.InsertCommand.Parameters(8).Value = Global.System.DBNull.Value
                 Me.Adapter.InsertCommand.Parameters(8).Value = Global.System.DBNull.Value

+            Else
+                Me.Adapter.InsertCommand.Parameters(8).Value = CType(Icon,Byte())

             End If
             Dim previousConnectionState As Global.System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
             If ((Me.Adapter.InsertCommand.Connection.State And Global.System.Data.ConnectionState.Open)  _
             End If
             Dim previousConnectionState As Global.System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
             If ((Me.Adapter.InsertCommand.Connection.State And Global.System.Data.ConnectionState.Open)  _


@@ -7154,7 +7153,7 @@ Namespace NEADataSetTableAdapters
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"),  _
          Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"),  _
          Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Update, true)>  _
          Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"),  _
          Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"),  _
          Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Update, true)>  _

-        Public Overloads Overridable Function Update(ByVal Name As String, ByVal Price As Global.System.Nullable(Of Decimal), ByVal Rating As Global.System.Nullable(Of Integer), ByVal Certificate As Global.System.Nullable(Of Integer), ByVal Dev As String, ByVal Publisher As String, ByVal Icon As String, ByVal Tags As String, ByVal Theme_Colour As Global.System.Nullable(Of Integer), ByVal Original_GameID As Integer, ByVal Original_Price As Global.System.Nullable(Of Decimal), ByVal Original_Rating As Global.System.Nullable(Of Integer), ByVal Original_Certificate As Global.System.Nullable(Of Integer), ByVal Original_Theme_Colour As Global.System.Nullable(Of Integer)) As Integer
+        Public Overloads Overridable Function Update(ByVal Name As String, ByVal Price As Global.System.Nullable(Of Decimal), ByVal Rating As Global.System.Nullable(Of Integer), ByVal Certificate As Global.System.Nullable(Of Integer), ByVal Dev As String, ByVal Publisher As String, ByVal Tags As String, ByVal Theme_Colour As Global.System.Nullable(Of Integer), ByVal Icon() As Byte, ByVal Original_GameID As Integer, ByVal Original_Price As Global.System.Nullable(Of Decimal), ByVal Original_Rating As Global.System.Nullable(Of Integer), ByVal Original_Certificate As Global.System.Nullable(Of Integer), ByVal Original_Theme_Colour As Global.System.Nullable(Of Integer)) As Integer

             If (Name Is Nothing) Then
                 Me.Adapter.UpdateCommand.Parameters(0).Value = Global.System.DBNull.Value
             Else
             If (Name Is Nothing) Then
                 Me.Adapter.UpdateCommand.Parameters(0).Value = Global.System.DBNull.Value
             Else


@@ -7185,20 +7184,20 @@ Namespace NEADataSetTableAdapters
             Else
                 Me.Adapter.UpdateCommand.Parameters(5).Value = CType(Publisher,String)
             End If
             Else
                 Me.Adapter.UpdateCommand.Parameters(5).Value = CType(Publisher,String)
             End If

-            If (Icon Is Nothing) Then
-                Me.Adapter.UpdateCommand.Parameters(6).Value = Global.System.DBNull.Value
-            Else
-                Me.Adapter.UpdateCommand.Parameters(6).Value = CType(Icon,String)
-            End If

             If (Tags Is Nothing) Then
             If (Tags Is Nothing) Then

-                Me.Adapter.UpdateCommand.Parameters(7).Value = Global.System.DBNull.Value
+                Me.Adapter.UpdateCommand.Parameters(6).Value = Global.System.DBNull.Value

             Else
             Else

-                Me.Adapter.UpdateCommand.Parameters(7).Value = CType(Tags,String)
+                Me.Adapter.UpdateCommand.Parameters(6).Value = CType(Tags,String)

             End If
             If (Theme_Colour.HasValue = true) Then
             End If
             If (Theme_Colour.HasValue = true) Then

-                Me.Adapter.UpdateCommand.Parameters(8).Value = CType(Theme_Colour.Value,Integer)
+                Me.Adapter.UpdateCommand.Parameters(7).Value = CType(Theme_Colour.Value,Integer)

             Else
             Else

+                Me.Adapter.UpdateCommand.Parameters(7).Value = Global.System.DBNull.Value
+            End If
+            If (Icon Is Nothing) Then

                 Me.Adapter.UpdateCommand.Parameters(8).Value = Global.System.DBNull.Value
                 Me.Adapter.UpdateCommand.Parameters(8).Value = Global.System.DBNull.Value

+            Else
+                Me.Adapter.UpdateCommand.Parameters(8).Value = CType(Icon,Byte())

             End If
             Me.Adapter.UpdateCommand.Parameters(9).Value = CType(Original_GameID,Integer)
             If (Original_Price.HasValue = true) Then
             End If
             Me.Adapter.UpdateCommand.Parameters(9).Value = CType(Original_GameID,Integer)
             If (Original_Price.HasValue = true) Then

diff --git a/NEA/NEADataSet.xsc b/NEA/NEADataSet.xsc
index e69de29bb2d1d6434b8b29ae775ad8c2e48c5391..4a941daa1f98778d557dd6fbce6a3824ca211b4a 100644 (file)
--- a/NEA/NEADataSet.xsc
+++ b/NEA/NEADataSet.xsc
@@ -0,0 +1,9 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--<autogenerated>
+     This code was generated by a tool.
+     Changes to this file may cause incorrect behavior and will be lost if
+     the code is regenerated.
+</autogenerated>-->
+<DataSetUISetting Version="1.00" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
+  <TableUISettings />
+</DataSetUISetting>
\ No newline at end of file

diff --git a/NEA/NEADataSet.xsd b/NEA/NEADataSet.xsd
index 9b98cc16e21b5c793f6d51c204decee1d00776df..daef810527e63b77b50eab71f4ee7a167c39fbf2 100644 (file)
--- a/NEA/NEADataSet.xsd
+++ b/NEA/NEADataSet.xsd
@@ -209,7 +209,7 @@
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                 </DeleteCommand>
                 <InsertCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <CommandText>INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Icon`, `Tags`, `Theme Colour`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
+                    <CommandText>INSERT INTO `Games` (`Name`, `Price`, `Rating`, `Certificate`, `Dev`, `Publisher`, `Tags`, `Theme Colour`, `Icon`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>

                     <Parameters>
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                     <Parameters>
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />


@@ -217,21 +217,21 @@
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dev" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Dev" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Publisher" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dev" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Dev" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Publisher" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="false" SourceVersion="Current" />

-                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />

                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tags" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Tags" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tags" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Tags" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Current" />

+                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />

                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>
                     </Parameters>
                   </DbCommand>
                 </InsertCommand>
                 <SelectCommand>

-                  <DbCommand CommandType="Text" ModifiedByUser="false">
-                    <CommandText>SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Icon, Tags, [Theme Colour] FROM Games</CommandText>
+                  <DbCommand CommandType="Text" ModifiedByUser="true">
+                    <CommandText>SELECT GameID, Name, Price, Rating, Certificate, Dev, Publisher, Tags, [Theme Colour], Icon FROM Games</CommandText>

                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">
                     <Parameters />
                   </DbCommand>
                 </SelectCommand>
                 <UpdateCommand>
                   <DbCommand CommandType="Text" ModifiedByUser="false">

-                    <CommandText>UPDATE `Games` SET `Name` = ?, `Price` = ?, `Rating` = ?, `Certificate` = ?, `Dev` = ?, `Publisher` = ?, `Icon` = ?, `Tags` = ?, `Theme Colour` = ? WHERE ((`GameID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Certificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?)))</CommandText>
+                    <CommandText>UPDATE `Games` SET `Name` = ?, `Price` = ?, `Rating` = ?, `Certificate` = ?, `Dev` = ?, `Publisher` = ?, `Tags` = ?, `Theme Colour` = ?, `Icon` = ? WHERE ((`GameID` = ?) AND ((? = 1 AND `Price` IS NULL) OR (`Price` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Certificate` IS NULL) OR (`Certificate` = ?)) AND ((? = 1 AND `Theme Colour` IS NULL) OR (`Theme Colour` = ?)))</CommandText>

                     <Parameters>
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                     <Parameters>
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />


@@ -239,9 +239,9 @@
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dev" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Dev" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Publisher" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Certificate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Certificate" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Dev" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Dev" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Publisher" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="false" SourceVersion="Current" />

-                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />

                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tags" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Tags" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tags" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Tags" SourceColumnNullMapping="false" SourceVersion="Current" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Theme_Colour" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme Colour" SourceColumnNullMapping="false" SourceVersion="Current" />

+                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="Icon" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="Icon" SourceColumnNullMapping="false" SourceVersion="Current" />

                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_GameID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GameID" SourceColumnNullMapping="false" SourceVersion="Original" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Price" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />


@@ -264,9 +264,9 @@
               <Mapping SourceColumn="Certificate" DataSetColumn="Certificate" />
               <Mapping SourceColumn="Dev" DataSetColumn="Dev" />
               <Mapping SourceColumn="Publisher" DataSetColumn="Publisher" />
               <Mapping SourceColumn="Certificate" DataSetColumn="Certificate" />
               <Mapping SourceColumn="Dev" DataSetColumn="Dev" />
               <Mapping SourceColumn="Publisher" DataSetColumn="Publisher" />

-              <Mapping SourceColumn="Icon" DataSetColumn="Icon" />

               <Mapping SourceColumn="Tags" DataSetColumn="Tags" />
               <Mapping SourceColumn="Theme Colour" DataSetColumn="Theme Colour" />
               <Mapping SourceColumn="Tags" DataSetColumn="Tags" />
               <Mapping SourceColumn="Theme Colour" DataSetColumn="Theme Colour" />

+              <Mapping SourceColumn="Icon" DataSetColumn="Icon" />

             </Mappings>
             <Sources />
           </TableAdapter>
             </Mappings>
             <Sources />
           </TableAdapter>


@@ -604,7 +604,7 @@
   <xs:element name="NEADataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="NEADataSet" msprop:Generator_UserDSName="NEADataSet">
     <xs:complexType>
       <xs:choice minOccurs="0" maxOccurs="unbounded">
   <xs:element name="NEADataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="NEADataSet" msprop:Generator_UserDSName="NEADataSet">
     <xs:complexType>
       <xs:choice minOccurs="0" maxOccurs="unbounded">

-        <xs:element name="Achievement" msprop:Generator_TableClassName="AchievementDataTable" msprop:Generator_TableVarName="tableAchievement" msprop:Generator_TablePropName="Achievement" msprop:Generator_RowDeletingName="AchievementRowDeleting" msprop:Generator_RowChangingName="AchievementRowChanging" msprop:Generator_RowEvHandlerName="AchievementRowChangeEventHandler" msprop:Generator_RowDeletedName="AchievementRowDeleted" msprop:Generator_UserTableName="Achievement" msprop:Generator_RowChangedName="AchievementRowChanged" msprop:Generator_RowEvArgName="AchievementRowChangeEvent" msprop:Generator_RowClassName="AchievementRow">
+        <xs:element name="Achievement" msprop:Generator_TableClassName="AchievementDataTable" msprop:Generator_TableVarName="tableAchievement" msprop:Generator_RowChangedName="AchievementRowChanged" msprop:Generator_TablePropName="Achievement" msprop:Generator_RowDeletingName="AchievementRowDeleting" msprop:Generator_RowChangingName="AchievementRowChanging" msprop:Generator_RowEvHandlerName="AchievementRowChangeEventHandler" msprop:Generator_RowDeletedName="AchievementRowDeleted" msprop:Generator_RowClassName="AchievementRow" msprop:Generator_UserTableName="Achievement" msprop:Generator_RowEvArgName="AchievementRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="AchievementID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAchievementID" msprop:Generator_ColumnPropNameInRow="AchievementID" msprop:Generator_ColumnPropNameInTable="AchievementIDColumn" msprop:Generator_UserColumnName="AchievementID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="AchievementID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAchievementID" msprop:Generator_ColumnPropNameInRow="AchievementID" msprop:Generator_ColumnPropNameInTable="AchievementIDColumn" msprop:Generator_UserColumnName="AchievementID" type="xs:int" />


@@ -648,7 +648,7 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="DOW" msprop:Generator_TableClassName="DOWDataTable" msprop:Generator_TableVarName="tableDOW" msprop:Generator_TablePropName="DOW" msprop:Generator_RowDeletingName="DOWRowDeleting" msprop:Generator_RowChangingName="DOWRowChanging" msprop:Generator_RowEvHandlerName="DOWRowChangeEventHandler" msprop:Generator_RowDeletedName="DOWRowDeleted" msprop:Generator_UserTableName="DOW" msprop:Generator_RowChangedName="DOWRowChanged" msprop:Generator_RowEvArgName="DOWRowChangeEvent" msprop:Generator_RowClassName="DOWRow">
+        <xs:element name="DOW" msprop:Generator_TableClassName="DOWDataTable" msprop:Generator_TableVarName="tableDOW" msprop:Generator_RowChangedName="DOWRowChanged" msprop:Generator_TablePropName="DOW" msprop:Generator_RowDeletingName="DOWRowDeleting" msprop:Generator_RowChangingName="DOWRowChanging" msprop:Generator_RowEvHandlerName="DOWRowChangeEventHandler" msprop:Generator_RowDeletedName="DOWRowDeleted" msprop:Generator_RowClassName="DOWRow" msprop:Generator_UserTableName="DOW" msprop:Generator_RowEvArgName="DOWRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="DOWID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDOWID" msprop:Generator_ColumnPropNameInRow="DOWID" msprop:Generator_ColumnPropNameInTable="DOWIDColumn" msprop:Generator_UserColumnName="DOWID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="DOWID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDOWID" msprop:Generator_ColumnPropNameInRow="DOWID" msprop:Generator_ColumnPropNameInTable="DOWIDColumn" msprop:Generator_UserColumnName="DOWID" type="xs:int" />


@@ -658,7 +658,7 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Friends" msprop:Generator_TableClassName="FriendsDataTable" msprop:Generator_TableVarName="tableFriends" msprop:Generator_TablePropName="Friends" msprop:Generator_RowDeletingName="FriendsRowDeleting" msprop:Generator_RowChangingName="FriendsRowChanging" msprop:Generator_RowEvHandlerName="FriendsRowChangeEventHandler" msprop:Generator_RowDeletedName="FriendsRowDeleted" msprop:Generator_UserTableName="Friends" msprop:Generator_RowChangedName="FriendsRowChanged" msprop:Generator_RowEvArgName="FriendsRowChangeEvent" msprop:Generator_RowClassName="FriendsRow">
+        <xs:element name="Friends" msprop:Generator_TableClassName="FriendsDataTable" msprop:Generator_TableVarName="tableFriends" msprop:Generator_RowChangedName="FriendsRowChanged" msprop:Generator_TablePropName="Friends" msprop:Generator_RowDeletingName="FriendsRowDeleting" msprop:Generator_RowChangingName="FriendsRowChanging" msprop:Generator_RowEvHandlerName="FriendsRowChangeEventHandler" msprop:Generator_RowDeletedName="FriendsRowDeleted" msprop:Generator_RowClassName="FriendsRow" msprop:Generator_UserTableName="Friends" msprop:Generator_RowEvArgName="FriendsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />


@@ -667,7 +667,7 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Games" msprop:Generator_TableClassName="GamesDataTable" msprop:Generator_TableVarName="tableGames" msprop:Generator_TablePropName="Games" msprop:Generator_RowDeletingName="GamesRowDeleting" msprop:Generator_RowChangingName="GamesRowChanging" msprop:Generator_RowEvHandlerName="GamesRowChangeEventHandler" msprop:Generator_RowDeletedName="GamesRowDeleted" msprop:Generator_UserTableName="Games" msprop:Generator_RowChangedName="GamesRowChanged" msprop:Generator_RowEvArgName="GamesRowChangeEvent" msprop:Generator_RowClassName="GamesRow">
+        <xs:element name="Games" msprop:Generator_TableClassName="GamesDataTable" msprop:Generator_TableVarName="tableGames" msprop:Generator_RowChangedName="GamesRowChanged" msprop:Generator_TablePropName="Games" msprop:Generator_RowDeletingName="GamesRowDeleting" msprop:Generator_RowChangingName="GamesRowChanging" msprop:Generator_RowEvHandlerName="GamesRowChangeEventHandler" msprop:Generator_RowDeletedName="GamesRowDeleted" msprop:Generator_RowClassName="GamesRow" msprop:Generator_UserTableName="Games" msprop:Generator_RowEvArgName="GamesRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="GameID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="GameID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnGameID" msprop:Generator_ColumnPropNameInRow="GameID" msprop:Generator_ColumnPropNameInTable="GameIDColumn" msprop:Generator_UserColumnName="GameID" type="xs:int" />


@@ -695,13 +695,6 @@
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>
                   </xs:restriction>
                 </xs:simpleType>
               </xs:element>

-              <xs:element name="Icon" msprop:Generator_ColumnVarNameInTable="columnIcon" msprop:Generator_ColumnPropNameInRow="Icon" msprop:Generator_ColumnPropNameInTable="IconColumn" msprop:Generator_UserColumnName="Icon" minOccurs="0">
-                <xs:simpleType>
-                  <xs:restriction base="xs:string">
-                    <xs:maxLength value="536870910" />
-                  </xs:restriction>
-                </xs:simpleType>
-              </xs:element>

               <xs:element name="Tags" msprop:Generator_ColumnVarNameInTable="columnTags" msprop:Generator_ColumnPropNameInRow="Tags" msprop:Generator_ColumnPropNameInTable="TagsColumn" msprop:Generator_UserColumnName="Tags" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">
               <xs:element name="Tags" msprop:Generator_ColumnVarNameInTable="columnTags" msprop:Generator_ColumnPropNameInRow="Tags" msprop:Generator_ColumnPropNameInTable="TagsColumn" msprop:Generator_UserColumnName="Tags" minOccurs="0">
                 <xs:simpleType>
                   <xs:restriction base="xs:string">


@@ -710,10 +703,11 @@
                 </xs:simpleType>
               </xs:element>
               <xs:element name="Theme_x0020_Colour" msprop:Generator_ColumnVarNameInTable="columnTheme_Colour" msprop:Generator_ColumnPropNameInRow="Theme_Colour" msprop:Generator_ColumnPropNameInTable="Theme_ColourColumn" msprop:Generator_UserColumnName="Theme Colour" type="xs:int" minOccurs="0" />
                 </xs:simpleType>
               </xs:element>
               <xs:element name="Theme_x0020_Colour" msprop:Generator_ColumnVarNameInTable="columnTheme_Colour" msprop:Generator_ColumnPropNameInRow="Theme_Colour" msprop:Generator_ColumnPropNameInTable="Theme_ColourColumn" msprop:Generator_UserColumnName="Theme Colour" type="xs:int" minOccurs="0" />

+              <xs:element name="Icon" msprop:Generator_ColumnVarNameInTable="columnIcon" msprop:Generator_ColumnPropNameInRow="Icon" msprop:Generator_ColumnPropNameInTable="IconColumn" msprop:Generator_UserColumnName="Icon" type="xs:base64Binary" minOccurs="0" />

             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Purchased" msprop:Generator_TableClassName="PurchasedDataTable" msprop:Generator_TableVarName="tablePurchased" msprop:Generator_TablePropName="Purchased" msprop:Generator_RowDeletingName="PurchasedRowDeleting" msprop:Generator_RowChangingName="PurchasedRowChanging" msprop:Generator_RowEvHandlerName="PurchasedRowChangeEventHandler" msprop:Generator_RowDeletedName="PurchasedRowDeleted" msprop:Generator_UserTableName="Purchased" msprop:Generator_RowChangedName="PurchasedRowChanged" msprop:Generator_RowEvArgName="PurchasedRowChangeEvent" msprop:Generator_RowClassName="PurchasedRow">
+        <xs:element name="Purchased" msprop:Generator_TableClassName="PurchasedDataTable" msprop:Generator_TableVarName="tablePurchased" msprop:Generator_RowChangedName="PurchasedRowChanged" msprop:Generator_TablePropName="Purchased" msprop:Generator_RowDeletingName="PurchasedRowDeleting" msprop:Generator_RowChangingName="PurchasedRowChanging" msprop:Generator_RowEvHandlerName="PurchasedRowChangeEventHandler" msprop:Generator_RowDeletedName="PurchasedRowDeleted" msprop:Generator_RowClassName="PurchasedRow" msprop:Generator_UserTableName="Purchased" msprop:Generator_RowEvArgName="PurchasedRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="PurchaseID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPurchaseID" msprop:Generator_ColumnPropNameInRow="PurchaseID" msprop:Generator_ColumnPropNameInTable="PurchaseIDColumn" msprop:Generator_UserColumnName="PurchaseID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="PurchaseID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPurchaseID" msprop:Generator_ColumnPropNameInRow="PurchaseID" msprop:Generator_ColumnPropNameInTable="PurchaseIDColumn" msprop:Generator_UserColumnName="PurchaseID" type="xs:int" />


@@ -722,7 +716,7 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Reviews" msprop:Generator_TableClassName="ReviewsDataTable" msprop:Generator_TableVarName="tableReviews" msprop:Generator_TablePropName="Reviews" msprop:Generator_RowDeletingName="ReviewsRowDeleting" msprop:Generator_RowChangingName="ReviewsRowChanging" msprop:Generator_RowEvHandlerName="ReviewsRowChangeEventHandler" msprop:Generator_RowDeletedName="ReviewsRowDeleted" msprop:Generator_UserTableName="Reviews" msprop:Generator_RowChangedName="ReviewsRowChanged" msprop:Generator_RowEvArgName="ReviewsRowChangeEvent" msprop:Generator_RowClassName="ReviewsRow">
+        <xs:element name="Reviews" msprop:Generator_TableClassName="ReviewsDataTable" msprop:Generator_TableVarName="tableReviews" msprop:Generator_RowChangedName="ReviewsRowChanged" msprop:Generator_TablePropName="Reviews" msprop:Generator_RowDeletingName="ReviewsRowDeleting" msprop:Generator_RowChangingName="ReviewsRowChanging" msprop:Generator_RowEvHandlerName="ReviewsRowChangeEventHandler" msprop:Generator_RowDeletedName="ReviewsRowDeleted" msprop:Generator_RowClassName="ReviewsRow" msprop:Generator_UserTableName="Reviews" msprop:Generator_RowEvArgName="ReviewsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="ReviewID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnReviewID" msprop:Generator_ColumnPropNameInRow="ReviewID" msprop:Generator_ColumnPropNameInTable="ReviewIDColumn" msprop:Generator_UserColumnName="ReviewID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="ReviewID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnReviewID" msprop:Generator_ColumnPropNameInRow="ReviewID" msprop:Generator_ColumnPropNameInTable="ReviewIDColumn" msprop:Generator_UserColumnName="ReviewID" type="xs:int" />


@@ -737,14 +731,14 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Tags" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_TablePropName="Tags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_UserTableName="Tags" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_RowEvArgName="TagsRowChangeEvent" msprop:Generator_RowClassName="TagsRow">
+        <xs:element name="Tags" msprop:Generator_TableClassName="TagsDataTable" msprop:Generator_TableVarName="tableTags" msprop:Generator_RowChangedName="TagsRowChanged" msprop:Generator_TablePropName="Tags" msprop:Generator_RowDeletingName="TagsRowDeleting" msprop:Generator_RowChangingName="TagsRowChanging" msprop:Generator_RowEvHandlerName="TagsRowChangeEventHandler" msprop:Generator_RowDeletedName="TagsRowDeleted" msprop:Generator_RowClassName="TagsRow" msprop:Generator_UserTableName="Tags" msprop:Generator_RowEvArgName="TagsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
             </xs:sequence>
           </xs:complexType>
         </xs:element>
           <xs:complexType>
             <xs:sequence>
               <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="User_Details" msprop:Generator_TableClassName="User_DetailsDataTable" msprop:Generator_TableVarName="tableUser_Details" msprop:Generator_TablePropName="User_Details" msprop:Generator_RowDeletingName="User_DetailsRowDeleting" msprop:Generator_RowChangingName="User_DetailsRowChanging" msprop:Generator_RowEvHandlerName="User_DetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="User_DetailsRowDeleted" msprop:Generator_UserTableName="User_Details" msprop:Generator_RowChangedName="User_DetailsRowChanged" msprop:Generator_RowEvArgName="User_DetailsRowChangeEvent" msprop:Generator_RowClassName="User_DetailsRow">
+        <xs:element name="User_Details" msprop:Generator_TableClassName="User_DetailsDataTable" msprop:Generator_TableVarName="tableUser_Details" msprop:Generator_RowChangedName="User_DetailsRowChanged" msprop:Generator_TablePropName="User_Details" msprop:Generator_RowDeletingName="User_DetailsRowDeleting" msprop:Generator_RowChangingName="User_DetailsRowChanging" msprop:Generator_RowEvHandlerName="User_DetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="User_DetailsRowDeleted" msprop:Generator_RowClassName="User_DetailsRow" msprop:Generator_UserTableName="User_Details" msprop:Generator_RowEvArgName="User_DetailsRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="UserDetailsID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserDetailsID" msprop:Generator_ColumnPropNameInRow="UserDetailsID" msprop:Generator_ColumnPropNameInTable="UserDetailsIDColumn" msprop:Generator_UserColumnName="UserDetailsID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="UserDetailsID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserDetailsID" msprop:Generator_ColumnPropNameInRow="UserDetailsID" msprop:Generator_ColumnPropNameInTable="UserDetailsIDColumn" msprop:Generator_UserColumnName="UserDetailsID" type="xs:int" />


@@ -803,7 +797,7 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowClassName="UsersRow">
+        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowClassName="UsersRow" msprop:Generator_UserTableName="Users" msprop:Generator_RowEvArgName="UsersRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="UserID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="UserID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" />


@@ -825,7 +819,7 @@
             </xs:sequence>
           </xs:complexType>
         </xs:element>
             </xs:sequence>
           </xs:complexType>
         </xs:element>

-        <xs:element name="Wishlist" msprop:Generator_TableClassName="WishlistDataTable" msprop:Generator_TableVarName="tableWishlist" msprop:Generator_TablePropName="Wishlist" msprop:Generator_RowDeletingName="WishlistRowDeleting" msprop:Generator_RowChangingName="WishlistRowChanging" msprop:Generator_RowEvHandlerName="WishlistRowChangeEventHandler" msprop:Generator_RowDeletedName="WishlistRowDeleted" msprop:Generator_UserTableName="Wishlist" msprop:Generator_RowChangedName="WishlistRowChanged" msprop:Generator_RowEvArgName="WishlistRowChangeEvent" msprop:Generator_RowClassName="WishlistRow">
+        <xs:element name="Wishlist" msprop:Generator_TableClassName="WishlistDataTable" msprop:Generator_TableVarName="tableWishlist" msprop:Generator_RowChangedName="WishlistRowChanged" msprop:Generator_TablePropName="Wishlist" msprop:Generator_RowDeletingName="WishlistRowDeleting" msprop:Generator_RowChangingName="WishlistRowChanging" msprop:Generator_RowEvHandlerName="WishlistRowChangeEventHandler" msprop:Generator_RowDeletedName="WishlistRowDeleted" msprop:Generator_RowClassName="WishlistRow" msprop:Generator_UserTableName="Wishlist" msprop:Generator_RowEvArgName="WishlistRowChangeEvent">

           <xs:complexType>
             <xs:sequence>
               <xs:element name="WishlistID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnWishlistID" msprop:Generator_ColumnPropNameInRow="WishlistID" msprop:Generator_ColumnPropNameInTable="WishlistIDColumn" msprop:Generator_UserColumnName="WishlistID" type="xs:int" />
           <xs:complexType>
             <xs:sequence>
               <xs:element name="WishlistID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnWishlistID" msprop:Generator_ColumnPropNameInRow="WishlistID" msprop:Generator_ColumnPropNameInTable="WishlistIDColumn" msprop:Generator_UserColumnName="WishlistID" type="xs:int" />


@@ -879,12 +873,12 @@
   </xs:element>
   <xs:annotation>
     <xs:appinfo>
   </xs:element>
   <xs:annotation>
     <xs:appinfo>

-      <msdata:Relationship name="GamesAchievement" msdata:parent="Games" msdata:child="Achievement" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Achievement" msprop:Generator_ChildPropName="GetAchievementRows" msprop:Generator_UserRelationName="GamesAchievement" msprop:Generator_RelationVarName="relationGamesAchievement" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
-      <msdata:Relationship name="GamesDOW" msdata:parent="Games" msdata:child="DOW" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="DOW" msprop:Generator_ChildPropName="GetDOWRows" msprop:Generator_UserRelationName="GamesDOW" msprop:Generator_RelationVarName="relationGamesDOW" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
-      <msdata:Relationship name="GamesPurchased" msdata:parent="Games" msdata:child="Purchased" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Purchased" msprop:Generator_ChildPropName="GetPurchasedRows" msprop:Generator_UserRelationName="GamesPurchased" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesPurchased" msprop:Generator_UserParentTable="Games" />
-      <msdata:Relationship name="GamesReviews" msdata:parent="Games" msdata:child="Reviews" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Reviews" msprop:Generator_ChildPropName="GetReviewsRows" msprop:Generator_UserRelationName="GamesReviews" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesReviews" msprop:Generator_UserParentTable="Games" />
-      <msdata:Relationship name="User_DetailsUsers" msdata:parent="User_Details" msdata:child="Users" msdata:parentkey="UserDetailsID" msdata:childkey="User_DetailsID" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="User_DetailsUsers" msprop:Generator_ParentPropName="User_DetailsRow" msprop:Generator_RelationVarName="relationUser_DetailsUsers" msprop:Generator_UserParentTable="User_Details" />
-      <msdata:Relationship name="GamesWishlist" msdata:parent="Games" msdata:child="Wishlist" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Wishlist" msprop:Generator_ChildPropName="GetWishlistRows" msprop:Generator_UserRelationName="GamesWishlist" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesWishlist" msprop:Generator_UserParentTable="Games" />
+      <msdata:Relationship name="GamesAchievement" msdata:parent="Games" msdata:child="Achievement" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Achievement" msprop:Generator_ChildPropName="GetAchievementRows" msprop:Generator_UserRelationName="GamesAchievement" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesAchievement" msprop:Generator_UserParentTable="Games" />
+      <msdata:Relationship name="GamesDOW" msdata:parent="Games" msdata:child="DOW" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="DOW" msprop:Generator_ChildPropName="GetDOWRows" msprop:Generator_UserRelationName="GamesDOW" msprop:Generator_ParentPropName="GamesRow" msprop:Generator_RelationVarName="relationGamesDOW" msprop:Generator_UserParentTable="Games" />
+      <msdata:Relationship name="GamesPurchased" msdata:parent="Games" msdata:child="Purchased" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Purchased" msprop:Generator_ChildPropName="GetPurchasedRows" msprop:Generator_UserRelationName="GamesPurchased" msprop:Generator_RelationVarName="relationGamesPurchased" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
+      <msdata:Relationship name="GamesReviews" msdata:parent="Games" msdata:child="Reviews" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Reviews" msprop:Generator_ChildPropName="GetReviewsRows" msprop:Generator_UserRelationName="GamesReviews" msprop:Generator_RelationVarName="relationGamesReviews" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />
+      <msdata:Relationship name="User_DetailsUsers" msdata:parent="User_Details" msdata:child="Users" msdata:parentkey="UserDetailsID" msdata:childkey="User_DetailsID" msprop:Generator_UserChildTable="Users" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="User_DetailsUsers" msprop:Generator_RelationVarName="relationUser_DetailsUsers" msprop:Generator_UserParentTable="User_Details" msprop:Generator_ParentPropName="User_DetailsRow" />
+      <msdata:Relationship name="GamesWishlist" msdata:parent="Games" msdata:child="Wishlist" msdata:parentkey="GameID" msdata:childkey="GameID" msprop:Generator_UserChildTable="Wishlist" msprop:Generator_ChildPropName="GetWishlistRows" msprop:Generator_UserRelationName="GamesWishlist" msprop:Generator_RelationVarName="relationGamesWishlist" msprop:Generator_UserParentTable="Games" msprop:Generator_ParentPropName="GamesRow" />

     </xs:appinfo>
   </xs:annotation>
 </xs:schema>
\ No newline at end of file
     </xs:appinfo>
   </xs:annotation>
 </xs:schema>
\ No newline at end of file