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

Disable add new record in Grid

9 Answers 738 Views

Grid

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

9 Answers, 1 is accepted

Accepted

answered on 02 Feb 2009, 11:52 AM

Hi,

You can try out the following code to disable the AddNewRecord button based on the count of records returned from the database.
cs:

    
             protected void RadGrid1_PreRender(object sender, EventArgs e) 
        
                { 
        
                   foreach(GridCommandItem cmditm in RadGrid1.MasterTableView.GetItems(GridItemType.CommandItem)) 
        
                        { 
        
                            if (RadGrid1.Items.Count > 0) 
        
                            { 
        
                                Button btn1 = (Button)cmditm.FindControl("AddNewRecordButton"); 
        
                                btn1.Visible = false; 
        
                                LinkButton lnkbtn1 = (LinkButton)cmditm.FindControl("InitInsertButton"); 
        
                                lnkbtn1.Visible = false; 
        
                            } 
        
                        } 
        
                }

You can also pre-populate the fields in the InsertForm as shown below:
cs:

    
            protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) 
        
                {       
        
                   if (e.Item is GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted) 
        
                    { 
        
                        GridEditFormInsertItem insertItem =(GridEditFormInsertItem)e.Item; 
        
                        TextBox txtbx = (TextBox)insertItem["ColumnUniqueName"].Controls[0]; 
        
                        txtbx.Text = "Custom Text"; 
        
                    } 
        
                }

Thanks
Princy.

Accepted

answered on 03 Feb 2009, 05:08 AM

Hi,

You can try out the following code to populate your InsertForm fields based on FormView and Label values.
aspx:

    
            <asp:FormView ID="FormView1" DataSourceID="SqlDataSource1" runat="server"> 
        
                 <ItemTemplate> 
        
                      <asp:Label ID="Label1" runat="server" Text="LabelText"></asp:Label> 
        
                 </ItemTemplate> 
        
            </asp:FormView> 
        
            <asp:Label ID="Label2" runat="server" Text="CustomText"></asp:Label> 
        
             <telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource2" AutoGenerateColumns="true" runat="server" OnItemDataBound="RadGrid1_ItemDataBound" > 
        
                <MasterTableView CommandItemDisplay="Top" EditMode="EditForms" > 
        
                    ..... 
        
                </MasterTableView> 
        
             </telerik:RadGrid>

cs:

    
            protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) 
        
                { 
        
                    if (e.Item is GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted) 
        
                    { 
        
                        Label lbl = (Label)FormView1.FindControl("Label1");// Access the Label in the FormView 
        
                        GridEditFormInsertItem insertItem =(GridEditFormInsertItem)e.Item; 
        
                        TextBox txtbx1 = (TextBox)insertItem["Column1UniqueName"].Controls[0];// Access the textbox for column1 in the InsertForm 
        
                        txtbx1.Text = lbl.Text;// set the text for the textbox as the FormView label text 
        
                        TextBox txtbx2 = (TextBox)insertItem["Column2UniqueName"].Controls[0];// Access the textbox for column2 in the InsertForm 
        
                        txtbx2.Text = Label2.Text;// set the text for the textbox as the label text 
        
                    }         
        
                }

Thanks
Princy.

answered on 03 Feb 2009, 11:16 AM

Hi Panayiotis,

You can set the DataFormatString while creating the column.

CS:

    
            GridBoundColumn Col = new GridBoundColumn(); 
        
            RadGrid1.MasterTableView.Columns.Add(Col); 
        
            Col.HeaderText = "HeaderText"; 
        
            Col.UniqueName = "UniqueName"; 
        
            Col.DataField = "RequiredDate"; 
        
            Col.DataFormatString = "{0:dddd dd/MM/yy}";

It is possible to add ASP validation controls in edit and insert view. For this you can use FormTemplate edit form, Template Column or UserControl edit form. Checkout the link below.
Flexible server-side validation

Thanks,
Shinu.

answered on 03 Feb 2009, 12:17 PM

Hi there thanxs for the reply, i am using the following code at the

RadGrid1_ColumnCreated to format the columns:

    
            If TypeOf e.Column Is GridBoundColumn AndAlso TryCast(e.Column, GridBoundColumn).DataField = "ApplicationDate" Then 
        
                        TryCast(e.Column, GridBoundColumn).DataFormatString = "{0:dd/MM/yyyy}" 
        
                    End If

now i run into another required functionality. Is it possble to replace the autogenerated column types in the edit and insert mode to something else?
For instance instead of a textbox i would like a combobox that offers the user a list of available selections (bind to a datasource). If the edit mode is fired the combobox will display the value of the selected editable record and if a new record is added the combobox should prompt the user to select a value ex ("Please select status").

A more general question though, should i disable the autogenerated columns functionality and try to establish a form template or can
i succeed with the aforementioned functionality with code.? Any tutorials on form templates?

Thaxns for your patience :)

Accepted