Getting binary data using SqlDataReader

by

You should be able to get it via: (byte[])reader["Data"].

Also note that the image data type is deprecated, and will be removed in a future version of SQL Server; use varbinary(max) instead.

More Related Contents:

  1. MetadataException: Unable to load the specified metadata resource
  2. ADO.NET |DataDirectory| where is this documented?
  3. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  4. Get the generated SQL statement from a SqlCommand object?
  5. Get connection string from App.config
  6. Pass table valued parameter using ADO.NET
  7. Entity Framework with NOLOCK
  8. Can you get the column names from a SqlDataReader?
  9. Is it necessary to manually close and dispose of SqlDataReader?
  10. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  11. How to create a DataTable in C# and how to add rows?
  12. Handling ExecuteScalar() when no results are returned
  13. Calling Oracle stored procedure from C#?
  14. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  15. ado.net Closing Connection when using “using” statement
  16. How to run multiple SQL commands in a single SQL connection?
  17. How to pass a table-value parameter
  18. Creating a SQL Server table from a C# datatable
  19. How should I multiple insert multiple records?
  20. SQL: Update a row and returning a column value with 1 query
  21. How to keep single SQL Server connection instance open for multiple request in C#?
  22. Fill an array (or arraylist) from SqlDataReader
  23. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  24. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  25. What size do you use for varchar(MAX) in your parameter declaration?
  26. How do I extract data from a DataTable?
  27. Reading a date using DataReader
  28. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  29. How do I connect to a SQL database from C#?
  30. How can I Pass a Table Name to SqlCommand?

Leave a Comment