«

[brunavillar]

I have a detailsview with 2 datakeynames, host_id and db_id. When I edit the registry I can modify the host_name, so I have to modify the host_id too. But when I update the host_id continue the same. I'm using stored procedures, and its right. what do i do?!?!?!?! Here is the code...

Private Sub sdsPrincipal_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEven tArgs)
For x As Integer = 0 To e.Command.Parameters.Count - 1
Trace.Write(e.Command.Parameters(x).ParameterName)
Trace.Write(e.Command.Parameters(x).Value)
Next


e.Command.Parameters("@HOST_ID").Value = e.Command.Parameters("@PRM_HOST_ID").Value
e.Command.Parameters.Remove(e.Command.Parameters(" @DB_DESC"))
e.Command.Parameters.Remove(e.Command.Parameters(" @HOST_ID"))
e.Command.Parameters.Remove(e.Command.Parameters(" @DB_VENDOR"))
e.Command.Parameters.Remove(e.Command.Parameters(" @DB_TYPE"))
e.Command.Parameters.Remove(e.Command.Parameters(" @DB_OBS"))

End Sub


<aspetailsView ID="DetailsView1" runat="server" DataSourceID="sdsPrincipal" AllowPaging="True"
OnItemUpdating="DetailsView1_ItemUpdating"
DataKeyNames="HOST_ID,DB_ID" CssClass="DetailsView1"
OnItemCommand="DetailsView1_ItemCommand" OnPageIndexChanging="DetailsView1_PageIndexChangin g"
AutoGenerateRows="False" CellPadding="4" ForeColor="#333333" GridLines="None" Width="347px">
<FooterStyle BackColor="#507CD1" ForeColor="White" CssClass="DetailsViewFooter" Font-Bold="True"></FooterStyle>

<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True"></CommandRowStyle>

<EditRowStyle BackColor="#2461BF" CssClass="DetailsViewEdit"></EditRowStyle>

<RowStyle BackColor="#EFF3FB"></RowStyle>

<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"></PagerStyle>
<Fields>
<asp:TemplateField><EditItemTemplate>
Edit Mode

</EditItemTemplate>
<InsertItemTemplate>
Insert Mode

</InsertItemTemplate>
<ItemTemplate>
Readonly Mode

</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="HOST_DESC">

<EditItemTemplate>
<asp:SqlDataSource id="sdsHosts" runat="server" SelectCommand="SELECT [HOST_ID], [HOST_DESC] FROM [HOST]" ConnectionString="<%$ ConnectionStrings:SupInfraConnectionString %>" CancelSelectOnNullParameter="False"></asp:SqlDataSource>
<aspropDownList id="ddlHosts" runat="server" DataValueField="HOST_ID" DataTextField="HOST_DESC" AppendDataBoundItens="true" DataSourceID="sdsHosts" SelectedValue='<%# Eval("HOST_ID") %>' AutoPostBack="true">
<asp:ListItem Value="">Selecione um HOST</asp:ListItem> </aspropDownList>

</EditItemTemplate>


<asp:SqlDataSource ID="sdsPrincipal" runat="server" ConnectionString="<%$ ConnectionStrings:SupInfraConnectionString %>"
DeleteCommand="SP_DATABASE_DEL" DeleteCommandType="StoredProcedure" InsertCommand="SP_DATABASE_INS"
InsertCommandType="StoredProcedure" SelectCommand="SP_DATABASE_SEL" SelectCommandType="StoredProcedure"
UpdateCommand="SP_DATABASE_UPD" UpdateCommandType="StoredProcedure" OnInserted="sdsPrincipal_Inserted" OnInserting="sdsPrincipal_Inserting" OnUpdating="sdsPrincipal_Updating" CancelSelectOnNullParameter="False" OldValuesParameterFormatString="PRM_{0}">
<DeleteParameters>
<asparameter Type="Int32" Name="PRM_HOST_ID"></asparameter>
<asparameter Type="Int32" Name="PRM_DB_ID"></asparameter>
</DeleteParameters>
<UpdateParameters>
<asp:ControlParameter Type="String" Name="PRM_DB_TYPE" ControlID="DetailsView1$ddlDB_TYPE" PropertyName="SelectedValue" />
<asp:ControlParameter Type="String" Name="PRM_DB_DESC" ControlID="DetailsView1$txtDB_DESC" />
<asp:ControlParameter Type="String" Name="PRM_DB_VENDOR" ControlID="DetailsView1$ddlDB_VENDOR_upd" PropertyName="SelectedValue" />
<asp:ControlParameter Type="String" Name="PRM_DB_OBS" ControlID="DetailsView1$txtDB_OBS" />
<asp:ControlParameter Type="Int32" Name="PRM_HOST_ID" ControlID="DetailsView1$ddlHosts" PropertyName="SelectedValue" />
<asparameter Type="Int32" ConvertEmptyStringToNull="false" Name="PRM_DB_ID"></asparameter>
</UpdateParameters>


PLEASE!!! HELP!!!!!