Edit + Update RadGrid

[A.mass]

Hello Telerik Team,

I'm using the manual binding way to bind my data [ not using controls, binding @ page-behind code ]

My question is, when the user clicks edit :
1 - How to get the selected row values [ cuz I want to get the text in that row and place it in the controls in the EditItemTemplate ]
2 - @Update click, how to get the values from these textboxes ?!

Please, Note that I read the documentation but its not helping since its using the SqlDataSource control.

Your hints are highly appreciated.
Best Regards,

[A.mass]

Any code sample or hints ?!

[prismcarlson]

Hello Abdulla,

If I understand correctly you are binding your data to the grid using the NeedDataSource event in the code behind. If this is the case then the code snippet below is how to get the datakey value of the affected row and an example of how to get the text entered into a textbox field of the affected row.

Protected Sub myGrid_UpdateCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles myGrid.UpdateCommand

        If TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode Then

            Dim item As GridEditableItem = CType(e.Item, GridEditableItem)

            Dim EDITEDTEXT As String = CType(item("myTextbox").Controls(0), TextBox).Text           

            Dim myUniqueID As Integer = CType(e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("uniqueID"), Integer)

           //SQL update statement goes here

        End If

    End Sub

[A.mass]

Hello chabian,

The way to get the Primary Key of the edited row is working fine, the problem that I'm facing that onEdit I want the value to be shown in the textboxes for the edited row.

My RadGrid do the following :
- Its getting the list of links depending on the user logged in.
- I'm using a telerik:GridHyperLinkColumn to display this with DataTextField="linkName" DataNavigateUrlFields="link".
- On Edit link clicked I want to get the text of that hyperlink to a textbox and the navigateUrl to another one.
- On Update, I want to update my DB.

in Visual Studio's gridview that would be really easy to accomplish.

My RadGrid code like the following :

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
    </telerik:RadScriptManager>
    <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
        AutoGenerateEditColumn="True" GridLines="None"
        AutoGenerateDeleteColumn="True">
<MasterTableView DataKeyNames="linkID">
<RowIndicatorColumn Visible="False">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn Visible="False" Resizable="False">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>

    <Columns>
        <telerik:GridHyperLinkColumn DataTextField="linkName" DataNavigateUrlFields="link" HeaderText="link"
            SortExpression="link" UniqueName="linkName">
        </telerik:GridHyperLinkColumn>
    </Columns>

<EditFormSettings>
<PopUpSettings ScrollBars="None"></PopUpSettings>
</EditFormSettings>
</MasterTableView>
    </telerik:RadGrid>

And the code-behind like the following :

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Telerik.Web.UI;
using System.Data.SqlClient;
using System.Configuration;

public partial class Default2 : System.Web.UI.Page
{
    private static String connStr = ConfigurationManager.ConnectionStrings["ConnectionString1"].ToString();
    private static SqlConnection conn = new SqlConnection(connStr);
    private static SqlCommand comm = new SqlCommand();
    private static DataSet ds;
    private static SqlDataAdapter adptr = new SqlDataAdapter();

    protected void Page_Load(object sender, EventArgs e)
    {
            Session["dtMyLinks"] = getLinks("test", "choosen");
            RadGrid1.DataSource = (DataTable)Session["dtMyLinks"];
            RadGrid1.DataBind();
    }

    public static DataTable getLinks(String employeeID, String linkType)
    {
        DataTable dt = new DataTable();
        comm = new SqlCommand();
        comm.Parameters.Clear();
        ds = new DataSet();

        comm.CommandType = CommandType.StoredProcedure;
        comm.CommandText = "GetLinks";
        comm.Connection = conn;
        comm.Parameters.AddWithValue("@employeeID", employeeID);
        comm.Parameters.AddWithValue("@linkType", linkType);

        adptr = new SqlDataAdapter(comm);
        adptr.Fill(ds);

        dt = ds.Tables[0];

        return dt;
    }
}

The stored procedure runs a script that returns list of links
select linkID, linkName, link, employeeID from links


A hint or sample would be appreciated.
Best Regards,

[A.mass]

I solved this.

Thank you.

[Michele]

Hello A.mass,
can you please tell me how you solved it??
I'm facing the same problem right now...
Thanks

Paolo

[Monalisa]

Hi,

I am also facing same problem. I use item template and in edit command I get the PK value of that rows. But I need that PK value in Page_Load. SO can anybody have any idea how to solve this.

Please reply soon its urgent.

Thanks,
Monalisa