if you have textbox in your edit column you can use dim col1 as textbox col1=E.Item.FindControl("txtCol1") where txtCol1 is the id of the textbox in your edititemtemplate. if you have dropdownlist, you can use Dim dpl As DropDownList dim dplValue as string dpl = E.Item.FindControl("dplPastduetime") dplValue= pstDuetime.SelectedItem.Value and in your query string you can use, strSQL = "update set name='" & col1 & "',time='" & dplValue & "'"........ etc