954,514 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

SQL Server, VB.net

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

Rajoo Mal
Newbie Poster
1 post since Dec 2011
Reputation Points: 10
Solved Threads: 0
 
kingsonprisonic
Posting Whiz in Training
265 posts since Nov 2009
Reputation Points: 47
Solved Threads: 53
 

Start by telling us what you have done so far.

Reverend Jim
Posting Shark
Moderator
1,167 posts since Aug 2010
Reputation Points: 253
Solved Threads: 159
 

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.

Netcode
Veteran Poster
1,021 posts since Jun 2009
Reputation Points: 43
Solved Threads: 67
 

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

waqasaslammmeo
Posting Pro in Training
472 posts since Aug 2011
Reputation Points: 38
Solved Threads: 82
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: