Trouble getting text values for bulk edit

Thread is closed for posting
2 posts, 0 answers
  1. Brian Riddle
    Brian Riddle avatar
    2 posts
    Member since:
    May 2010

    Posted 13 May 2010 Link to this post

    I don't get an error, just blank or null values for the columns that are being edited.

      <telerik:RadGrid ID="rgAntigenLocations" runat="server" GridLines="None" AutoGenerateColumns="False" AllowMultiRowEdit="true" OnItemCommand="ItemCommand" OnItemDataBound="ItemDataBound" OnUpdateCommand="UpdateCommand" OnItemCreated="ItemCreated">
                      <MasterTableView Width="100%" CommandItemDisplay="TopAndBottom" DataKeyNames="ANTIGEN_VIAL_ID"
                    HorizontalAlign="NotSet" AutoGenerateColumns="False" CommandItemSettings-AddNewRecordText="">
                      <telerik:GridBoundColumn DataField="ANTIGEN_ID" HeaderText="Antigen Batch #"
                            UniqueName="ANTIGEN_ID" ColumnEditorID="ANTIGEN_ID">
                         <telerik:GridBoundColumn DataField="ANTIGEN_CODE" HeaderText="Antigen Code"
                            UniqueName="ANTIGEN_CODE" ColumnEditorID="ANTIGEN_CODE">
                          <telerik:GridBoundColumn DataField="ANTIGEN_VIAL_ID" HeaderText="Antigen Vial #"
                            UniqueName="ANTIGEN_VIAL_ID" ColumnEditorID="ANTIGEN_VIAL_ID">
                         <telerik:GridBoundColumn DataField="ANTIGEN_DEWAR" HeaderText="Dewar"
                            UniqueName="ANTIGEN_DEWAR" ColumnEditorID="ANTIGEN_DEWAR">
                         <telerik:GridBoundColumn DataField="ANTIGEN_CANISTER" HeaderText="Canister"
                            UniqueName="ANTIGEN_CANISTER" ColumnEditorID="ANTIGEN_CANISTER">
                         <telerik:GridBoundColumn DataField="ANTIGEN_CANE" HeaderText="Cane"
                            UniqueName="ANTIGEN_CANE" ColumnEditorID="ANTIGEN_CANE">
                <asp:Button runat="server" ID="UpdateAll" Text="Update Storage" CommandName="UpdateAll" />

     protected void ItemCommand(object source, GridCommandEventArgs e)
                string strSQL = "";
                SqlCommand SqlCmd = new SqlCommand();
                SqlCmd.Connection = DBConn.serologyDBConn();

                // Performing bulk update here.
                if (e.CommandName == "UpdateAll")
                    foreach (GridDataItem item in rgAntigenLocations.EditItems)
                        Hashtable newValues = new Hashtable();
                        e.Item.OwnerTableView.ExtractValuesFromItem(newValues, item);
                        StringBuilder sb = new StringBuilder();
                        sb.Append("UPDATE TBL_ANTIGEN_VIAL SET ANTIGEN_DEWAR = '");              
                        sb.Append("', ANTIGEN_CANISTER = '");
                        sb.Append("', ANTIGEN_CANE = '");
                        sb.Append("' WHERE ANTIGEN_VIAL_ID = '");
                        strSQL = sb.ToString();
                        SqlCmd.CommandText = strSQL;

  2. Martin
    Martin avatar
    823 posts

    Posted 19 May 2010 Link to this post

    Hello Brian Riddle,

    I have noticed that my colleague Tsvetoslav has already addressed the other thread that you have opened on the same topic. Here is a link to it:

    Can't get update text values
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top