Allowing one column to be edited but not another

i have an asp.net c# application.

my gridview has a datasource that has 2 fields.

1 field cannot be edited by the user, but i need the other one to be editable!

is this possible to do?

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Set the ReadOnly="true" property on all that you don’t want editable.

Take a look at http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.readonly.aspx

A quick example from that page

<asp:gridview id="CustomersGridView" 
    datasourceid="CustomersSqlDataSource" 
    autogeneratecolumns="false"
    autogenerateeditbutton="true"
    allowpaging="true" 
    datakeynames="CustomerID"  
    runat="server">

    <columns>
      <asp:boundfield datafield="CustomerID" readonly="true" headertext="Customer ID"/>
      <asp:boundfield datafield="CompanyName" readonly="true" headertext="Customer Name"/>
      <asp:boundfield datafield="Address" headertext="Address"/>
      <asp:boundfield datafield="City" headertext="City"/>
      <asp:boundfield datafield="PostalCode" headertext="ZIP Code"/>
    </columns>
</asp:gridview>

In this case CustomerID and Company name are read only and can’t change. Address, City and PostalCode can be edited.

Just set the ReadOnly option to true on the columns you DON’T want people to edit. The columns that don’t have this set or have ReadOnly set to false are editable by the user when in edit mode.

Method 2

If you use a SqlDataSource then you should make sure to remove the columns to update from the UpdateCommand in the SqlDataSource if not you will have a problem when you update the fields

Method 3

You should be able to set ReadOnly on DataGridViewCell.

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcell.readonly.aspx

gridView.Rows[rowIndex][colName].ReadOnly = true;

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0