Syncfusion Mvc Gridview with sticky columns

[XYZ]

Hi,

I am using syncfusion gridview in my MVC4 web applicaion.

so i want to implement 

1. Drag columns to reorder; make the order sticky
2. Resize columns, make width sticky
3. Change sorting by clicking column headings, make that sticky

I couldnt get any blogs in net to implement STICKY columns in web application.Its very urgent.Pls provide me the way to implement this.

Thanks..

[Abdul Matin M]

Hi XYZ,

 

Thanks for your interest in Syncfusion products.

 

Query #1: Drag columns to reorder; make the order sticky.

Your requirement to reorder can be achieved by setting the AllowDragAndDrop property to True.

 

Query #2: Resize columns, make width sticky.

Your requirement to resize the columns can be achieved by setting the AllowResizing property to True.

 

Query #3: Change sorting by clicking column heading, make that sticky.

Your requirement to enable sorting by clicking on column header can be achieved by giving the EnableSorting property.

 

In all the three queries you have specified for Sticky. We have understood Sticky as Frozen Rows and Columns and we have created a sample that includes all the above three queries. Please refer the below code snippet:

 

[CSHTML]

@(Html.Syncfusion().Grid<Sticky1.Models.Order>("StickyNote")

.Datasource(Model)

.EnablePaging()

.EnableSorting()

.EnableScrolling()

.AllowResizing(true)

.FrozenColumns(2)

.AutoFormat(Skins.Blueberry)

.FrozenRows(3)

.AllowDragAndDrop(true)

.Column(col=>

    {

        col.Add(p => p.OrderID).HeaderText("Order ID");

        col.Add(p => p.CustomerID).HeaderText("Customer ID");

        col.Add(p => p.ShipAddress).HeaderText("Address");

    })

.Scrolling(scroll=>scroll.Height(250))

)

 

If we have misunderstood your requirement please try this sample and get back to us with more information, so that we can analyze that and provide the better solution.

 

Let us know if you have queries.

 

Regards,

Abdul Matin M

Sticky1_1e11afb5.zip

[Ling Lin]

Hi,

Thanks a lot for the Response.

My Actual requirement is as follows.

We’ve been using Sync Fusion 11.2.0.25 MVC Grid  with PageOnDemand for one of our project requirement. We’ve below requirements to be implemented in our Grid. We did not find any information on Sync fusion MVC grid documentation over web for making columns sticky after applying below criteria’s for Grid. Please provide if there is any way to implement these additional functionalities -

 

1.       Column Re-Ordering : User can drag & drop (move) columns and this information (the order of columns) should be saved such that when next time user visits the same grid then the order of columns should be the same which he had selected previously (columns should be sticky).

 

2.       Column Grouping : User can group the columns by dragging the columns headers and this Grouping criteria need to be saved across user sessions when user Logs into the application for the next time. (sticky) 

 

3.       Column Sorting : User can sort any column by clicking on Column headers and this Sorting criteria need to be saved across user sessions when user Logs into the application for the next time. (Sticky)

 

4.       Column Filtering : User can filter any Column with filter conditions (Less than 10, Contains “Test” etc..) and this filter conditions need to be saved across user sessions when user Logs into the application for the next time. (Sticky)

5.       Hover Text:  User should be shown with tool tips when user mouse hovers on column headers.

All the above criteria’s should be saved somewhere and the saved user preferences should be applied to the Grid once user Logs in to application. Please let us know if there is any best way to achieve above functionalities.

 

We’ve found help related to Sticky implementation for “Sync Fusion Essential Grid Windows forms”. Please found below blog URL which we found over web.

 

-          http://www.syncfusion.com/support/forums/grid-windows/70525

Also, Can you please provide us a samle aplication to implement Grouping,Sorting and Filtering when we use Pageondemand with Grid.

The requirement is urgent.Can you please provide us the solution as soon as possible.

Thanks.

[Satheeskumar S]

Hi Ling Lin,

 

Thanks for your interest in Syncfusion products.

 

Query-1-Column Reordering, Grouping, Filtering, Sorting and Hover Text should be Sticky

We suggest you to achieve this requirement you just follow up the incident- 110233.

Query-2 Sorting and Filtering in OnDemandPaging

We suggest you to use our Online Sample and Online Documentation for EnableOnDemand. Please visit the below links.

Online Sample- http://mvc.syncfusion.com/demos/ui/grid/DataBinding/CustomBinding

Online documentation- http://help.syncfusion.com/ug/asp.net%20mvc/grid/default.htm#!documents/custombinding.htm

Query-3 Grouping in OnDemandPaging

We suspect that your reported issue as defect. So we suggest you to create a new incident using direct- trac account since we do not provide confidential information like patch in Forum.

 

 

Please let us know if you have any Other Concerns.

 

Regards,

Satheeskumar S

[Luka Lizatovic]

Hi,

thanks for the previous answers.

I have the same problem as Ling Lin and your solution is:

Query-1-Column Reordering, Grouping, Filtering, Sorting and Hover Text should be Sticky

We suggest you to achieve this requirement you just follow up the incident- 110233.

My question is where can I find Incident - 110233?

[Isuriya Rajan]

Hi Luka, 

 

We are sorry to inform that you cannot view that incident since it is created under Ling Lin account. We had created a separate incident under your Direct-trac account for your requested details. Please follow-up through that incident.  

 Log on to our support website to check for further updates. 

https://www.syncfusion.com/support/directtrac/incidents 

 

Regards, 

Isuriya R