I'm only updating int and string values...
Here's a snippet of my code:
[ASPX page]:
<asp:GridView ID="gridViewNew s" runat="server"
AutoGenerateCol umns="False" DataSourceID="O bjectDataSource 1"
DataKeyNames="c id,rid">
<Columns>
<asp:CommandFie ld ShowEditButton= "True" >
</asp:CommandFiel d>
<asp:BoundFie ld DataField="cid" HeaderText="CID " ReadOnly="True"
SortExpression= "cid" />
<asp:BoundFie ld DataField="rid" HeaderText="RID " ReadOnly="True"
SortExpression= "rid" />
<asp:BoundFie ld DataField="cont rolvocabulary"
HeaderText="The saurus" ReadOnly="False "
SortExpression= "controlvocabul ary" HtmlEncode="fal se" />
<asp:BoundFie ld DataField="titl e" HeaderText="Rx Title"
ReadOnly="True" SortExpression= "title" />
</Columns>
</asp:GridView>
<asp:ObjectData Source ID="ObjectDataS ource1" runat="server"
OldValuesParame terFormatString ="original_{ }"
SelectMethod="g etInvalidItemBy News" UpdateMethod="e ditNews"
TypeName="Rx">
<UpdateParamete rs>
<asp:Paramete r Name="original_ cid" Type="Int32" />
<asp:Paramete r Name="original_ rid" Type="Int32" />
<asp:Paramete r Name="controlvo cabulary" Type="String" />
</UpdateParameter s>
</asp:ObjectDataS ource>
[CLASS page with UPDATE method]:
public static void editNews(int original_cid, int original_rid, string
controlvocabula ry, string title) {
using (SqlConnection connection = new
SqlConnection(C onfigurationMan ager.Connection Strings["OFHC-RX_RxConnection String"].ConnectionStri ng))
{
using (SqlCommand command = new SqlCommand("lex _EditNews",
connection)) {
command.Command Type = CommandType.Sto redProcedure;
command.Paramet ers.Add("@conte ntid", SqlDbType.Int). Value =
original_cid;
command.Paramet ers.Add("@revis ionid", SqlDbType.Int). Value
= original_rid;
command.Paramet ers.Add("@contr oledvocabvalue" ,
SqlDbType.NVarC har, 1000).Value = controlvocabula ry;
int result = 0;
connection.Open ();
result = command.Execute NonQuery();
connection.Clos e();
}
}
}
