College Project Need Help

Dudes, here I am posting my college project. Till now I made it ownself. And facing some difficulties as have not much knowledge in vb.net 2005. please help me.

now problem is. at backend I m using SQL Server 2005. And in my table I have 10 columns. And in my update page(in my project) I have 3 fields . before get confused just look at my update page from which I want to add book(s) in database before any distribution.

http://i53.tinypic.com/25iucsk.jpg

and my database table looks like this:

http://i56.tinypic.com/2ztm3js.jpg

and I just want when one books details posted on the database then I want only first three columns be filled with data. Because in my update field there are 3 criteria Index No, Book title and Author Name. and my 4th coulmn is "Issue Status". I want when I insert a new book in data base the "Issue Status" be filled with "False" or "N" and rest of the columns be filled with NA(Not Available) automatically.

please guys help me about it.

And I am here for help, and for creative conversation. because i ve no such knowledge like you guys.

how far have you got with the code?

GUI based coding is complete(as its damn easy)..its the first start when to insert data into database. and problem starts here(as i ve a little knowledge in it).


It will be better if you look at my project totally.

Hey,

You will find on this forum that people are more than willing to help you, but they are not just going to do the work for you, you have to show a little bit of willing first.

Have you got the SQL query that you would need to run against the database to perform each operation that you need, i.e. Delete, Update, Create and Read? This is the starting point for what you are doing. Get the queries working, and tested against your database, then you can start your code.

Depending on what you have been taught, this will either be directly talking to the database using a SqlConnection, and SqlCommand object, or doing something have data bound controls. What exactly have you been learning about in class, and what have you tried so far?

Gary

"libray" typo in the GUI

First thing i would do is set a auto inc. id for your books, then i would set default values for each column upon an insert.
This way when you insert only 3 fields, the reset will default to your specs. (You can set defaults in designer of SQL Management Studio)