Hi! I am a student of PGDCA. Please anybody help me for making a project of LIBRARY MANAGEMENT SYSTEM IN VB.NET 2005 VERSION. TODAY..........

Comments
We dont give answers to homework

you are student? fine! then do what the teacher tells you.
what the hell is this behave about? coming and asking for a complete project without showing any effort?
why you even study it then?

hii I am a student of tybsc (compsci) i m making a project on online health care please help me in my project i have to submit the synopsis

hi
i am developing a project in vb.net
i am having 2 databases student and university at access.
i have used wizard to connect to my databases.using wizard i can add,delete,update my databases easily.
my university databases is having listed attributes-id,name,courses,add,country.

now i want if i enter bba in my course column,then all universities providing bba course should be listed.

how should i do it?
i tried my level best but not successful.
plz help me out soon

hi,
i think university is a table not a database.
database contains table and you maintion a attributes.
change university table attributes aslike id,uniname,courses,uniadd,country

dim getid(10),i as integer
dim cs,qry as string
i=0
qry="select id from university"
commondobj.commandtext=qry
datareaderobj=cmd.executeReader
while(datareaderobj.read)
     getid(i)=datareaderobj("id")
     i++
end while
datareaderobj.close()
for i=0 to 9
   qry="select courses from university where id="&getid(i)
   commandobj.commandtext=qry
   datareaderobj=commandobj.ExecuteReader
   if datareaderobj.Read then
       cs=datareaderobj("courses")
   end if
   datareaderobj.close
   cs=cs+","+textbox.text(bba)
   qry="update university set courses='"& cs &"' where id="&getid(i)
   commandobj.commandtext=qry
   commandobj.ExcuteNonQuery()
   msgbox"done"
next

if done successfully then msg me on ...

Edited 6 Years Ago by __avd: Added [code] tags. For easy readability, always wrap programming code within posts in [code] (code blocks).

This article has been dead for over six months. Start a new discussion instead.