Originally posted on Arnab's Blog:
Today we learn how to integrate jqgrid with codeigniter. At first, write a model in your application/model directory. The code is …. class JqgridSample extends CI_Model { function getAllData($start,$limit,$sidx,$sord,$where){     $this->db->select(‘id,name,email,passport,phone,fax,address’);     $this->db->limit($limit);     if($where != NULL)         $this->db->where($where,NULL,FALSE);     $this->db->order_by($sidx,$sord);  …

Originally posted on Arnab's Blog:
Hello all, Today we are going to learn how to write a stored procedure in sql server. The following code is a sample one. If you like it you can use this format for all stored procedure… SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO if exists(select * from…

Originally posted on Arnab's Blog:
Dear all, Today we are going to discuss about a different subject that is accounting which is necessary to know for developing an Accounting software, Point of sale, ERP, Banking solution etc. I divide this tutorial into some series for clearly understanding the accounting. First of all we have…

Originally posted on Arnab's Blog:
Hello all, Thanks for waiting for the finest part of accounting. Today we will see how transactions are stored for basic accounting. In the first part of this series we know that accounting basically lays on equation.. ↑ Asset = ↑ Equity + ↑ Liabilities That means if equity…

Originally posted on Arnab's Blog:
Hi all, Today we are going to learn about double entry system of accounting which means debit and credit. This is the toughest part of accounting. But, if you are confident about the earlier part of this series then this part is not so difficult. Now, we all know…

Originally posted on Arnab's Blog:
Dear all, Sometimes we need to copy the data from access db to sql server. For transferring data we can use openrowset command. For using openrowset you need the Ad Hoc Distributed Queries component turned on. But, by default this component is being turned off for the security of server. But you…