hello i am new using teleriks controls well i am new in asp.net too, i have some problems, i am using a radgrid than could update some information, in the sql statements of update i have two conditions COD_COMPRA that i call from textbox and COD_MATPRI, the first one is all good but when i try to use both COD_MATPRI and COD_COMPRA not update anything...this is my code i hope u can help me
<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource5"
GridLines="None" AllowAutomaticUpdates="True"
AutoGenerateEditColumn="True" AllowAutomaticInserts="True">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="COD_MATPRIMA"
DataSourceID="SqlDataSource5" EditMode="InPlace">
<Columns>
<telerik:GridBoundColumn DataField="COD_MATPRIMA" HeaderText="COD_MATPRIMA"
ReadOnly="True" SortExpression="COD_MATPRIMA" UniqueName="COD_MATPRIMA">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="NOMMATPRI"
HeaderText="NOMMATPRI" SortExpression="NOMMATPRI"
UniqueName="NOMMATPRI">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CANTIDAD" HeaderText="CANTIDAD"
SortExpression="CANTIDAD" UniqueName="CANTIDAD" DataType="System.Single">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="NOMBREMEDIDA"
HeaderText="NOMBREMEDIDA" SortExpression="NOMBREMEDIDA"
UniqueName="NOMBREMEDIDA">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="PRECIO" HeaderText="PRECIO"
SortExpression="PRECIO" UniqueName="PRECIO" DataType="System.Decimal">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TOTAL" DataType="System.Single"
HeaderText="TOTAL" SortExpression="TOTAL" UniqueName="TOTAL"
ReadOnly="True">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<EditColumn UniqueName="
EditCommandColumn1">
</EditColumn>
</EditFormSettings>
</MasterTableView>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
ConnectionString="<%$ ConnectionStrings:SICI2.0ConnectionString2 %>"
SelectCommand="SELECT TBL_MATERIAPRIMA.COD_MATPRIMA,
TBL_MATERIAPRIMA.NOMMATPRI, TBL_COM_MP.CANTIDAD,
TBL_MEDIDA.NOMBREMEDIDA, TBL_COM_MP.PRECIO, TBL_COM_MP.CANTIDAD *
TBL_COM_MP.PRECIO AS TOTAL FROM TBL_COMPRA INNER JOIN TBL_COM_MP ON
TBL_COMPRA.COD_COMPRA = TBL_COM_MP.COD_COMPRA INNER JOIN
TBL_MATERIAPRIMA ON TBL_COM_MP.COD_MATPRIMA =
TBL_MATERIAPRIMA.COD_MATPRIMA INNER JOIN TBL_MEDIDA ON
TBL_MATERIAPRIMA.COD_MEDIDA = TBL_MEDIDA.COD_MEDIDA WHERE
(TBL_COMPRA.COD_COMPRA = @id_compra)"
UpdateCommand="UPDATE TBL_COM_MP SET CANTIDAD = @cantidad,
PRECIO = @precio WHERE (COD_COMPRA=@id_compra and
COD_MATPRIMA=@cod_matprima) ">
<SelectParameters>
<asp:ControlParameter ControlID="txtnumorden" Name="id_compra"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="cod_matprima"/>
<asp:Parameter Name="cantidad"/>
<asp:Parameter Name="precio" />
<asp:ControlParameter ControlID="txtnumorden" Name="id_compra"
PropertyName="Text" />
</UpdateParameters>
</asp:SqlDataSource>
the second question is what can i do if i want to refresh when i update the radgrid... other part of my webpage... i mean i have radgrid and from data of the radgrid i have to calculate the total, IVA, etc or maybe refresh the enterire page thanks