Hi, we are fixing a code where it uses datagrid.
We set at form load the data to display:
sSql= "select col1, col2, col3 from TableName"
dcRecs.ConnectionString = cnn
dcRecs.RecordSource = sSql
Works fine but we need to:
- add column header to each column
- format col3 as numeric 2 decimal value
- format col2 and col3 to be displayed as center
We have tried right-click on datagrid >> properties >> Columns but it only displays 2 columns. Also we got to increase adding the column in the designer by "Edit", but still can't seem to get in the Column tab the DataField or in the Format tab the numeric and right-align format.