add/Remove columns in grid using drag and drop with sqlDB [Resolved]

Posted by Manorama under ASP.NET on 4/3/2013 | Points: 10 | Views : 4620 | Status : [Member] | Replies : 14
Hi,
Below is my project requirment details. Kindly request you to suggest the best ways of implementing in ASP .NET.

Table columns are displayed in Treeview, with drag and drop, dynamically column can be added to the Grid along with data from DB. From grid, column can be removed using drag and drop.

Grid also should support reordering of columns, sorting and filtering.
if it is possible please let me know which grid i need to use...kindly help me

Thanks in advance for the support.

ManoRama


Responses

Posted by: Jayakumars on: 4/3/2013 [Member] [MVP] Bronze | Points: 50

Up
0
Down

Resolved
hi

using JQuery for this

refer this

http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/
http://datatables.net/forums/discussion/79/column-name-instead-of-index-for-sortingfiltering./p1

Mark as Answer if its helpful to you

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/3/2013 [Member] Starter | Points: 25

Up
0
Down
Thanks for your reply...i'll try it now

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/3/2013 [Member] Starter | Points: 25

Up
0
Down
Is there any free version of grids ?I tried for jqGrid,telerick radGrid,Kendo ui grid ...but i didn't get proper solution for my requirements

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/3/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

Jquery is drag and drop go to jquery urls

Mark as Answer if its helpful to you

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/3/2013 [Member] Starter | Points: 25

Up
0
Down
Thanks for reply........Currently i am using Data tables ......In that ,i am unable to get functionalities what ever i added like sorting,remapping columns for Dynamically added columns;Please guide me on this....

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/3/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
is it possible send me proper docs in my mail i will help u. Explain clearly.

Mark as Answer if its helpful to you

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/4/2013 [Member] Starter | Points: 25

Up
0
Down

Hi,
thanks for reply...
Below is my project requirment details. Kindly request you to suggest the best ways of implementing in ASP .NET.

Table columns are displayed in Treeview, with drag and drop, dynamically column can be added to the Grid along with data from DB. From grid, column can be removed using drag and drop.

Grid also should support reordering of columns, sorting and filtering.
if it is possible please let me know which grid i need to use...kindly help me

Thanks in advance for the support.
 Download source file

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/4/2013 [Member] Starter | Points: 25

Up
0
Down
hi all,
here I am using tree view and Data table 9.1. with drag and drop functionality;Once i drag a node from tree view to html table it has to be column ;it is working fine;In same way when i drag a column from data table and drop on to tree view column should be deleted;I done some code;here i am attaching ;Currently dragging is working for hard coded data..i already given 2-3 columns ;for those columns i can drag and drop total bunch;but when i am dragging newly added column Only column header is coming out of table;its not reflecting with column and related rows ;If am i need to add any pulg-ins please guide me how to do? or give the solution..suggest me ...

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/4/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
http://www.pedrera.com/blog/asp-net-listview-drag-and-drop-reordering-using-jquery/
http://www.foliotek.com/devblog/make-table-rows-sortable-using-jquery-ui-sortable/
http://aspsnippets.com/demos/321/



http://www.codeproject.com/Articles/21984/Drag-and-drop-GridView-items-for-ordering-in-ASP-N

Mark as Answer if its helpful to you

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/4/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
<script type='text/css'>
body {width:100%;}
</script>

Mark as Answer if its helpful to you

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/4/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
droppable stage visiblity hidden that table columns using JQuery.

Mark as Answer if its helpful to you

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/9/2013 [Member] Starter | Points: 25

Up
0
Down
hi...Thanks for Your Response,I am using Data Table 1.9;using this i achieved My goal 50%;I am able to add column dynamically and i can remove the column dynamically by drag and drop but it is working Only on existing Columns like col1,col2 etc but not for Dynamic columns(newly added like nth Column).. in this ..Once i added Dynamic columns for those i am unable to drag and drop ...If you guide me in this..I can reach my goal 100%;

Here is My Code......


Thanks in advance
 Download source file

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/10/2013 [Member] Starter | Points: 25

Up
0
Down
Is anybody their to help me

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manorama on: 4/15/2013 [Member] Starter | Points: 25

Up
0
Down
Unable to get the column Index for Data table 1.9;

here I am passing var aPos = oTable.fnGetPosition(this); position(Index) of dragged item to remove column from table;but i am getting Null value;kindly help me out of this problem;i am attaching the code of my requirement in Default.aspx Page
 Download source file

ManoRama

Manorama, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response