i don't know what problem you are getiing.
First Correct your query I fyou want only selected week records..
"select weekly from table1 where weekly= dd1.selectedValue"
And if The check autoPostBack true property of the dropDown If on selected index control not going to this code.