<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Delete row</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/delete-row/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on Delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row#p17101</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/delete-row#p17101</guid>
        	        	<description><![CDATA[<p>HEllo,</p>
<p>Before you delete the row you can use getRowData and store the deleted row in array or in other dom element putting that data somewhere</p>
<p>Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Wed, 12 May 2010 13:23:26 +0300</pubDate>
        </item>
        <item>
        	<title>sangee on Delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row#p17049</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/delete-row#p17049</guid>
        	        	<description><![CDATA[<p>In my case, I used user-defined-button and event as below.</p>
<p>But is&#39;s just get method type to delete.</p>
<p>Also I wish that&#160;when I delete multi-selected rows,&#160;the rows&#160;just not displayed in the grid but it exist in DOM just having delete-flag.</p>
</p>
<p>&#60;script src="js/jquery.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/jquery-ui-1.7.2.custom.min.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/jquery.layout.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/i18n/grid.locale-en.js" type="text/javascript"&#62;&#60;/script&#62;</p>
</p>
<p>&#60;script src="js/jquery.jqGrid.min.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/jquery.tablednd.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/jquery.contextmenu.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/ui.multiselect.js" type="text/javascript"&#62;&#60;/script&#62;</p>
<p>&#60;script src="js/grid.setcolumns.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/grid.celledit.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/grid.inlinedit.js" type="text/javascript"&#62;&#60;/script&#62;</p>
</p>
<p>&#160; ~~</p>
<p>&#160; ~~</p>
</p>
<p>&#160;&#160;.jqGrid(&#39;navButtonAdd&#39;,&#39;#pager&#39;,{caption:"Delete",<br />&#160;&#160;&#160;&#160;&#160; onClickButton:function(){<br />&#160;&#160;&#160;&#160;&#160; deleteGridRow();<br />&#160;&#160;&#160;}</p>
<p>&#160; ~~</p>
<p>&#160; ~~</p>
</p>
<p>function deleteGridRow(){</p>
<p>&#160;&#160;&#160; var rowID = returnRowID();<br />&#160;&#160;&#160; var colDomainID = jQuery(&#39;#list&#39;).jqGrid(&#39;getCol&#39;,&#39;domain_id&#39;,false)[rowID-1];&#160;<br />&#160; &#160;&#160;var colCodeGroup = jQuery(&#39;#list&#39;).jqGrid(&#39;getCol&#39;,&#39;code_group&#39;,false)[rowID-1];</p>
<p>&#160;&#160;&#160; var strURL = "source/common/get_code_header.asp";<br />&#160;&#160;&#160; strURL = strURL + "?domain_id=" + colDomainID;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; //domain_id and code_group&#160;is group-key<br />&#160;&#160;&#160; strURL = strURL + "&#38;code_group=" + colCodeGroup;</p>
<p>&#160;&#160;&#160; if( rowID != null ) jQuery("#list").jqGrid(&#39;delGridRow&#39;,rowID,{url:strURL,reloadAfterSubmit:false});<br />&#160;&#160;&#160; else alert("Please Select Row to delete!");</p>
<p>}</p>
</p>
<p>function returnRowID(){<br />&#160;&#160;&#160; &#160;var id = jQuery("#list").jqGrid(&#39;getGridParam&#39;,&#39;selrow&#39;);&#160;&#160;&#160;&#160;&#160;&#160;&#160; //get&#160;the selected rowid<br />&#160;&#160;&#160;&#160; if(id) <br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; return id;<br />&#160;&#160;&#160;&#160; else<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; return null;<br />}</p>
</p>
<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; Server(get_code_header.asp)&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-</p>
<p>&#39;//received param</p>
<p>&#160;m_strOperator = Trim(Request("oper"))&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#39;//default param by jqGrid<br />&#160;m_strID = Trim(Request("id"))&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#39;//default param by jqGrid<br />&#160;m_strDomainID = Trim(Request("domain_id"))&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &#39;//user-defined param<br />&#160;m_strCodeGroup = Trim(Request("code_group"))&#160;&#160;&#160;&#160; &#39;//user-defined param</p>
<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-</p>
<p>[explanation] "oper" param value: del, edit, add</p>
]]></description>
        	        	<pubDate>Tue, 11 May 2010 04:46:28 +0300</pubDate>
        </item>
        <item>
        	<title>varnold61 on Delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row#p17039</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/delete-row#p17039</guid>
        	        	<description><![CDATA[<p>I am very frustrated because I cannot get the delete to send the additional post data.&#160; Can anybody help ? i have tried using the onclicksubmit in the delete options as well as setting delData{tablename:"dummy"}&#160;</p>
</p>
<p>i cannot get either to work...&#160;&#160; the grid itself is working fine.</p>
<p>i have tried this:</p>
<p>}).navGrid(&#39;#pager&#39;,<br />{edit:false, search:false, view:true, add:true, del:true},<br />{editData:{tablename:"dummy"},reloadAfterSubmit:false}, // edit options<br />{editData:{tablename:"dummy"}, reloadAfterSubmit:true,closeAfterAdd:true}, // add options<br />{onclickSubmit : function(eparams) {</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160; return {additionalDataWhenDeleting:"I am additional data when deleting"};<br />}} // del options<br />);</p>
</p>
<p>and this :</p>
<p>}).navGrid(&#39;#pager&#39;,<br />{edit:false, search:false, view:true, add:true, del:true},<br />{editData:{tablename:"dummy"},reloadAfterSubmit:false}, // edit options<br />{editData:{tablename:"dummy"}, reloadAfterSubmit:true,closeAfterAdd:true}, // add options<br />{delData:{tablename:"dummy} }<br />);</p>
<p>i think the problem maybe with getting the correct includes, etc... for the css and javascript because i had it working at one time and am not sure what i changed.</p>
</p>
<p>I am including this :</p>
<p>&#60;link rel="stylesheet" type="text/css" media="screen" href="js/themes/basic/grid.css" /&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="js/themes/jqModal.css" /&#62;<br />&#60;script src="js/jquery-1.4.2.min.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/jquery.jqGrid.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/js/jqModal.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;script src="js/js/jqDnR.js" type="text/javascript"&#62;&#60;/script&#62;</p>
</p>
<p>my table id is "list" , the pager is "pager"</p>
</p>
<p>Thanks to anyone who can help.</p>
<p>Virginia</p>
]]></description>
        	        	<pubDate>Mon, 10 May 2010 22:00:37 +0300</pubDate>
        </item>
        <item>
        	<title>tony on Delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row#p10126</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/delete-row#p10126</guid>
        	        	<description><![CDATA[<p>Hello,</p>
<p>You can use delData parameter to set additional static data, or use onclickSubmit event to add dynamically parameters to the posted data.</p>
<p>Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Fri, 25 Sep 2009 04:38:49 +0300</pubDate>
        </item>
        <item>
        	<title>uruguay on Delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row#p10020</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/delete-row#p10020</guid>
        	        	<description><![CDATA[<p>hi,</p>
<p>When you load de table you can especify de id of the row like this,</p>
<p>$result = mysqli_query($link_identifier,$SQL) or die("Couldn t execute query.".mysqli_error($link_identifier));<br />&#160;&#160;&#160; $responce-&#62;page = $page;<br />&#160;&#160;&#160; $responce-&#62;total = $total_pages;<br />&#160;&#160;&#160; $responce-&#62;records = $count;<br />&#160;&#160;&#160; $i=0;<br />&#160;&#160;&#160; while($row = mysqli_fetch_array($result,MYSQL_ASSOC)) {<br />&#160;&#160;<span style="color: #00ff00;">&#160;&#160;&#160;&#160;&#160;<span style="color: #ff00ff;"> $responce-&#62;rows[$i][&#39;id&#39;]=$row[id];</span></span><br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $responce-&#62;rows[$i][&#39;cell&#39;]=array($row[nombre],$row[categoria],$row[stock]);<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $i++;<br />&#160;&#160;&#160; }</p>
<p>and then use it like this</p>
<p>"DELETE FROM table WHERE id=$_POST[id]"</p>
]]></description>
        	        	<pubDate>Tue, 22 Sep 2009 17:38:41 +0300</pubDate>
        </item>
        <item>
        	<title>vicman on Delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/delete-row#p10017</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/delete-row#p10017</guid>
        	        	<description><![CDATA[<p>How i can delete a row, in the delete.php page i only receive the id (position), but i need send another key (id in database)</p>
</p>
<p>thanks.</p>
]]></description>
        	        	<pubDate>Tue, 22 Sep 2009 16:41:34 +0300</pubDate>
        </item>
</channel>
</rss>