Incorrect Syntax near WHERE

[teddymeu]

Hi Guys, new to development using visual studio and vb.net 2.0. and SQL express. Have a small problem.

I have an update command which im using to change the values of a blob image table to NULL so that i can then insert a new image into the table. This works fine. My problem is that my insert statement has an error and i cant figure this out. if i dont add the where clause it works fine but inserts the new image into the table without the product data, i want to insert the new image into the existing product information.

 <asp:SqlDataSource ID="productsUpdate" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringAccountType %>"
                     SelectCommand="SELECT [ProductID], [ProductName], [ImageTitle], [ImageData], [ImageMimeType] FROM [Products] WHERE [ProductID] = @ProductID"
                     UpdateCommand="UPDATE [Products] SET [ImageTitle] = Null, [ImageData] = Null, [ImageMimeType] = Null WHERE [ProductID] = @ProductID" InsertCommand="INSERT INTO [Products] ([ImageTitle], [ImageData], [ImageMimeType]) VALUES (@ImageTitle, @ImageData, @MimeType) WHERE ([ProductID] = @ProductID)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="GridView1" Name="ProductID" PropertyName="SelectedValue"
                            Type="Int32" />
                    </SelectParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="ImageTitle" />
                        <asp:Parameter Name="ImageData" Type="string" />
                        <asp:Parameter Name="MimeType" Type="string" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="ImageTitle" Type="String" />
                        <asp:Parameter Name="ImageData" />
                        <asp:Parameter Name="MimeType" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>

The error message i keep getting is "incorrect syntax near where"

Any help would be greatly appreciated
Thanks

[Vidhura]

you cannot use Where statement in insert statement

[Vidhura]

you cannot use Where clause in insert statement

[teddymeu]

you cannot use Where clause in insert statement

Ok let me rephrase this as a question. I have a table in my database called products, it holds th product information for example, price, size description. It also holds an image of the product. The site admin might want to update this image at some point. I tried creating a datagrid which showed all products from the product table without the image. I then used a select statement to pull the selected product details into a datagrid which had a databound text box for the image title, and file upload control to select the image. I used the same function as i had used before to upload the image in the first place. I created what i thought would be the correct update statement but kept recieveing a message saying, cannot convert varbinary max to varchar.

Any ideas?