BLOB data to simple string in DataGridView? <p>I am using C# &amp; MYSQL to develop a desktop application. </p> <p>In one of my form I have a <code>DataGridView</code> (dgvBookings) and in my database table I have a table tblBookings which contains a field <code>specialization</code> of type <code>BLOB</code>.</p> <p>I am selecting data with following query,</p> <pre><code>SELECT * FROM tblBookings WHERE IsActive=1; </code></pre> <p>and then binding the data with DataGridView as,</p> <pre><code>dgvBookings.DataSource = ds.Tables["allbookings"]; </code></pre> <p>BUT after binding the data in gridview it shows <code>Byte[] Array</code> value for all rows of column <code>specialization</code> which is of BLOB type.</p> <p>How yo solve this problem, I want the data in String format, whatever is written in that column should be show as it is there in the grid.</p>