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 : 7544 | Status : [Member] | Replies : 14

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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 Kumaraspcode2009@gmail.com Manorama, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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

0	hi Jquery is drag and drop go to jquery urls Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Manorama, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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 Kumaraspcode2009@gmail.com Manorama, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

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

0	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

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

0	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 Kumaraspcode2009@gmail.com Manorama, if this helps please login to Mark As Answer. \| Alert Moderator

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

Kumaraspcode2009@gmail.com

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

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

0	<script type='text/css'> body {width:100%;} </script> Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Manorama, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	hi droppable stage visiblity hidden that table columns using JQuery. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Manorama, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

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

0	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

0	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

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

Latest Posts