Kendo UI Batch Editing Grid not posting back to SQL Server when saving changes

[Staci]

Hi There,

I have implemented a batch editing grid which populates correctly and allows me to edit rows, but when I hit "save changes" the changes are only saved in the grid, they're not being posted back to the database.

Can you please have a look at my code and let me know why this is not happening and how I can fix this. Attached is the files related to this control.

Many Thanks,
Staci

[Staci]

My post is not displaying correctly so I have re-added it here.

Hi There,

I have implemented a batch editing grid which populates correctly and allows me to edit rows, but when I hit "save changes" the changes are only saved in the grid, they're not being posted back to the database.

Can you please have a look at my code and let me know why this is not happening and how I can fix this. I Attached the files related to this control in the above post.

Many Thanks,
Staci

[Nikolay Rusev]

Hello Staci,

As far as I can see form your implementation this is expected. The items are only updated in the collection saved in the Session object.

//from MetricScoreRepository.cs

public static IList<MetricScoreModel> All()
{
            IList<MetricScoreModel> result = (IList<MetricScoreModel>)HttpContext.Current.Session["tbl_MetricScores"];

            if (result == null)
            {
                HttpContext.Current.Session["tbl_MetricScores"] = result =
                    (from metricScore in new FrontEndDBSQLDataContext().tbl_MetricScores
                     select new MetricScoreModel
                     {
                         MetricScoresID = metricScore.MetricScoresID,
                         //Date = (DateTime)metricScore.Date,
                         MetricName = (int)metricScore.MetricName,
                         MetricDescription = metricScore.MetricDescription,
                         CampaignName = (int)metricScore.CampaignName,
                         AffiliateName = (int)metricScore.AffiliateName,
                         MetricScore = (int)metricScore.MetricScore
                     }).ToList();
            }
            return result;
}

All the best,
Nikolay Rusev
the Telerik team

[Staci]

Thank's for the reply, I thought it also updated the table data in the database as the grid is populated from this table. Can you please tell me how I also update the data in the database as I need these changes to be saved there?

Many Thanks

[Nikolay Rusev]

Hello Staci,

How to submit those changes to the database depends entirely on the middle tier that you are using for communicating with the database.

 - in case of using Linq2Sql http://msdn.microsoft.com/en-us/library/bb399378.aspx
 - in case of using Entity Framework http://stackoverflow.com/questions/7811355/committing-changes-to-the-database-using-entity-framework


Regards,
Nikolay Rusev
the Telerik team

[Luis Ernesto]

hi, i have the same problem, can you have a little example how to implement the submit to changes the database?