Guest User

Untitled

a guest
May 21st, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. try
  2. {
  3. tmp.OptionalField = reader["optionalfield"].ToString();
  4. }
  5. catch (IndexOutOfRangeException ex)
  6. {
  7. //do nothing
  8. }
  9.  
  10. List<string> myCols = new List<string>();
  11. DataTable schema = reader.GetSchemaTable();
  12. foreach (DataRow row in schema.Rows)
  13. {
  14. myCols.Add(row[schema.Columns["ColumnName"]]);
  15. }
  16.  
  17. public bool ColumnExists(IDataReader reader, string columnName)
  18. {
  19. for (int i = 0; i < reader.FieldCount; i++)
  20. {
  21. if (reader.GetName(i) == columnName)
  22. {
  23. return true;
  24. }
  25. }
  26.  
  27. return false;
  28. }
  29.  
  30. DataTable dataTable = new DataTable();
  31. dataTable.Load(reader);
  32. foreach (var item in dataTable.Rows)
  33. {
  34. bool columnExists = item.Table.Columns.Contains("ColumnName");
  35. }
  36.  
  37. private static bool ColumnExists(SqlDataReader reader, string columnName)
  38. {
  39. using (var schemaTable = reader.GetSchemaTable())
  40. {
  41. if (schemaTable != null)
  42. schemaTable.DefaultView.RowFilter = String.Format("ColumnName= '{0}'", columnName);
  43.  
  44. return schemaTable != null && (schemaTable.DefaultView.Count > 0);
  45. }
  46. }
Add Comment
Please, Sign In to add comment