DataGrid and GridProgressBarColumn

[Giovanni]

Hi,

in my  vb.net code I polpulated a datatable connecting to SQL server as following:

***************************************************

adapter = New SqlDataAdapter(MyQuery, SQLconn)

adapter.SelectCommand.CommandTimeout = 0

T_Data = New DataTable

adapter.Fill(T_Data)

***************************************************

Then I import this datatable into sfdatagrid in order to visualize it into new form temp:

Temp.SfDataGrid1.DataSource = T_Data 

Temp.ShowDialog()

A column of this datatable reports a percentage value:

∆_14g_Data UP Down

38.06

-0.79

4.27

-2.84

-11.9

-42.01

1.77

-28.78

-49.84

-22.51

33.52

My question is if I can modifying this column using GridProgressBar without adding new column (I wanna change Style) as reported in you example:

Me.sfDataGrid.Columns.Add(New GridProgressBarColumn() With {.MappingName = "SoftwareProficiency", .HeaderText = "Software Proficiency", .Maximum = 100, .Minimum = 0, .ValueMode = ProgressBarValueMode.Percentage})

Is it possible?

Thank in advanced

Gio

[Mohanram Anbukkarasu]

Hi Giovanni, 

Thanks for contacting Syncfusion support.  

We are little unclear with your requirement. However we suspect that you are asking whether it is possible to edit the values in progress bar column. As we mentioned in our help documentation GridProgressbarColumn display non-editable integer type values and it is not possible to edit the values. 

UG reference : https://help.syncfusion.com/windowsforms/datagrid/columntypes#gridprogressbarcolumn   

Please revert to us with more details if we have misunderstood your requirement.  

Regards, 

Mohanram a. 

[Giovanni]

Hi Mohanram,

thanks for your reply and I apologize for misunderstanding.

I just mean this:

I have a datatable that contains a column with name 'Result'

This column contains percentage values, i.e.:

6

36

26...

So when I bind this datatable in sfgridView1, I dont want to see only values 6,36,26,

but i would like to show column 'Result' like this:

https://ibb.co/4KZYYfK

I hope now I have been clearer,

BR,

Gio

[Mohanram Anbukkarasu]

Hi Giovanni, 

Thanks for the update.  

You can achieve this requirement by setting GridProgressBarColumn.ValueMode as ProgressBarValueMode.Percentage  as shown in the following code example.  

Code example :  

this.sfDataGrid1.Columns.Add(new GridProgressBarColumn() { MappingName = "Percentage",  Maximum = 100, Minimum = 0, ValueMode = ProgressBarValueMode.Percentage }); 

 

Sample link : https://www.syncfusion.com/downloads/support/forum/164750/ze/SfDataGrid_GridProgressBarColumn1008671421  

Please let us know if you require further assistance from us.  

Regards, 

Mohanram A. 

[Giovanni]

Hi Mohanram,

thanks for your support.

BR

gio

[Mohanram Anbukkarasu]

Hi Giovanni, 

Thanks for the update.  

Please let us know if you require further assistance from us. 

Regards, 

Mohanram A.