Billing

Sriram Ramani

HI there, Anyone there?, now i need some thing very urgent please. I have created a school management application . When some one comes for paying the fee ,after the pay the fee i need to generate a bill which holds info regarding the student's name , address , and all details . Please i dont know how to do. Anybody please help me. Very urgent. Thanks in advance

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

naura pax17y ago
I have already given you the solution see my second post in this thread and
PLEASE TRY IT AT LEAST ONCE before you give further comments.
Thanks
Sriram Ramani17y ago
ok . Can u give me a solution now how do do. I have succeeded in connecting with database and all those except this report thing. PLease let me know how to . /. . . .?
naura pax17y ago
Man,
you've got start from the beginning, learn how to make connection with MS Access, i think you won't stored procedures i don't know about access, maybe you'd use queries, but in any case start working on basics there are plenty of articles available on the net for free.
My suggestion is you break down the application into smaller problems and start working on them one by one.
Talking about what you said above- yes it is possible but no can make you understand until you start working on it.
Sriram Ramani17y ago
SOrry i do not know abt this typed dataset. Here is my situation. I have created a window based application with Access as the database there are 7 tables in it. I have created a deployment project in which i have included all the files (.exe .mdb). Now when i install the application in the client's m/c this database and the exe files gets copied to somewhere as per thee user's wish during install(installing location).. Let us consider the file has (i mean the dbs file , the mdb file)been copied to c:\application. when i print a report in the application it has to fetch the dbs directly from this location. Will i be able to achieve this if i do so as u said????
naura pax17y ago
What are you talking about, which database file. Typed DataSet is a static structure unlike dataset. but it is pretty much a c# class it will be a part of your exe you don't have to ship anything with it.
This dataset will get filled based on your stored procedure which gets fired based on connectionstring... no?? so what extra file are you talking about?
Sriram Ramani17y ago
Hi maggogg, Doing so is like adding the dbs file manually to the project know (chosing the database file from the location), but when i deploy the application the source or the dbs file wont be there in that location. What to do in that case?...
naura pax17y ago
Working with crystal reports is easy.
You add Typed DataSet (from right click project-> add new file) in your project.
Create a table structure in it (by opening dataset file in design mode and right clicking).
Add a method in the code behind for dataset that calls your stored procedure
and add tables in your typed set -
DataSet ds=GetData() // your business logic.
TypeDataSet1.Merge(ds.Tables[0]);
and add this type dataset as datasource in your crystal report.
Make sure column name in type dataset and stored procedure select query match exactly (case sensitive).
Sriram Ramani17y ago
Hi maggog, I tried in that , did u see my previous post "Crystal Reports"? . . .I still have problems with crystal reports. Please help me. I was having problem with that ds.tables().. . .it says "no table in the report". Please help me as soon as possible.
naura pax17y ago
hi,
you can easily do that using crystal report, you can provide a form for selecting (combobox) student name, date (or month) and button on which's click event you can generate a crystal report.
You can set report's printer settings (width, height, landscape etc ) by looking at actual school bills or you can ask client for format.
hope that helps.