Inserting Data Issue

Question

0.00/5 (No votes)

See more:

Hi,
I have the product called book with many categories.I have created database with
1)BookDetails with bookid(pri.key),categoryid(frn.key),description
2)category with categoryid(pri.key),categoryname.

The problem is i have a book with multiple categories
how to store in the database using asp.net and c#?

Posted 31-Oct-11 3:02am

srinivas vadepally

Add a Solution

2 solutions

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)

Om Prakash Pant · Answer 1 · 2011-10-31T03:04:00

Solution 1

You have to store the category_id and bookid separetely. So the bookDetails table will contain information about book.
Since there is one to many mapping of book and category, create new table called BookCategories with bookid, categoryid as columns.

Posted 31-Oct-11 3:04am

Om Prakash Pant

Comments

srinivas vadepally 31-Oct-11 9:15am

hi prakash,
i have the category like tag in ask question of codeproject,the problem is how to extract categories and how to store in bookcategories table?

Bala Selvanayagam · Answer 2 · 2011-10-31T03:24:00

I belive, you are after many to many relation ship. in other words, a single book in your database can belongs to many categories and similarly a single category can be applicable to many books ?

tblbook
BookID (Primary Key)
BookName

tblCategory
CategoryID (Primary Key)
CategoryName

tblBook_Category
BookCategoryID (Primary Key)
BookID
CategoryID

You will have all your books in tblBook and the possible cateogies in tblcateogry and bind the books to the category in the third table tblbook_category