Medium Blob in DataGrid ASP.net C#

Question

I am currently trying to display data from a table in a MySQL Database using a DataGrid component in ASP.net C#.

Its displaying all of the columns which are in int and varchar format but one column is a mediumblob format which contains only text.

I am binding the DataGrid to a DataSet from the MySQL table using the following

public void loadGrid(string query, GridView tblGrid)
    {
        using (DatabaseWork db = new DatabaseWork())
        {
            using (MySqlCommand cmd = new MySqlCommand(query, db.conn))
            {
                using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
                {

                    DataSet ds = new DataSet();
                    da.Fill(ds);
                    tblGrid.DataSource = ds.Tables[0];
                    tblGrid.DataBind();
                }

            }
        }

For some reason the Medium blob is never being shown and no exception is being thrown.

Thanks for any help you can offer.

Francis Gilbert · Accepted Answer · 2011-04-26 00:02:53Z

1

You'll need to process the BLOB first. For a bit of help, have a look here: http://dev.mysql.com/doc/refman/5.0/en/connector-net-programming-blob.html

answered Apr 26, 2011 at 0:02

Francis Gilbert

3,4522 gold badges24 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Boardy · Accepted Answer · 2011-04-26 15:46:03Z

0

@Francis Gilbert. Looking at the post I thought it would make more sense as I am only going to be storing text in the field is to the field TINYTEXT instead of TINYBLOB. Doing this fixes the datagrid.

answered Apr 26, 2011 at 15:46

Boardy

36.4k108 gold badges274 silver badges469 bronze badges

Collectives™ on Stack Overflow

Medium Blob in DataGrid ASP.net C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related