update radgrid in database

[esmyy]

Hello
I made a project like this demo here : http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/editmodes/defaultcs.aspx
I can edit/update/delete the rows, but it's only updating in the actual session, not in the sqldatabase.
What do I have to add to my code, so it's updating directly in my database?

Thanks for your help,
esmyy

[Tsvetoslav]

Hi,

Just rework the code in the UpdateCommand event handler of the grid to work directly with the data base. You can keep on using the SqlCommand approach - just pass it an update statement:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx 
 
Regards,
Tsvetoslav
the Telerik team

[Jayesh Goyani]

Hello,

protected void RadGrid1_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
        {
                           // existing code
                            try
                            {
                                DataRow[] changedRows = this.EmployeesData.Tables["Employees"].Select( "EmployeeID = " + editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["EmployeeID"] );
                                changedRows[0][column.UniqueName] = editorValue;
                                this.EmployeesData.Tables["Employees"].AcceptChanges();
                            }

// New code
try
{
   // perform your DB UPDATE operation
   Session["EmployeesData"] = null;
}
}

Thanks,
Jayesh Goyani

[esmyy]

First of all thanks for your reply, it was really fast :)

I have an additional question:
I read somewhere, that if you use 'recordset' or something with 'cursortype' you can edit/update the datatable easier.
Does somebody know how do do that with my excisting code, or do I have to change everything?

Thanks in advance,
esmyy

[esmyy]

Well, I changed almost my whole project, I'm using the EntityFramework now, according to this demo.
But now I have a little problem, in this demo the CustomerID is a string, what do I have to write in this lines, if my ID is an int?

var customerID = item.GetDataKeyValue("CustomerID").ToString();
Customers customer = DbContext.Customers.Where(p => p.CustomerID == customerID).FirstOrDefault();

Thanks,
esmyy

[Shinu]

Hello Esmyy,

Eventhough the DataType of the field is integer, you can access the DataKeyValue as shown below.
C#:

string customerID = item.GetDataKeyValue("CustomerID").ToString();

-Shinu.

[esmyy]

.. and what about the second line?
I doesn't work with a string and an integer.

Customers customer = DbContext.Customers.Where(p => p.CustomerID == customerID).FirstOrDefault();

[esmyy]

I solved the problem, thanks to everybody, who tried to help me!

Regards,
esmyy