I don't fully understand what functionality you want to achieve,but based on your code,you can try this: SqlCommand cmd = new SqlCommand("Update [Law_Responses] SET (Calltaker=@Calltaker,Date=@Date,City=@City,County=@County,Address=@Address) where @Columname=@ID", con); cmd.Parameters.AddWithValue("@Calltaker", DropDownList1.SelectedValue); cmd.Parameters.AddWithValue("@Date", TextBox1.Text); cmd.Parameters.AddWithValue("@City", DropDownList9.SelectedValue); cmd.Parameters.AddWithValue("@County", DropDownList2.SelectedValue); cmd.Parameters.AddWithValue("@Address", TextBox3.Text); cmd.Parameters.AddWithValue("@Coumname",TextBox171.text); con.Close(); cmd.ExecuteNonQuery();