hi,
If you use Update Query then used Update Method.
query = "UPDATE Modality_Master SET Modality='"+mdlist+"', Scheduled_Station_AE_Title='"+schaetitle+"',SCHEDULED_STATION_NAME='"+schaename+"' WHERE Modality_ID='"+ModalityID+"'";
da = new SqlDataAdapter(query, con);
ds = new DataSet();
da.Update(ds);