how to put different amount and weight for one product

Hi,
        In SQL you can't do exactly same. But you can save child table to maintain weight and price.
In Parent Table

ProductInfo
--------------

ProductId	ProductName
1	closeup
2	cinthol

in child table

ProductWeightInfo
-------------------

ProductId	UniqueId	Weight	Price
1	1	25KG	15
1	2	50KG	30

aaa

As of my knowledge you can't do it in sql server. but in front end you can show like this.

Doing so you will face some problem. In your above example, you don't have product name for two records. OK. 


Let us say you have two more records like:

product name	weight	price
Colgate	50 Kg	45
	100 Kg	80

Now you have 5 records in total. How do you differentiate the records that don't have a name (3 such exists now).