Real Time Data Grid Part 2/2 - The doDel JavaScript function
(Page 4 of 6 )
The doDel function works in exactly the same way as the doUpdate function, however it also confirms with the user that they really want to delete the selected record using the confirm function:
if(confirm("WARNING: You are about to delete this record for good."))
If the user agrees by clicking on the OK button, then a DELETE FROM query is built and sent to the SendRemoteRequest function:
strCriteria = eval("grid_"+recordId+"_0.name") + " = '" + ReplaceAllQuotes(eval("grid_"+recordId+"_0.value")) + "'";
strQuery = "DELETE FROM <%=m_TableName%> WHERE " + strCriteria;
blnSuccess = SendRemoteRequest(strQuery);Just like the doUpdate function, the status text of the browser window is also changed, telling the user that the record was deleted successfully:
The one main difference that the doDel function has over the doUpdate function is that is uses modifies the style property of the deleted record so that it is no longer displayed in the browser once it is deleted. This make the page look as if it has been refreshed when it really hasn't. We use the JavaScript eval function to hide the table for the deleted record like this:
eval("gridTable_"+recordId+".style.display='none'");That wraps up our look at the JavaScript and XMLHTTP code used to update our database without refreshing the page. Before we conclude this article, let's take a look at how we would actually go about using our DynamicGrid class.
Next: Using our DynamicGrid class >>
More ASP Articles
More By Annette Tennison
