This is a migrated thread and some comments may be shown as answers.

Trouble getting text values for bulk edit

1 Answer 35 Views
Code Analysis
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Brian Riddle
Top achievements
Rank 1
Brian Riddle asked on 13 May 2010, 08:18 PM
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="">
                <Columns>
                  <telerik:GridBoundColumn DataField="ANTIGEN_ID" HeaderText="Antigen Batch #"
                        UniqueName="ANTIGEN_ID" ColumnEditorID="ANTIGEN_ID">
                    </telerik:GridBoundColumn>
                     <telerik:GridBoundColumn DataField="ANTIGEN_CODE" HeaderText="Antigen Code"
                        UniqueName="ANTIGEN_CODE" ColumnEditorID="ANTIGEN_CODE">
                    </telerik:GridBoundColumn>
                      <telerik:GridBoundColumn DataField="ANTIGEN_VIAL_ID" HeaderText="Antigen Vial #"
                        UniqueName="ANTIGEN_VIAL_ID" ColumnEditorID="ANTIGEN_VIAL_ID">
                    </telerik:GridBoundColumn>
                     <telerik:GridBoundColumn DataField="ANTIGEN_DEWAR" HeaderText="Dewar"
                        UniqueName="ANTIGEN_DEWAR" ColumnEditorID="ANTIGEN_DEWAR">
                    </telerik:GridBoundColumn>
                     <telerik:GridBoundColumn DataField="ANTIGEN_CANISTER" HeaderText="Canister"
                        UniqueName="ANTIGEN_CANISTER" ColumnEditorID="ANTIGEN_CANISTER">
                    </telerik:GridBoundColumn>
                     <telerik:GridBoundColumn DataField="ANTIGEN_CANE" HeaderText="Cane"
                        UniqueName="ANTIGEN_CANE" ColumnEditorID="ANTIGEN_CANE">
                    </telerik:GridBoundColumn>
                </Columns>
                 <CommandItemTemplate>
            <asp:Button runat="server" ID="UpdateAll" Text="Update Storage" CommandName="UpdateAll" />
       </CommandItemTemplate>
                </MasterTableView>
                </telerik:RadGrid>

 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")
            {
                SqlCmd.Connection.Open();
                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(newValues["ANTIGEN_DEWAR"]);
                    sb.Append("', ANTIGEN_CANISTER = '");
                    sb.Append(newValues["ANTIGEN_CANISTER"]);
                    sb.Append("', ANTIGEN_CANE = '");
                    sb.Append(newValues["ANTIGEN_CANE"]);
                    sb.Append("' WHERE ANTIGEN_VIAL_ID = '");
                    sb.Append(item["ANTIGEN_VIAL_ID"].Text);
                    sb.Append("'");
                    strSQL = sb.ToString();
                    SqlCmd.CommandText = strSQL;
                    SqlCmd.ExecuteNonQuery();
                }
                SqlCmd.Connection.Close();
            }
            rgAntigenLocations.Rebind();
        }


1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 19 May 2010, 07:16 AM
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
 
Greetings,
Martin
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.
Tags
Code Analysis
Asked by
Brian Riddle
Top achievements
Rank 1
Answers by
Martin
Telerik team
Share this question
or