asp.net 4.5 + sql product variations

Guest User

Hello everybody! Please help me to sort out how organize product variations with color and size at asp.net 4.5. What tables, give me derections how to do it. Thank you in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User8y ago
Thank you very much!!! It helps. Now I trying to display clicked at DataList's Imagebutton image in another Image1, do you have some ideas? I tryed add CommandName to ImageButton and to change img1.ImageUrl = "~/images" + e.CommandName ;
+1
Prakash Chasiya8y ago
Hello Ai Su;

To achive product variantions you need to create 3 tables as given below, It is just an example but you can modify it as your requirement.

Table1
create table tbl_prod
(
PID int not null primary key identity(1,1)
)
Table2
create table tbl_prodVariant
(
VID int not null primary key identity(1,1),
Vname varchar(50),
PID int
)
Table3
create table tbl_prodVariantValue
(
VVID int not null primary key identity(1,1),
VID int,
Vvalue varchar(50),
PID int
)
Hope this help.

Thanks
Prakash
+1