Cant update values

Hi Guys

I already searched for one day and didn't find any solution. Unfortunately I can't update my dataset. It works when I remove the string "WHERE ID = ?" in the UpdateCommand but then it updates all the records. I think it must be something obvious which I just don't see:(
There are two tables; tblArtists and tblCountries which are connected together with a Inner Join. Now, I need the ID from the table Artists to update the dataset. How can I get it?

Here the code:
...
SelectCommand="SELECT tblArtists.ID AS IDArtists, tblArtists.ArtistName, tblArtists.FirstName, tblArtists.LastName, tblArtists.Address, tblArtists.PLZ, tblArtists.City, tblArtists.Region, tblArtists.Country_ID, tblArtists.MusicStyles, tblArtists.HomeDJ, tblArtists.Active, tblArtists.CDate, tblArtists.Description, tblCountries.ID AS IDCountries, tblCountries.Country, tblArtists.Producer, tblArtists.Picture, tblArtists.Homepage, tblArtists.Phonenumber, tblArtists.eMail FROM (tblCountries INNER JOIN tblArtists ON tblCountries.ID = tblArtists.Country_ID) WHERE (tblArtists.Active = ?) AND (tblArtists.HomeDJ = ?) AND (tblArtists.Producer = ?)"
UpdateCommand="UPDATE tblArtists SET ArtistName = ?, FirstName = ?, LastName = ?, Address = ?, PLZ = ?, City = ?, Region = ?, Country_ID = ?, MusicStyles = ?, HomeDJ = ?, Active = ?, Description = ?, Producer = ?, Picture = ?, Homepage = ?, Phonenumber = ?, eMail = ? WHERE ID = ?">
<SelectParameters>
<asp:ControlParameter ControlID="activeRadioButton" Name="Active" PropertyName="Checked" Type="Boolean"/>
<asp:ControlParameter ControlID="homedjRadioButton" Name="HomeDJ" PropertyName="Checked" Type="Boolean"/>
<asp:ControlParameter ControlID="producerRadioButton" Name="Producer" PropertyName="Checked" Type="Boolean"/>
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="ArtistName" Type="String" Size="254" />
<asp:Parameter Name="FirstName" Type="String" Size="254" />
<asp:Parameter Name="LastName" Type="String" Size="254" />
<asp:Parameter Name="Address" Type="String" Size="254" />
<asp:Parameter Name="PLZ" Type="String" Size="254" />
<asp:Parameter Name="City" Type="String" Size="254" />
<asp:Parameter Name="Region" Type="String" Size="254" />
<asp:Parameter Name="Country_ID" />
<asp:Parameter Name="MusicStyles" Type="String" Size="254" />
<asp:Parameter Name="HomeDJ" Type="Boolean" />
<asp:Parameter Name="Active" Type="Boolean" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Producer" Type="Boolean" />
<asp:Parameter Name="Picture" Type="String" Size="254" />
<asp:Parameter Name="Homepage" Type="String" Size="254" />
<asp:Parameter Name="Phonenumber" Type="String" Size="50" />
<asp:Parameter Name="eMail" Type="String" Size="50" />
<asp:Parameter Name="original_IDArtists" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>

Greetings
Pat

Hi ya,

is it used in the context of GridVIew? If so did u set the DataKeyNames of the GridView ?

<asp:gridview runat="server" id="GridView1" datasourceid="ArtistsSource"
 AutoGenerateColumns="false"
 DataKeyNames="original_IDArtists" AutoGenerateEditButton="true">
 <columns>
 <asp:boundfield datafield="ArtistName" headertext="Artist Name" />
 <asp:boundfield datafield="FirstName" headertext="First Name" />

.......................
 </columns>
</asp:gridview

Hope this will help,

Yani

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.