0

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..

5
Contributors
4
Replies
7
Views
5 Years
Discussion Span
Last Post by M.Waqas Aslam
0

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.

Edited by Netcode: n/a

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.