How to make gridControl like excel import data

[ahmad kamal bin abdul aziz]

i plan to do a grd like excel import data, open excel, then go to Data->Import external, when we clik on the cell border it will set grid boder to "Solid" and if we click again it will set the cell boder to "Not Set", can we do a grid control like that?

importData.zip

[Administrator]

Hi akamal,
you can change the Border style using BoundsIndicatorBorder property in the ResizingColumns Event. Here is the code snippet.

private void gridControl1_ResizingColumns(object sender, Syncfusion.Windows.Forms.Grid.GridResizingColumnsEventArgs e)
{
e.BoundsIndicatorBorder = new GridBorder(GridBorderStyle.Solid,Color.Black,GridBorderWeight.Thick);
e.SizeIndicatorBorder = new GridBorder(GridBorderStyle.Dashed, Color.Blue,GridBorderWeight.Thick);
}

Best Regards,
Madhan.

[ahmad kamal bin abdul aziz]

hi madhan,

thanks for the code snippet, it doesn''t work like i expected,

what i expect is...after resizing or clicking the col...the border is drawn and always show...but the code snippet just show the border during the resizing or when we point the mouse over the column only...

>Hi akamal,
> you can change the Border style using BoundsIndicatorBorder property in the ResizingColumns Event. Here is the code snippet.
>
>private void gridControl1_ResizingColumns(object sender, Syncfusion.Windows.Forms.Grid.GridResizingColumnsEventArgs e)
>{
>e.BoundsIndicatorBorder = new GridBorder(GridBorderStyle.Solid,Color.Black,GridBorderWeight.Thick);
>e.SizeIndicatorBorder = new GridBorder(GridBorderStyle.Dashed, Color.Blue,GridBorderWeight.Thick);
>}
>
>Best Regards,
>Madhan.

[stanleyj]

Hi Akamal,

This might work for you.

private void gridControl1_ResizingColumns(object sender, Syncfusion.Windows.Forms.Grid.GridResizingColumnsEventArgs e)
{
e.SizeIndicatorBorder = new GridBorder(GridBorderStyle.Dashed, Color.LightGray, GridBorderWeight.Medium);
e.BoundsIndicatorBorder = new GridBorder(GridBorderStyle.Solid, Color.Black,GridBorderWeight.Thick);

if(e.Reason == GridResizeCellsReason.MouseDown)
{
this.gridControl1.ColStyles[e.Columns.Left].Borders.Right = new GridBorder(GridBorderStyle.Solid, Color.Black,GridBorderWeight.Thick);
}

}

If you wish to cancel the Border drawn while double clicking then you may add this also.

if(e.Reason == GridResizeCellsReason.DoubleClick)
{
this.gridControl1.ColStyles[e.Columns.Left].Borders.Right = new GridBorder(GridBorderStyle.Dotted, SystemColors.ControlDark);
e.Cancel = true;
}

Best regards,
Stanley