Iam developing a small school software. I want to show fees of every student of whole year.
Like
John(student) I want show his fees that every month he paid at what date and how much.
So how should I start please help..

Recommended Answers

All 4 Replies

Start by telling us what you have done so far.

How do you intend to collect this data? That you be your start point. If you already have the data collected, then you would require knowledge on database connection and data retrieval.

You may wish to proceed and then show us some efforts. When you encounter issues, we can help.

i think u have to use a sql view , to get your required data .
then use this code to show ur all data in grid
take a binding source first

sub mydata()
dim mycon as new sqlconnection("connectionstring")
mycon.open()
dim dt as new datatable
dim da as new dataadapter("select * from __here write the name of ur view___",mycon)
dt.table("mytable").clear
da.fill(dt,"mytable")
bindingsource.datasource=dt.table("mytable")
datagridview.datasource = bindingsource
endsub

if u tell me about ur tables then i will try to make query for u ,
hope this will help u

Regards
M.Waqas Aslam

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.