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

want to assign Default value in one of the column when new row inserted

6 Answers 295 Views

Grid

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

6 Answers, 1 is accepted

answered on 11 May 2009, 06:46 AM

Hi Syed,

You may try accessing the textbox in edit mode in the ItemDataBound event and assign the value to it from the label 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["ProductTitle_Hidden"].Controls[0]; 
        
                        txtbx.Text = Label1.Text; 
        
                    } 
        
                } 
        
             protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) 
        
                { 
        
                  //access the newly inserted value here 
        
                    GridEditFormInsertItem insertItem = (GridEditFormInsertItem)e.Item; 
        
                    TextBox txtbx = (TextBox)insertItem["ProductTitle_Hidden"].Controls[0]; 
        
                    string strxt = txtbx.Text; 
        
                }

Regards
Shinu

answered on 11 May 2009, 08:59 AM

I try it but nothing is updating/Inserting the Label text value in the hidden field. If i insert, in database i find null and edited nothing changes.

Please below is following code and aspx .

VB
----

    
            Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As GridItemEventArgs)  
        
                    If (TypeOf e.Item Is GridEditFormInsertItem) AndAlso (e.Item.OwnerTableView.IsItemInserted) Then  
        
                        Dim insertItem As GridEditFormInsertItem = DirectCast(e.Item, GridEditFormInsertItem)  
        
                        Dim txtbx As TextBox = DirectCast(insertItem("sname").Controls(0), TextBox)  
        
                        txtbx.Text = Label1.Text  
        
                    End If  
        
                End Sub  
        
                Protected Sub RadGrid1_InsertCommand(ByVal source As Object, ByVal e As GridCommandEventArgs)  
        
                    'access the newly inserted value here    
        
                    Dim insertItem As GridEditFormInsertItem = DirectCast(e.Item, GridEditFormInsertItem)  
        
                    Dim txtbx As TextBox = DirectCast(insertItem("sname").Controls(0), TextBox)  
        
                    Dim strxt As String = txtbx.Text  
        
                End Sub

ASPX

    
            <body> 
        
                <form id="form1" runat="server">  
        
                    <asp:ScriptManager ID="ScriptManager1" runat="server" /> 
        
                    <br /> 
        
                    <br /> 
        
                    <div> 
        
                        <asp:Label ID="Label1" runat="server" Text="Arshad"></asp:Label><br /> 
        
                        <br /> 
        
                        <br /> 
        
                        <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" 
        
                            AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateDeleteColumn="True" 
        
                            AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GridLines="None">  
        
                            <MasterTableView AutoGenerateColumns="False" CellSpacing="-1" CommandItemDisplay="Top" 
        
                                DataSourceID="SqlDataSource1">  
        
                                <RowIndicatorColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </RowIndicatorColumn> 
        
                                <ExpandCollapseColumn> 
        
                                    <HeaderStyle Width="20px" /> 
        
                                </ExpandCollapseColumn> 
        
                                <Columns> 
        
                                    <telerik:GridBoundColumn DataField="sno" DataType="System.Int32" HeaderText="sno" 
        
                                        SortExpression="sno" UniqueName="sno">  
        
                                    </telerik:GridBoundColumn> 
        
                                    <telerik:GridBoundColumn DataField="sname" Display="False" HeaderText="sname" ReadOnly="True" 
        
                                        SortExpression="sname" UniqueName="sname">  
        
                                    </telerik:GridBoundColumn> 
        
                                </Columns> 
        
                            </MasterTableView> 
        
                        </telerik:RadGrid><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" 
        
                            ConnectionString="<%$ ConnectionStrings:peoplesConnectionString %>" DeleteCommand="DELETE FROM [cares] WHERE [sno] = @original_sno AND (([sname] = @original_sname) OR ([sname] IS NULL AND @original_sname IS NULL))" 
        
                            InsertCommand="INSERT INTO [cares] ([sno], [sname]) VALUES (@sno, @sname)" OldValuesParameterFormatString="original_{0}" 
        
                            SelectCommand="SELECT [sno], [sname] FROM [cares]" UpdateCommand="UPDATE [cares] SET [sname] = @sname WHERE [sno] = @original_sno AND (([sname] = @original_sname) OR ([sname] IS NULL AND @original_sname IS NULL))">  
        
                            <DeleteParameters> 
        
                                <asp:Parameter Name="original_sno" Type="Int32" /> 
        
                                <asp:Parameter Name="original_sname" Type="String" /> 
        
                            </DeleteParameters> 
        
                            <UpdateParameters> 
        
                                <asp:Parameter Name="sname" Type="String" /> 
        
                                <asp:Parameter Name="original_sno" Type="Int32" /> 
        
                                <asp:Parameter Name="original_sname" Type="String" /> 
        
                            </UpdateParameters> 
        
                            <InsertParameters> 
        
                                <asp:Parameter Name="sno" Type="Int32" /> 
        
                                <asp:Parameter Name="sname" Type="String" /> 
        
                            </InsertParameters> 
        
                        </asp:SqlDataSource> 
        
                    </div> 
        
                </form> 
        
            </body>

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

want to assign Default value in one of the column when new row inserted

6 Answers, 1 is accepted