Hi Huzefa,

Have you set the UpdateCommand in the datasource? You need to add the UpdateCommand so that the Auto Footer Update can work. Here I attach a simple sample for you.

Hope it helps.

Regards,

Lili Khiung

Thanx for reply.

1. In my case i am using Bacth Update, so i think the UpdateRow event is not being called. So Now how to update?
2. I am also using following setting for my column. This mean that i have set the formating in my WebInput control and i am binding column to my control. Now in the footer i am seeing only 0 as Sum no matter what value is there in the Grid. I don't know what could be the problem?

   column.EditType = EditType.Custom;
                   column.CustomEditorName = "WebInputNET";
                   column.CustomEditorServerId = gridColumn.GridColumn.Name;

3. Is it necessary to supply the DataType for each column? What is the main use of supplying the DataType property?

Please help me with above mentioned issues.

Thanks,

Huzefa

Hi,

1. If you're using Batch Update the Automatic Update won't work because it has to AcceptAllChanges to do the update on the footer, so the update will work after you're klik the AcceptAllChanges button.

2. I don't really get your question here. Could you explain in more detail?

3. The DataType property is used to get or set the data type of the column.

Regards,

Lili Khiung

Hi Lili,

1) In my case i don't want user to click AcceptAllChanges button and wait till that time for the footer to get updated. Also in my form the user is not even allowed clicking the AcceptAllChanges button manually on the form. The AcceptAllChanges is taken care at server side at the submission of the form.

In this case, please tell how can i manually update the footer using some javascript, when the user changes the value in textbox. Though this should be handled by intersoft but i want to proceed with my work instead of getting stuck. I feel intersoft has not thought properly before adding any functionality. i have faced this situation at so many places.

2) What i mean here is that : I have enabled the footer for a grid and assigned the AggregationFunction to Sum. Now at the Page Load i have few records in the grid, but when the page is loaded i see 0 in the Footer while in the grid column there actually are values. Why it didn't calculate the Sum of existing record while loading?

One problem i see is that i have used a CustomEditor for this column. I am not sure, but is this making any problem?

3) Why i am asking for DataType is that i have not assigned DataType property on the Grid Columns, so is there any problem if i don't assgin this property?

Thanks,

Huzefa

Hi Huzefa,

1) I have attach the simple sample for you of how to manually update the footer using Javascript.

2) It should has nothing to do with the WebInput. In the sample I use the WebInput as the CustomEditor and it works just fine.

3) If you use the DataSource control, the DataType property will automatically follow the data type of the database if you don't assign it.

Hope it helps.

Regards,

Lili Khiung