How to store multiple checkbox value in database

Question

0.00/5 (No votes)

See more:

Hi friends
I am developing a medical management project. In that I have following tables
Table 1) Components_details
fields: 1. Component_id ,2.Component_name ,3.Uses Of componenets
Table 2) Medicine_Details
fields: 1. Medicine_id ,2.Medicine_name,3.Uses of medicines
suppose I want to add many components for creating medicine, in that situation I need to select multiple components for single medicine with their percentage to make a medicine. how can i store combination details for single medicine.please help me.
thank you

Posted 8-Oct-12 19:15pm

baskaran chellasamy

Add a Solution

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)

VIPR@T · Answer 1 · 2012-10-08T19:30:00

Solution 1

Hi,

Do you know about Master detail table structure?
You can make one detail table with your Medicine_id. That table can be like this :

SQL

TableName : Medicine_Components_Details
1. MCDID(PK)
2. Medicine_id
3. Component_id

So here you can get all Components for 1 Medicine.
I hope this information help you.

Thanks,
Viprat

Posted 8-Oct-12 19:30pm

VIPR@T

Comments

tanweer 9-Oct-12 1:32am

good answer, 5+

VIPR@T 9-Oct-12 1:38am

Thanks :)

baskaran chellasamy 9-Oct-12 1:44am

thank you for your valuable suggetion. The table you are given is N:M relationship. Is it correct? what is my doubt is In application design I just given one medicine id and select multiple checkboxlist value for combination to store in this medicine-components-details.In that situation how can store value in database

VIPR@T 9-Oct-12 1:57am

Yes you can do this way. See Components_Details is your one Master table. Now when you create medicine you are using multiple components. So for that you can store the values in 2 different table. 1)Medicine_Details Which contains the medicine name. and the other table is 2)Medicine_Components_Details(Which i mentioned). Here you can save your medicine ID and component ID. So for any medicine contains with which Components, that details you will get from this table. I hope you can get the idea.

baskaran chellasamy 9-Oct-12 2:16am

Yes I got your idea. but please help me for the following situation.
as You mentioned.
The table format could be like this

MCID Medicine_id Componenets id
1 11 101
2 11 102
3 11 103
4 12 101
5 12 104
The situation is (in application design)
TextBox value for One medicine (11) and checkboxlist for components (101,102,103) . How can add same medicine value for single insertion for medicine table and multiple insertion for medicine_component table with many checkboxlist.

But In design

VIPR@T 9-Oct-12 2:29am

you have 2 different insert statement. 1st to insert data in Medicine_Details. Here you get the inserted row primary key using SCOPE_IDENTITY(). Tat value is medicine_ID. Then 2nd insert statement will be execute 2 times if 2 check box selected. 3 time if 3 check box checked. and save all that value in second table. Medicine_id will come from SCOPE_IDENTITY() will be same for that and checkbox checked value.

baskaran chellasamy 9-Oct-12 2:41am

Ok thanks i will do it and i will update this comment when i need your help.

VIPR@T 9-Oct-12 2:52am

ok..