Save data in sqlserver using vb.net

Question

0.00/5 (No votes)

See more:

i have 3 tablese
table1 is tbl_members
table2 is tbl_library
table3 is tbl_borrowing

tbl_members hase this columns

idmebmer int autoincrement (primary key)
name varchar
adress varchar
tel varchar
email varchar

tbl_library hase this columns
idbook int autoincrement (primary key)
bookname varchar
bookauthor varchar
category varchar

tbl_borrowing hase this columns

idmebmer int autoincrement (primary key) 'this column is from foreign key from tbl_members '

idbook int autoincrement (foreign key) 'this column is from foreign key from tbl_library'

data_checkoutbook varchar ' the time where the user hase pickup the book from the library
data_retunbook varchar 'the time where the user must return the book to the library

i cane save data in table tbl_library and tbl_members but
how ken i save the date in tbl_borrowing for the user how has pick up a book
the user can only one book pick up

or how to i construk a database for a library menagment system

sorry for my english

Posted 2-Jan-13 3:11am

beniv

Add a Solution

Comments

WajihaAhmed 2-Jan-13 9:36am

Firstly, why you have auto-incremented the "idmebmer" and "idbook" in your "tbl_borrowing", any special reason?You just need an insert statement to acheive your goal.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-01-02T04:03:00

If the user can only borrow one book, then I would be tempted to incorporate the loan details into the user, but...
Your system won't work while you have the columns set to autoincrement - you can't directly set those fields as they are updated by SQL server itself - any attempt to insert or update those values will give you an exception. Since they are suppose to refer to the Member and the Book, You should remove the autoincrement from them.

Personally, I'm not fond of autoincrement values for specific item ids - I prefer to use Guids as they can be set by the VB/C# code when the row is created, rather than created by the SQL and then the value has to be found in order to apply any functions to it.