SQL DataGrid Questions

You can do the following either from the Graphic Editor or from a Client Script.

1. Override the following custom properties defined in the SQLDataGridUserCrtl and set them to True. This will help hiding the controls on the UI.

ComboBoxPanelHide_dg = True
ButtonPanelHide_dg = True

2. Override the following custom properties to overwrite the connection properties. Some of them may not apply depending on the Authentication mode.

Authentication_dg
ConfiguredServer_dg
ConfiguredDatabase_dg
ConfiguredDomain_dg
ConfiguredUser_dg
ConfiguredPassword_dg

3. Overwrite the following custom properties to specify the SQL command and retrieve the data.

SQLQuery_dg
CmdRetrieve_dg

4. Specify the following customer properties to auto refresh data.

AutoRefresh_dg
AutoRefreshDuration_dg

Alternative: There are also corresponding properties on the control that can be set from a script.

You can do the following either from the Graphic Editor or from a Client Script.

1. Override the following custom properties defined in the SQLDataGridUserCrtl and set them to True. This will help hiding the controls on the UI.

ComboBoxPanelHide_dg = True
ButtonPanelHide_dg = True

2. Override the following custom properties to overwrite the connection properties. Some of them may not apply depending on the Authentication mode.

Authentication_dg
ConfiguredServer_dg
ConfiguredDatabase_dg
ConfiguredDomain_dg
ConfiguredUser_dg
ConfiguredPassword_dg

3. Overwrite the following custom properties to specify the SQL command and retrieve the data.

SQLQuery_dg
CmdRetrieve_dg

4. Specify the following customer properties to auto refresh data.

AutoRefresh_dg
AutoRefreshDuration_dg

Alternative: There are also corresponding properties on the control that can be set from a script.