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

Editing Radgrid

5 Answers 103 Views

Grid

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

5 Answers, 1 is accepted

answered on 01 Feb 2011, 12:54 PM

Hello Arnaud,

I assume that you are binding the grid in PageLoad event, which is Simple data binding technique. If you are using any advanced feature in grid(like insert/update/delete), then a better approach is using "AdvancedData binding" using NeedDataSource event.
For more information about this can be available here.
Advanced Data-binding (using NeedDataSource event)

Here is the sample code that I tried in my application for manual update operation.
ASPX:

<telerik:RadGrid ID="RadGrid1" AutoGenerateColumns="False" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"

OnUpdateCommand="RadGrid1_UpdateCommand">

<MasterTableView CommandItemDisplay="Top" DataKeyNames="EmployeeID">

<Columns>

<telerik:GridTemplateColumn>

<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%#Eval("FirstName") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="TextBox1" runat="server" Text='<%#Bind("FirstName") %>'></asp:TextBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn>

<ItemTemplate>

<asp:LinkButton ID="btnEdit" runat="server" CommandName="Edit">Edit</asp:LinkButton>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

C#:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

//populate RadGrid

}

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)

{

GridEditFormItem editItem = (GridEditFormItem)e.Item;

TextBox txtname = (TextBox)editItem.FindControl("TextBox1");

int id =Convert.ToInt32(editItem.GetDataKeyValue("EmployeeID"));

SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);

SqlCommand cmd = new SqlCommand("Update Employees set FirstName=@FirstName where EmployeeID=@EmployeeID ", con);

cmd.Parameters.Add(new SqlParameter("@EmployeeID", id ));

cmd.Parameters.Add(new SqlParameter("@FirstName", txtname.Text));

con.Open();

cmd.ExecuteNonQuery();

con.Close();

RadGrid1.Rebind();

}

Could you please paste the complete code if it doesn't help?

Thanks,
Princy.

answered on 01 Feb 2011, 05:46 PM

Hey Princy.
the problematic grid is bound via "NeedDatasource" event.
I'm loosing hope about being able to manually update a grid that is manually bound.

I added a 3rd grid which is bound automatically via an SQL data source. for that one, the update event fires but the template controls that are for the update are not accessed. here is my code below for the update command

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

Try

Dim the_edited_row As GridEditFormItem = CType(e.Item, GridEditFormItem)

Dim theMailMessage As MailMessage = New MailMessage("someone@something.com", "someone@something.com", "Working", "Working")

Dim theClient As SmtpClient = New SmtpClient(ConfigurationManager.AppSettings("SMTPServer").ToString)

theClient.Send(theMailMessage)

Catch

Dim theMailMessage As MailMessage = New MailMessage("someone@something.com", "someone@something.com", "Not Working", "Not Working")

Dim theClient As SmtpClient = New SmtpClient(ConfigurationManager.AppSettings("SMTPServer").ToString)

theClient.Send(theMailMessage)

End Try

End sub

I always receive the "Not Working" mail which means that the edit form is not casted. why would that be?