SELECT ROW_NUMBER() OVER (ORDER BY team_name ASC) AS ROWID, * from teams
where team_name like '%man utd%'

ROWID will give u the row number chilll ;) remember me in your prayers take care FEEAMANALLAH

AHSAN SARFRAZ UNIVERSITY OF ENGINEERING AND TECHNOLOGY TAXILA PAKISTAN COMPUTER SYSTEM ENGINEERING DEPARTEMENT

well u can use a session variable instead of request.city ... make a session variable and store the value of ur drop down in it on page load retrieve the value n then query the Database... Example make a session variable in global.asax Session["City"]=""; then store the value of dropdown in session i.e session["City=dropdownlist1.selectedvalue"]; then redirect to other url on page load string query="SELECT * FROM [ARS_Schedules] WHERE ([Origin_Place] = "+session["City"].ToString()+""; hope this will work for u... :) take care remember me in ur prayers FEEAMANALLAH

AHSAN SARFRAZ UNIVERSITY OF ENGINEERING AND TECHNOLOGY TAXILA PAKISTAN COMPUTER SYSTEM ENGINEERING DEPARTEMENT