private void processdisapproveAddress(DataRow dr) { string sql = "update pending_emplyee_address set [fld_name] = '~[fls_value]' where employee_number = [eeno]"; sql = sql.Replace("[fld_name]", dr["fld_name"].ToString()); sql = sql.Replace("[fls_value]", dr["Proposed"].ToString()); sql = sql.Replace("[eeno]", ViewState["EE_Number"].ToString()); SQLStatic.SQL.ExecScaler(sql); if (GetData().Rows.Count.Equals(0)) { Data.processes_profile_address(ViewState["EE_Number"].ToString(), ViewState["User_Name"].ToString()); drawEEGrid(); AutoSelect(); } DrawProfile(); }