|
SharpGrid is only able to bind to the ActiveX version of ADO recordsets (ADOc). DataSets are not supported in SharpGrid. So you must use either an unbound approach, or use one of SharpGrid's Virtual Modes. In using an Unbound approach, you have the ability to use Rows.Add to add each row of data to the grid, or you can use the Array object. When using the Array object you will see that the grid is actually a little faster due to the fact that it populates the actual underlying elements once the DataRowCount and DataColCount have been defined. The Virtual approach (preferred) is a bit more complex; however, it deals hand in hand with your underlying DataSet. This mode offers many different events that will fire each time your grid interacts with the user. Please see the attached zipped file for an example using SharpGrid's VirualEvents data mode to display records from a DataSet in real time.
|