Load grid in edit mode

[Myriam]

Hello
I have a radgrid with many rows. I would like to be able to load the grid in edit mode but for each column. And horizontally if possible

Something like this

Smith	John	<input>
Smith	Johny	<input>
Rabbit	Roger	<input>
Mouse	Mickey	<input>

is this possible doing this with radgrid?
Thanks

[Princy]

Hello Myriam,

You can refer to the following document which explains on how to set the Grid in edit mode by default:
Default edit mode for grid items on initial load

Thanks
Princy.

[Myriam]

Hello Princy
First, Thanks a lot for your time. Your link is very useful!!

Another question is: it is possible to have the textbox in the same line of my fields ?? Like the tab I made in my other post?

 

Thank you again

[Myriam]

Oh and by the way, is it possible also to have only one button "update" for all rows that got something in the input box?
Thank you!
I LOVE Telerik and its forum!

[Princy]

Hello Myriam,

You can actually place an UpdateButton in the CommandItemTemplate of the grid and then perform batch update as explained in the following help document:
Performing batch updates

Thanks
Princy.

[Myriam]

Hello
Thank again Princy for your reply!
It is very very close from what I want! The only thing that doesn't work is that I can't get the values from my radgrid on the same line.
I need to insert into a new table but I need some lines values to do my insert. I can't even get the value of my input box.
Here is my code

Partial Public Class FEN_COMPETENCES_TRANSVERSALES
    Inherits System.Web.UI.Page
    Public fichiervbs As New fichiervb
    Public Conn As OleDbConnection = New OleDbConnection(fichiervbs.connectionCompTrans)
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            Dim dsLogin As New DataSet
            dsLogin = Session("sDsLogin")
            Me.SqlDsIntervenant.SelectParameters("ID_ECO").DefaultValue = dsLogin.Tables(0).Rows(0).Item("ID_ECO")
            Me.SqlDsIntervenant.SelectParameters("INTERV").DefaultValue = dsLogin.Tables(0).Rows(0).Item("NO_INTERV")
        End If
    End Sub

    Public Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGrid1.PreRender

        If Not IsPostBack Then
            For Each item As GridItem In RadGrid1.MasterTableView.Items
                If TypeOf item Is GridEditableItem Then
                    Dim editableItem As GridEditableItem = CType(item, GridDataItem)
                    editableItem.Edit = True
                End If
            Next
            RadGrid1.Rebind()
        End If

    End Sub

    Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs)
        If (e.CommandName = "UpdateAll") Then
            Dim intcpt As Integer
            intcpt = 0
            For Each editedItem As GridEditableItem In RadGrid1.EditItems

                Dim newValues As Hashtable = New Hashtable
                'The GridTableView will fill the values from all editable columns in the hash
                e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem)
                'SqlDsIntervenant.UpdateCommand = String.Format("Update Customers SET ContactName='{0}' WHERE CustomerID='{1}'", newValues("ContactName"), editedItem.GetDataKeyValue("CustomerID").ToString())
                               SqlDsIntervenant.InsertCommand = String.Format("INSERT INTO T_COMPTENCES_TRANVERSALES (FICHE, MAT, GRP, NO_INTERV, COMPTENCES, NOM, PRENOM) VALUES (" & newValues("Fiche") & ", '" & newValues("Mat") & "', '" & newValues("Grp") & "', '" & newValues("Interv") & "', '" & newValues("Comptence") & "','" & newValues("Nom") & "','" & newValues("Pnom") & "')")

                SqlDsIntervenant.Insert()
                editedItem.Edit = False
                intcpt = intcpt + 1
            Next
        End If
        RadGrid1.Rebind()
    End Sub
    Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs)
        If (TypeOf e.Item Is GridDataItem AndAlso e.Item.IsInEditMode) Then
            Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)
            'Hides the Update button for each edit form
            dataItem("EditCommandColumn").Controls(0).Visible = False
        End If
    End Sub


