I used the Configure Data source wizard to bound my Grid. Now I want to make one column readonly when the Edit link is clicked. Not sure where I would set?
Code:asp:GridView ID="gv" runat="server" DataSourceID="SqlDataSource1" style="top: 630px; left: 21px; position: absolute; height: 133px; width: 861px" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" Font-Bold="False"> </asp:gridview> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT "SURPLUS_YR", "DIV", "SEQ_NO", "SURPLUS_TYPE", "DECAL_NO", "FIELD_DESC", "FIELD_MFGR", "FIELD_SERIAL_NO", "ITEM_CONDITION", "SURPLUS_REASON" FROM "SPAR_DECAL_ITEM" WHERE (("SURPLUS_YR" = :SURPLUS_YR) AND ("SEQ_NO" = :SEQ_NO) AND ("DIV" = :DIV))" DeleteCommand="DELETE FROM "SPAR_DECAL_ITEM" WHERE "SURPLUS_YR" = :SURPLUS_YR AND "DIV" = :DIV AND "SEQ_NO" = :SEQ_NO AND "SURPLUS_TYPE" = :SURPLUS_TYPE AND "DECAL_NO" = :DECAL_NO" InsertCommand="INSERT INTO "SPAR_DECAL_ITEM" ("SURPLUS_YR", "DIV", "SEQ_NO", "SURPLUS_TYPE", "DECAL_NO", "FIELD_DESC", "FIELD_MFGR", "FIELD_SERIAL_NO", "ITEM_CONDITION", "SURPLUS_REASON") VALUES (:SURPLUS_YR, :DIV, :SEQ_NO, :SURPLUS_TYPE, :DECAL_NO, :FIELD_DESC, :FIELD_MFGR, :FIELD_SERIAL_NO, :ITEM_CONDITION, :SURPLUS_REASON)" UpdateCommand="UPDATE "SPAR_DECAL_ITEM" SET "FIELD_DESC" = :FIELD_DESC, "FIELD_MFGR" = :FIELD_MFGR, "FIELD_SERIAL_NO" = :FIELD_SERIAL_NO, "ITEM_CONDITION" = :ITEM_CONDITION, "SURPLUS_REASON" = :SURPLUS_REASON WHERE "SURPLUS_YR" = :SURPLUS_YR AND "DIV" = :DIV AND "SEQ_NO" = :SEQ_NO AND "SURPLUS_TYPE" = :SURPLUS_TYPE AND "DECAL_NO" = :DECAL_NO"> <SelectParameters> <asp:ControlParameter ControlID="txtYr" Name="SURPLUS_YR" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="txtSeqNo" Name="SEQ_NO" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="txtDiv" Name="DIV" PropertyName="Text" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="SURPLUS_YR" Type="String" /> <asp:Parameter Name="DIV" Type="String" /> <asp:Parameter Name="SEQ_NO" Type="String" /> <asp:Parameter Name="SURPLUS_TYPE" Type="String" /> <asp:Parameter Name="DECAL_NO" Type="Decimal" /> </DeleteParameters> <UpdateParameters>




Reply With Quote