Guest User

Untitled

a guest
Jun 22nd, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. if (myReader["Additional"] != null)
  2. {
  3. ltlAdditional.Text = "contains data";
  4. }
  5. else
  6. {
  7. ltlAdditional.Text = "is null";
  8. }
  9.  
  10. if (myReader["Additional"] != DBNull.Value)
  11. {
  12. ltlAdditional.Text = "contains data";
  13. }
  14. else
  15. {
  16. ltlAdditional.Text = "is null";
  17. }
  18.  
  19. SELECT ISNULL([Additional], -1) AS [Additional]
  20.  
  21. public static class DataReaderExtensions
  22. {
  23. public static bool IsDBNull( this IDataReader dataReader, string columnName )
  24. {
  25. return dataReader[columnName] == DBNull.Value;
  26. }
  27. }
  28.  
  29. DataTable dt = new DataTable();
  30. dt.Rows[0].Table.Columns.Contains("SampleColumn");
  31.  
  32. if (myReader.Read())
  33. {
  34.  
  35. ltlAdditional.Text = "Contains data";
  36. }
  37. else
  38. {
  39. ltlAdditional.Text = "Is null";
  40. }
Add Comment
Please, Sign In to add comment