End Class

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="FEN_COMPETENCES_TRANSVERSALES.aspx.vb" Inherits="Competences_Transversales_Web.FEN_COMPETENCES_TRANSVERSALES" %>
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
      <title>Compétences transversales WEB</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDsIntervenant" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
            selectcommand="SELECT dbo_GPM_T_ECO.ID_ECO, dbo_GPM_T_INTERV.INTERV, dbo_GPM_T_INTERV.NOM AS INOM, dbo_GPM_T_INTERV.PNOM AS IPNOM, dbo_GPM_T_MAT_GRP.MAT,dbo_GPM_T_MAT.DESCR, dbo_GPM_E_MAT_ELE.FICHE, dbo_GPM_E_ELE.NOM, dbo_GPM_E_ELE.PNOM, dbo_GPM_T_ECO.ANNEE, T_COMPTENCES_TRANVERSALES.COMPTENCES, dbo_GPM_E_MAT_ELE.GRP FROM (((dbo_GPM_T_ECO INNER JOIN T_LOGIN_INTERV ON dbo_GPM_T_ECO.ID_ECO = T_LOGIN_INTERV.ID_ECO) INNER JOIN (((dbo_GPM_T_MAT_GRP INNER JOIN dbo_GPM_T_INTERV ON (dbo_GPM_T_MAT_GRP.INTERV = dbo_GPM_T_INTERV.INTERV) AND (dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_T_INTERV.ID_ECO)) INNER JOIN dbo_GPM_E_MAT_ELE ON (dbo_GPM_T_MAT_GRP.ID_MAT_GRP = dbo_GPM_E_MAT_ELE.ID_MAT_GRP) AND (dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_E_MAT_ELE.ID_ECO)) INNER JOIN dbo_GPM_E_ELE ON dbo_GPM_E_MAT_ELE.FICHE = dbo_GPM_E_ELE.FICHE) ON (T_LOGIN_INTERV.ID_ECO = dbo_GPM_T_INTERV.ID_ECO) AND (T_LOGIN_INTERV.NO_INTERV = dbo_GPM_T_INTERV.INTERV)) LEFT JOIN T_COMPTENCES_TRANVERSALES ON (dbo_GPM_E_MAT_ELE.FICHE = T_COMPTENCES_TRANVERSALES.FICHE) AND (dbo_GPM_E_MAT_ELE.GRP = T_COMPTENCES_TRANVERSALES.GRP) AND (dbo_GPM_E_MAT_ELE.MAT = T_COMPTENCES_TRANVERSALES.MAT)) INNER JOIN dbo_GPM_T_MAT ON (dbo_GPM_T_MAT_GRP.MAT = dbo_GPM_T_MAT.MAT) AND (dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_T_MAT.ID_ECO) WHERE (((dbo_GPM_T_ECO.ID_ECO)=?) AND ((dbo_GPM_T_INTERV.INTERV)=?) AND ((dbo_GPM_T_ECO.ANNEE)=2008))"
            <SelectParameters>
                <asp:Parameter Name="ID_ECO" Type="int32" />
                <asp:Parameter Name="INTERV" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>

        <asp:ScriptManager runat=server></asp:ScriptManager>

         <telerik:RadGrid
            ID="RadGrid1"
            runat="server"
            GridLines="None"
            AllowAutomaticUpdates=true
            AllowMultiRowEdit = "True"
            Skin="Web20"
            DataSourceID="SqlDsIntervenant"
            OnPreRender="RadGrid1_PreRender"
            OnItemCommand="RadGrid1_ItemCommand"
            OnItemDataBound="RadGrid1_ItemDataBound">

            <MasterTableView
               datasourceid="SqlDSIntervenant"
                HierarchyDefaultExpanded=true
                AllowAutomaticUpdates=true
                ExpandCollapseColumn-HeaderStyle-Width="5px"
                ExpandCollapseColumn-HeaderStyle-HorizontalAlign="Left"
                AutoGenerateColumns=false
                EditMode="InPlace"
                   CommandItemDisplay="TopAndBottom"
                >

                   <Columns>

                        <telerik:GridBoundColumn
                            DataField="INTERV"
                            UniqueName="INTERV"
                            HeaderText="Intervenant"
                            ReadOnly=true
                            Visible=false>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="MAT"
                            UniqueName="MAT"
                            HeaderText="Matière"
                            ReadOnly=true>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="DESCR"
                            UniqueName="DESCR"
                            HeaderText="Description"
                            ReadOnly=true>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="GRP"
                            UniqueName="GRP"
                            HeaderText="Groupe"
                            ReadOnly=true>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="FICHE"
                            UniqueName="FICHE"
                            HeaderText="Fiche"
                            ReadOnly=true
                            Visible=false>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="PNOM"
                            UniqueName="PNOM"
                            HeaderText="Prénom Élève"
                            ReadOnly=true>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="NOM"
                            UniqueName="NOM"
                            HeaderText="Nom Élève"
                            ReadOnly=true>
                        </telerik:GridBoundColumn>

                        <telerik:GridBoundColumn
                            DataField="COMPTENCES"
                            UniqueName="COMPTENCES"
                            HeaderText="Compétences">
                        </telerik:GridBoundColumn>
                         <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" />

                   </Columns>
                   <CommandItemTemplate>
                       <asp:Button runat="server" ID="UpdateAll" Text="Update All" CommandName="UpdateAll" />
                   </CommandItemTemplate>

            </MasterTableView>
        </telerik:RadGrid>

    </div>
    </form>
</body>
</html>

Can someone tell me what I am doing wrong?
Thank you