Click here to Skip to main content
12,760,703 members (32,932 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-Server SQL-Server-2008 , +
Hi

I want to Store multiple values of some product like small , large , medium form admin side in database using drop down but i don't know how to store this

I Have two table

1. Item_Master
Item_ID
Item_Name
Size

2. Size_Master
Size (insert Large,small,medium etc)


Now how to add in Item Form that i have 3 size like medium ,large and small type item are available
Posted 25-Feb-13 7:17am
Updated 25-Feb-13 17:54pm
v2
Comments
BC @ CV 25-Feb-13 12:26pm
   
Its not that clear what you want to do. If you are wanting to store what sizes are availble for a specific product you can use two tables. One for products and one to store the sizes as shown below:

Products(
ProductID,
Name
)

Sizes(
SizeID,
ProductID,
SizeCode
)
Rahul Dhoble 25-Feb-13 12:33pm
   
Please add some examples in your question.
Member 9815058 25-Feb-13 22:51pm
   
yes you are right

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Sound's like you are looking for something like this: Multiselect Dropdown for Web Applications[^]
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.170217.1 | Last Updated 25 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100