Click here to Skip to main content
15,614,257 members
Please Sign up or sign in to vote.
2.33/5 (3 votes)
See more:
How to make a Trial Balance in Asp.Net using C#?
I.explore.code 15-Oct-12 9:09am    
what do you mean "trial balance"?
Tejas Vaishnav 15-Oct-12 9:23am    
can you please complete your question with full details....

If you mean how to implement a trial version functionality in an ASP.NET web-app then this is one way of doing it:

1) Establish a maximum free usage count in your users table (if you have it otherwise create the table first) per user. It could be days, hours or minutes or anything.

2) Everytime a user logs in, check to see if the free usage is zero, if it is then log them out (optional) and redirect them to a payment page, otherwise, reduce the free usage count by one if the log on is on "x" days after the previous login (irrespective of whether the user has logged on from a different browser or refreshed the page or logging in from a different time zone or they log out and log back in on the same day etc).

You would have to take care of the fact that they don't get false negatives or false positives. For e.g. their free usage should not be reduced if they login from a different browser, or just refresh their page. Using days is probably the easier way to do it.

Let me know if this doesn't help you and I will remove this solution.
Share this answer
I was curious if the term "trial balance" is some hot term and I am stupid enough to not even heard about it.

Hence I used Google. Here is what wikipedia said "A trial balance is a list of all the General ledger accounts (both revenue and capital) contained in the ledger of a business."

Now, if you expect the CP community to be aware of such accounting word and then help you. I think you are expecting little to much.

Anyway, Same Google gave me link to one book "Develop your own Web Accounting Application using ASP.Net"[^]

Hope that helps. If it does mark it as answer/upvote.
Share this answer
I.explore.code 15-Oct-12 9:54am    
Excellent point! Looks like I tried to answer the wrong question! :) I am not taking a fall for this, i'd blame the OP for making me guess.
generally it should look like below

fetch data from sql, sum of Credit field & sum of Debit field group by LedgerId
and then sum(credit)-sum(debit) = balance if balance is (-) nagative then

in crystal report,

show that balance Debit side else in credit side,
and at last, in report footer display summary of Credit & Debit fields.

Note: As On Date : --- this report mostly need Date criteria ( filtration like... date should be Less than or equal to _______ date. so that in sql query also provide where condition for filtration of data using date.

Ledger Name         Credit       Debit
aaa                 200
snfjkds                          700
dslf                500
             Total  700          700

Happy Coding!
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900