Guest User

Untitled

a guest
Jun 23rd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. AppendDataBoundItems="true"
  2.  
  3.  
  4. <asp:ListItem Text="" Value=""></asp:ListItem>
  5.  
  6. <UpdateParameters>
  7. <asp:Parameter Name="No_Empl_Ferme" Type="Int32" ConvertEmptyStringToNull="true" />
  8. </UpdateParameters>
  9.  
  10. protected void RequestItemFormView_ItemInserting(object sender, FormViewInsertEventArgs e)
  11. {
  12. for (int i = 0; i < e.Values.Count - 1; i++)
  13. {
  14. if (e.Values[i].ToString() == string.Empty)
  15. {
  16. e.Values[i] = null;
  17. }
  18. }
  19. }
  20.  
  21. <InsertParameters>
  22. <asp:Parameter Name="NullableFieldName" Type="Int32" ConvertEmptyStringToNull="true" />
  23. </InsertParameters>
  24.  
  25. protected void FormViewSettings_ItemUpdating(object sender, FormViewUpdateEventArgs e)
  26. {
  27. OrderedDictionary values = e.NewValues as OrderedDictionary;
  28.  
  29. var personID = values["PersonID"];
  30.  
  31. if (string.IsNullOrEmpty(personID.ToString()))
  32. {
  33. values.Remove("PersonID");
  34. values.Add("PersonID", null);
  35. }
  36. }
Add Comment
Please, Sign In to add comment