Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 878
  • Last Modified:

GridView UpdateParameters ReadOnly Issue

I have an Update parameter called "Weekjudge" which corresponds to one of the columns in my GridView".  I need to know the value of this field when the user does an edit so I can pass it back to the server to complete the update.  I'm able to make it work if I set the BoundField's ReadOnly Property to "False".  Problem is, I don't want to allow the user to edit it in the GridView.  In fact, I would prefer to not show the date associated with that field to the user.

I've tried:

(1) setting the BoundField's ReadOnly Property to "true"
(2) setting the BoundField's Visible Property to "false"
(3) setting the GridView's DataKeyNames to "WeekJudge"

   Unfortunately I've not been able to come up with a solution.

What do I try now?
<asp:GridView 
        ID="gridJudge"  
        AllowSorting="false" 
        AllowPaging="false" 
        DataKeyNames="WeekJudge"
        Runat="server"
        DataSourceID="SqlDataSource1"
        AutoGenerateColumns="False" 
        AutoGenerateEditButton="true"
        BorderStyle="Solid" 
        BorderColor="Black" 
        HeaderStyle-BackColor="Black" 
        HeaderStyle-ForeColor="White" RowStyle-BorderColor="Gray" RowStyle-BorderStyle="Solid" RowStyle-BorderWidth="1px"
        >
        <Columns>
          <asp:BoundField ReadOnly="true" HeaderText="Edit" DataField="Edit" SortExpression="Edit" />
          <asp:BoundField ReadOnly="true" HeaderText="Period Type" DataField="PeriodType" />
          <asp:BoundField ReadOnly="true" HeaderText="Period" DataField="PeriodName" />
          <asp:BoundField ReadOnly="true" HeaderText="Bookings" DataField="Bookings" DataFormatString="{0:#,###}" ItemStyle-HorizontalAlign="Right"/>
          <asp:BoundField ReadOnly="true" HeaderText="Commits" DataField="Commits" DataFormatString="{0:#,###}" ItemStyle-HorizontalAlign="Right"  />
          <asp:BoundField ReadOnly="true" HeaderText="Judges" DataField="Judges" DataFormatString="{0:#,###}" ItemStyle-HorizontalAlign="Right" />
          <asp:BoundField ReadOnly="true" HeaderText="Subtotal" DataField="SubTotal" DataFormatString="{0:#,###}" ItemStyle-HorizontalAlign="Right" />
          <asp:BoundField HeaderText="Judgment" DataField="Judgment" DataFormatString="{0:#,###}" ItemStyle-HorizontalAlign="Right" />
          <asp:BoundField ReadOnly="true" HeaderText="Total" DataField="Total" DataFormatString="{0:#,###}" ItemStyle-HorizontalAlign="Right" />
          <asp:BoundField HeaderText="Comment" DataField="Comment" ItemStyle-Width="300px" ItemStyle-BorderColor="Gray" ItemStyle-BorderStyle="Solid" />
          <asp:BoundField ReadOnly="false" HeaderText="WeekJudge" DataField="WeekJudge" />
       </Columns>
      </asp:GridView>
      <asp:SqlDataSource 
        ID="SqlDataSource1" 
        Runat="server" 
        SelectCommandType="StoredProcedure"
        SelectCommand="spJudgeUpload"
        UpdateCommand="spJudgeEdit"
        UpdateCommandType="StoredProcedure"
        ConnectionString="<%$ appSettings:EtgConnectionString %>"
        >
        <UpdateParameters>
            <asp:Parameter Type="String" Name="jUserId" DefaultValue='bsalle'/>
            <asp:Parameter Type="String" Name="WeekJudge" />
            <asp:Parameter Type="Double" Name="Judgment" />
            <asp:Parameter Type="String" Name="Comment" />
        </UpdateParameters>
    </asp:SqlDataSource>

Open in new window

0
kerrys57
Asked:
kerrys57
1 Solution
 
kavintCommented:
0
 
kerrys57Author Commented:
I used the style property to hide the column.
<style type="text/css">
    .hiddencol
    {
        display:none;
    }
    .viscol
    {
        display:block;
    }
</style>
...
<asp:BoundField DataField="WeekJudge" itemstyle-cssclass="hiddencol" />

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now