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

RadGrid KeyValues always empty

2 Answers 380 Views

Grid

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

Adam asked on 11 Jun 2008, 04:49 PM

My partner and I have been struggling for a long while with this problem. Based off of the code supplied by Telerik, I have two custom input forms for a RadGrid, one for inserts, one for edits. When the code gets to pulling the DataKeyValues from the grid of old values, the code always throws an ArgumentOutOfBoundsException and does not pick up any values. Seems like they're there before the update, then they disappear at update time.

Inserts work fine, but deleting and updating are breaking the same way.

Here's the source:

    
            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> 
        
            <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml">  
        
            <head runat="server">  
        
                <title>Untitled Page</title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server">  
        
                    <asp:ScriptManager ID="ScriptManager1" runat="server" /> 
        
                    <asp:UpdatePanel ID="UpdatePanel1" runat="server">  
        
                        <ContentTemplate> 
        
                            <asp:Panel ID="TitlePanel" runat="server" Height="23px" Width="825px" style="background-color:Black;color:GrayText; vertical-align:middle;font-size:10pt;font-family:Arial;">  
        
                                <asp:ImageButton ID="ImageButton1" ImageUrl="images/minussign.gif" runat="server" Height="20px" Width="25px" AccessKey="1" style="position:relative;top:2px;" /> 
        
                                <asp:Label ID="TitleLabel" runat="server" style="position:relative;top:-4px;"></asp:Label> 
        
                            </asp:Panel> 
        
                            <asp:Panel ID="ContentPanel" runat="server" style="background-color:Gray;width:825px;">                  
        
                                <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AutoGenerateEditColumn="True" GridLines="None" OnNeedDataSource="RadGrid1_NeedDataSource" OnDeleteCommand="RadGrid1_DeleteCommand" OnInsertCommand="RadGrid1_InsertCommand" OnItemCommand="RadGrid1_ItemCommand" OnUpdateCommand="RadGrid1_UpdateCommand" Width="825px" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True">  
        
                                    <MasterTableView CommandItemDisplay="Top">  
        
                                        <Columns> 
        
                                          <telerik:GridBoundColumn UniqueName="SID" HeaderText="SID" DataField="SID">                              
        
                                          </telerik:GridBoundColumn> 
        
                                          <telerik:GridBoundColumn UniqueName="Title" HeaderText="Title" DataField="TITLE">                              
        
                                          </telerik:GridBoundColumn> 
        
                                          <telerik:GridBoundColumn UniqueName="Name" HeaderText="Name" DataField="NAME">                              
        
                                          </telerik:GridBoundColumn> 
        
                                          <telerik:GridBoundColumn UniqueName="Product" HeaderText="Product" DataField="PRODUCT">                              
        
                                          </telerik:GridBoundColumn> 
        
                                          <telerik:GridBoundColumn UniqueName="SubmitDate" HeaderText="Submit Date" DataField="SUBMITDATE">                              
        
                                          </telerik:GridBoundColumn> 
        
                                          <telerik:GridBoundColumn UniqueName="Story" HeaderText="Story" DataField="STORY">                              
        
                                          </telerik:GridBoundColumn> 
        
                                        </Columns> 
        
                                        <RowIndicatorColumn Visible="False">  
        
                                            <HeaderStyle Width="20px" /> 
        
                                        </RowIndicatorColumn> 
        
                                        <ExpandCollapseColumn Resizable="False" Visible="False">  
        
                                            <HeaderStyle Width="20px" /> 
        
                                        </ExpandCollapseColumn> 
        
                                        <EditFormSettings EditFormType="WebUserControl" UserControlName="EditForm.ascx">  
        
                                            <PopUpSettings ScrollBars="None" /> 
        
                                        </EditFormSettings> 
        
                                    </MasterTableView> 
        
                                </telerik:RadGrid> 
        
                            </asp:Panel> 
        
                            <cc1:CollapsiblePanelExtender ID="CollapseEx" runat="server" CollapseControlID="TitlePanel" CollapsedImage="images/plussign.gif" ExpandControlID="TitlePanel" ExpandedImage="images/minussign.gif" TextLabelID="TitleLabel" TargetControlID="ContentPanel" ImageControlID="ImageButton1" CollapsedText="Click or press Alt-1 to expand<br />" ExpandedText="Click or press Alt-1 to collapse<br />">  
        
                            </cc1:CollapsiblePanelExtender> 
        
                        </ContentTemplate> 
        
                    </asp:UpdatePanel> 
        
                    <br /> 
        
                    &nbsp;  
        
                    <div> 
        
                    </div> 
        
                </form> 
        
            </body> 
        
            </html>

    
            using System;  
        
            using System.Data;  
        
            using System.Collections;  
        
            using System.Configuration;  
        
            using System.Web;  
        
            using System.Web.Security;  
        
            using System.Web.UI;  
        
            using System.Web.UI.WebControls;  
        
            using System.Web.UI.WebControls.WebParts;  
        
            using System.Web.UI.HtmlControls;  
        
            using System.Data.SqlClient;  
        
            using System.Data.OracleClient;  
        
            using Telerik.Web.UI;  
        
            public partial class _Default : System.Web.UI.Page   
        
            {  
        
                OracleConnection ociConn = new OracleConnection("Data Source=localhost;Persist Security Info=True;User ID=system;Password=testdb;Unicode=True");  
        
                protected void RadGrid1_PreRender(object sender, System.EventArgs e)  
        
                {  
        
                    if (!this.IsPostBack)  
        
                    {  
        
                        this.RadGrid1.MasterTableView.Items[1].Edit = true;  
        
                        this.RadGrid1.MasterTableView.Rebind();  
        
                    }  
        
                }  
        
                protected DataTable GetDataTable(string query) {  
        
                    ociConn.Open();  
        
                    OracleCommand cmd = new OracleCommand("Select SID, Title, Name, Product, SubmitDate, Story from Stories", ociConn);  
        
                    DataTable temp = new DataTable();  
        
                    OracleDataAdapter da = new OracleDataAdapter(cmd);  
        
                    try {  
        
                        da.Fill(temp);  
        
                    }  
        
                    finally {  
        
                        ociConn.Close();  
        
                    }  
        
                    return temp;  
        
                }  
        
                private DataTable Stories  
        
                {  
        
                    get 
        
                    {  
        
                        object obj = this.Session["Stories"];  
        
                        if ((!(obj == null)))  
        
                        {  
        
                            return ((DataTable)(obj));  
        
                        }  
        
                        DataTable myDataTable = new DataTable();  
        
                        myDataTable = GetDataTable("");  
        
                        this.Session["Stories"] = myDataTable;  
        
                        return myDataTable;  
        
                    }  
        
                }  
        
                protected void  Page_Load(object sender, EventArgs e)  
        
                {  
        
                }  
        
                protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)  
        
                {  
        
                    RadGrid1.DataSource = this.Stories;  
        
                }  
        
                protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)  
        
                {  
        
                    GridEditableItem editedItem = e.Item as GridEditableItem;  
        
                    UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);  
        
                    //Create new row in the DataSource          
        
                    DataRow newRow = this.Stories.NewRow();  
        
                    //Insert new values  
        
                    Hashtable newValues = new Hashtable();  
        
                    newValues["SID"] = Int32.Parse((userControl.FindControl("TextBox1") as TextBox).Text);  
        
                    //newValues["Region"] = (userControl.FindControl("TextBox3") as TextBox).Text;  
        
                    newValues["Title"] = (userControl.FindControl("TextBox2") as TextBox).Text;  
        
                    newValues["Name"] = (userControl.FindControl("TextBox3") as TextBox).Text;  
        
                    newValues["Product"] = "";  
        
                    newValues["SubmitDate"] = DateTime.Now;  
        
                    newValues["Story"] = "";  
        
                    //newValues["City"] = (userControl.FindControl("TextBox2") as TextBox).Text;  
        
                    //newValues["Region"] = (userControl.FindControl("TextBox3") as TextBox).Text;  
        
                    try 
        
                    {  
        
                        foreach (DictionaryEntry entry in newValues)  
        
                        {  
        
                            newRow[(string)entry.Key] = entry.Value;  
        
                        }  
        
                        this.Stories.Rows.Add(newRow);  
        
                        this.Stories.AcceptChanges();  
        
                    }  
        
                    catch (Exception ex)  
        
                    {  
        
                        RadGrid1.Controls.Add(new LiteralControl("Unable to update/insert Employees. Reason: " + ex.Message));  
        
                        e.Canceled = true;  
        
                    }  
        
                }  
        
                protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)  
        
                {  
        
                    GridEditableItem editedItem = e.Item as GridEditableItem;  
        
                    UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);  
        
                    //Prepare new row to add it in the DataSource  
        
                    DataRow[] changedRows = this.Stories.Select("SID = " + editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["SID"]);  
        
                    if (changedRows.Length != 1)  
        
                    {  
        
                        RadGrid1.Controls.Add(new LiteralControl("Unable to locate the Story for updating."));  
        
                        e.Canceled = true;  
        
                        return;  
        
                    }  
        
                    //Update new values  
        
                    Hashtable newValues = new Hashtable();  
        
                    newValues["SID"] = (userControl.FindControl("TextBox1") as TextBox).Text;  
        
                    newValues["Title"] = (userControl.FindControl("TextBox2") as TextBox).Text;  
        
                    newValues["Name"] = (userControl.FindControl("TextBox3") as TextBox).Text;  
        
                    newValues["Product"] = (userControl.FindControl("TextBox4") as TextBox).Text;  
        
                    newValues["SubmitDate"] = (userControl.FindControl("TextBox5") as TextBox).Text;  
        
                    newValues["Story"] = (userControl.FindControl("TextBox6") as DropDownList).Text;  
        
                    changedRows[0].BeginEdit();  
        
                    try 
        
                    {  
        
                        foreach (DictionaryEntry entry in newValues)  
        
                        {  
        
                            changedRows[0][(string)entry.Key] = entry.Value;  
        
                        }  
        
                        changedRows[0].EndEdit();  
        
                        this.Stories.AcceptChanges();  
        
                    }  
        
                    catch (Exception ex)  
        
                    {  
        
                        changedRows[0].CancelEdit();  
        
                        RadGrid1.Controls.Add(new LiteralControl("Unable to update Stories. Reason: " + ex.Message));  
        
                        e.Canceled = true;  
        
                    }  
        
                }  
        
                protected void RadGrid1_DeleteCommand(object source, GridCommandEventArgs e)  
        
                {  
        
                    string ID = (e.Item as GridDataItem).OwnerTableView.DataKeyValues[e.Item.ItemIndex]["SID"].ToString();  
        
                    DataTable employeeTable = this.Stories;  
        
                    if (employeeTable.Rows.Find(ID) != null)  
        
                    {  
        
                        employeeTable.Rows.Find(ID).Delete();  
        
                        employeeTable.AcceptChanges();  
        
                    }  
        
                }  
        
                protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)  
        
                {  
        
                    if (e.CommandName == RadGrid.InitInsertCommandName)  
        
                    {  
        
                        e.Canceled = true;  
        
                        RadGrid1.EditIndexes.Clear();  
        
                        e.Item.OwnerTableView.EditFormSettings.UserControlName = "AddForm.ascx";  
        
                        e.Item.OwnerTableView.InsertItem();  
        
                    }  
        
                    else if (e.CommandName == RadGrid.EditCommandName)  
        
                    {  
        
                        e.Item.OwnerTableView.IsItemInserted = false;  
        
                        e.Item.OwnerTableView.EditFormSettings.UserControlName = "EditForm.ascx";  
        
                    }  
        
                }  
        
            }

2 Answers, 1 is accepted

Accepted