I’ve got a question this morning about how to find a particular query in a huge list of stored procedure. It’s not that hard, what you need to do is to use SYS object and sys.procedures…
I tried to create an average in sql server by dividing two figures. Once I got the error of “Divide by zero error occured”, this is caused by dividing the figure by null value, to handle…
Sometimes when you display the data on the datagrid or gridview , you want to create some link. let’s say when you displaying your user detail data in the grid. you want the user to be…
Auto-attach to process ‘[2440] w3wp.exe’ on machine ‘…’ failed. Error code 0x8013134b. This problem is most likely occurred because I have two .NET framework installed in my PC (v1.14322 and v2.0). To fix this problem: •…
This post will explain how to iterate through datatable and how to get value based on index. //This function is used to iterate through datatable private void GetAllRows(DataSet ds){ // iterate through table in the DataSet…
This might be useful for web developer which wants to have one key event handler that compatible with all browsers. document.onkeyup = KeyCheck; function KeyCheck(e) { //this is used for cross browser var KeyID = (window.event)…
Sometime when we have Enum , we want to use it /bind it on the list as well with a better description/ word. With this method you can bind enum to a list which display its…
I need to create a payment gateway user control that will be used accross all of the modules. This user control should be as simple as doing the transaction ONLY. So what I need to do…