Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America

asked on 

Datakeyname - updatecommand

How can I update my data using DataKeyNames="RefID" when using <UpdateParameters>

 <asp:GridView ID="GridView3" runat="server" AllowPaging="True"
                    AllowSorting="True" AlternatingRowStyle-Wrap="True" AutoGenerateColumns="False"
                    AutoGenerateEditButton="True" DataKeyNames="RefID"
                    DataSourceID="SqlDataSource2" Font-Size="Small" FooterStyle-Font-Size="Medium"
                    PageSize="10" Width="698px">

etc..

<asp:BoundField DataField="RefID" HeaderText="RefID"
                            SortExpression="RefID" Visible="false" />



  <asp:SqlDataSource ID="SqlDataSource2" runat="server"
                ConnectionString="<%$ ConnectionStrings:dbdoneConnectionString %>"        
                              SelectCommand= "my sp1" SelectCommandType="StoredProcedure"
                              UpdateCommand="my sp2" UpdateCommandType="StoredProcedure">   < parameter is where datakeyname = Refid


etc...

<UpdateParameters>  < I am have storeprocedure for this
                <asp:Parameter Name="RefID" String="RefID" />  ?
                </UpdateParameters>
ASP.NET

Avatar of undefined
Last Comment
Sammy
ASKER CERTIFIED SOLUTION
Avatar of Sammy
Sammy
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASP.NET
ASP.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo