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.



and my database table looks like this:



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.