I have problems in displaying data on TDBGrid. I have connected the ADOconnection and link the data source to ADOtable. However there is no data displayed on the TDBGrid. Anyone knows why?


I have problems in displaying data on TDBGrid. I have connected the ADOconnection and link the data source to ADOtable. However there is no data displayed on the TDBGrid. Anyone knows why?

Thank you.

Comments

  1. Richard Baroniunas yes i already did

    ReplyDelete
  2. ADOconnection active and DBGrid active should show the data AT DESIGN TIME !! unless you did not choose the right driver.
    what kind of Database is it ?
    Did you initialize connect string (at design time) ?
    Did you test (at design time) connection ? there is a button for that.

    ReplyDelete
  3. it seems that all the fields are mapped to Blobs (or the database uses only blobs)

    ReplyDelete
  4. Paul TOTH never thought about it.You are right i guess.
    But pressing the test button on connect string will verify connection.

    ReplyDelete
  5. The TDBGrid will show all fieldtypes that are ftMemo, ftBlob et. al like in your attached picture. Loong time since i used TDBGrid but i remember threr is something to be done. Google it! The screenshot definitely confirms that the connection is alive and active.

    ReplyDelete
  6. That is changed some versions ago. Look at TBlobField.DisplayValue. It is by default dvClass. TBlobDisplayValue = (dvClass, dvFull, dvClip, dvFit)

    ReplyDelete

Post a Comment