How to export Gridview data to Excel using devexpress XtraGrid

November 28, 2015

To export Gridview data to Excel using devexpress XtraGrid have a look at the sample below.

Samples

C# Sample

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using DevExpress.XtraGrid.Columns;

namespace de.Fesslersoft.ExportXtraGridToExcel
{
    public partial class ExportForm : Form
    {
        private DataTable _dataTable;

        public ExportForm()
        {
            InitializeComponent();
        }
        
        private void ExportForm_Load(object sender, EventArgs e)
        {
            FillDataTable();
            gridViewExport.OptionsBehavior.AutoPopulateColumns = true;
            gridViewExport.OptionsBehavior.ReadOnly = true;
            gridViewExport.OptionsBehavior.Editable = false;
            gridControlExport.DataSource = _dataTable;
        }

        private void FillDataTable()
        {
            //https://documentation.devexpress.com/#WindowsForms/CustomDocument2240
            SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder
            {
                DataSource = "localhost",
                IntegratedSecurity = true,
                InitialCatalog = "Northwind"
            };
            using (SqlConnection connection = new SqlConnection(connectionStringBuilder.ToString()))
            {
                connection.Open();
                string queryCommand = "SELECT TOP 100 [ProductID],[ProductName],[SupplierID],[CategoryID],[QuantityPerUnit],[UnitPrice],[UnitsInStock],[UnitsOnOrder],[ReorderLevel],[Discontinued] FROM [Northwind].[dbo].[Products]";
                using (SqlDataAdapter adapter = new SqlDataAdapter(queryCommand, connection))
                {
                    _dataTable = new DataTable();
                    adapter.Fill(_dataTable);
                }
            }
        }

        private void ExportToExcel()
        {
            //https://www.devexpress.com/Support/Center/Question/Details/Q430217
            //https://documentation.devexpress.com/#WindowsForms/CustomDocument1874
            //storing current layout
            gridViewExport.SaveLayoutToXml(@"C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml");
            foreach (GridColumn column in gridViewExport.Columns)
            {
                //make all export columns visible
                column.Visible = true;
            }
            gridViewExport.ExportToXls(@"C:\Users\mf\Desktop\Neuer Ordner\export.xls");
            //restoring the layout, the layout file needs to be deleted manually
            gridViewExport.RestoreLayoutFromXml(@"C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml");
        }

        private void buttonExportToExcel_Click(object sender, EventArgs e)
        {
            ExportToExcel();
            XtraMessageBox.Show("Export successfull!", this.Text, MessageBoxButtons.OK,MessageBoxIcon.Information,MessageBoxDefaultButton.Button1);
        }
    }
}

using System;

using System.Data;

using System.Data.SqlClient;

using System.Windows.Forms;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Columns;

namespace de.Fesslersoft.ExportXtraGridToExcel

{

public partial class ExportForm : Form

{

private DataTable _dataTable;

public ExportForm()

{

InitializeComponent();

}

private void ExportForm_Load(object sender, EventArgs e)

{

FillDataTable();

gridViewExport.OptionsBehavior.AutoPopulateColumns = true;

gridViewExport.OptionsBehavior.ReadOnly = true;

gridViewExport.OptionsBehavior.Editable = false;

gridControlExport.DataSource = _dataTable;

}

private void FillDataTable()

{

//https://documentation.devexpress.com/#WindowsForms/CustomDocument2240

SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder

{

DataSource = "localhost",

IntegratedSecurity = true,

InitialCatalog = "Northwind"

};

using (SqlConnection connection = new SqlConnection(connectionStringBuilder.ToString()))

{

connection.Open();

string queryCommand = "SELECT TOP 100 [ProductID],[ProductName],[SupplierID],[CategoryID],[QuantityPerUnit],[UnitPrice],[UnitsInStock],[UnitsOnOrder],[ReorderLevel],[Discontinued] FROM [Northwind].[dbo].[Products]";

using (SqlDataAdapter adapter = new SqlDataAdapter(queryCommand, connection))

{

_dataTable = new DataTable();

adapter.Fill(_dataTable);

}

private void ExportToExcel()

{

//https://www.devexpress.com/Support/Center/Question/Details/Q430217

//https://documentation.devexpress.com/#WindowsForms/CustomDocument1874

//storing current layout

gridViewExport.SaveLayoutToXml(@"C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml");

foreach (GridColumn column in gridViewExport.Columns)

{

//make all export columns visible

column.Visible = true;

}

gridViewExport.ExportToXls(@"C:\Users\mf\Desktop\Neuer Ordner\export.xls");

//restoring the layout, the layout file needs to be deleted manually

gridViewExport.RestoreLayoutFromXml(@"C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml");

}

private void buttonExportToExcel_Click(object sender, EventArgs e)

{

ExportToExcel();

XtraMessageBox.Show("Export successfull!", this.Text, MessageBoxButtons.OK,MessageBoxIcon.Information,MessageBoxDefaultButton.Button1);

}

VB.NET Sample

Imports System.Data.SqlClient
Imports DevExpress.XtraEditors
Imports DevExpress.XtraGrid.Columns

Public Partial Class ExportForm
    Inherits Form
    Private _dataTable As DataTable

    Public Sub New()
        InitializeComponent()
    End Sub

    Private Sub ExportForm_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        FillDataTable()
        gridViewExport.OptionsBehavior.AutoPopulateColumns = True
        gridViewExport.OptionsBehavior.[ReadOnly] = True
        gridViewExport.OptionsBehavior.Editable = False
        gridControlExport.DataSource = _dataTable
    End Sub

    Private Sub FillDataTable()
        'https://documentation.devexpress.com/#WindowsForms/CustomDocument2240
        Dim connectionStringBuilder As New SqlConnectionStringBuilder() With { _
                .DataSource = "localhost", _
                .IntegratedSecurity = True, _
                .InitialCatalog = "Northwind" _
                }
        Using connection As New SqlConnection(connectionStringBuilder.ToString())
            connection.Open()
            Dim queryCommand As String = "SELECT TOP 100 [ProductID],[ProductName],[SupplierID],[CategoryID],[QuantityPerUnit],[UnitPrice],[UnitsInStock],[UnitsOnOrder],[ReorderLevel],[Discontinued] FROM [Northwind].[dbo].[Products]"
            Using adapter As New SqlDataAdapter(queryCommand, connection)
                _dataTable = New DataTable()
                adapter.Fill(_dataTable)
            End Using
        End Using
    End Sub

    Private Sub ExportToExcel()
        'https://www.devexpress.com/Support/Center/Question/Details/Q430217
        'https://documentation.devexpress.com/#WindowsForms/CustomDocument1874
        'storing current layout
        gridViewExport.SaveLayoutToXml("C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml")
        For Each column As GridColumn In gridViewExport.Columns
            'make all export columns visible
            column.Visible = True
        Next
        gridViewExport.ExportToXls("C:\Users\mf\Desktop\Neuer Ordner\export.xls")
        'restoring the layout, the layout file needs to be deleted manually
        gridViewExport.RestoreLayoutFromXml("C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml")
    End Sub

    Private Sub buttonExportToExcel_Click(sender As Object, e As EventArgs) Handles SimpleButton1.Click
        ExportToExcel()
        XtraMessageBox.Show("Export successfull!", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)
    End Sub
End Class

Imports System.Data.SqlClient

Imports DevExpress.XtraEditors

Imports DevExpress.XtraGrid.Columns

Public Partial Class ExportForm

Inherits Form

Private _dataTable As DataTable

Public Sub New()

InitializeComponent()

End Sub

Private Sub ExportForm_Load(sender As Object, e As EventArgs) Handles MyBase.Load

FillDataTable()

gridViewExport.OptionsBehavior.AutoPopulateColumns = True

gridViewExport.OptionsBehavior.[ReadOnly] = True

gridViewExport.OptionsBehavior.Editable = False

gridControlExport.DataSource = _dataTable

End Sub

Private Sub FillDataTable()

'https://documentation.devexpress.com/#WindowsForms/CustomDocument2240

Dim connectionStringBuilder As New SqlConnectionStringBuilder() With { _

.DataSource = "localhost", _

.IntegratedSecurity = True, _

.InitialCatalog = "Northwind" _

}

Using connection As New SqlConnection(connectionStringBuilder.ToString())

connection.Open()

Dim queryCommand As String = "SELECT TOP 100 [ProductID],[ProductName],[SupplierID],[CategoryID],[QuantityPerUnit],[UnitPrice],[UnitsInStock],[UnitsOnOrder],[ReorderLevel],[Discontinued] FROM [Northwind].[dbo].[Products]"

Using adapter As New SqlDataAdapter(queryCommand, connection)

_dataTable = New DataTable()

adapter.Fill(_dataTable)

End Using

End Sub

Private Sub ExportToExcel()

'https://www.devexpress.com/Support/Center/Question/Details/Q430217

'https://documentation.devexpress.com/#WindowsForms/CustomDocument1874

'storing current layout

gridViewExport.SaveLayoutToXml("C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml")

For Each column As GridColumn In gridViewExport.Columns

'make all export columns visible

column.Visible = True

gridViewExport.ExportToXls("C:\Users\mf\Desktop\Neuer Ordner\export.xls")

'restoring the layout, the layout file needs to be deleted manually

gridViewExport.RestoreLayoutFromXml("C:\Users\mf\Desktop\Neuer Ordner\tempLayout.xml")

End Sub

Private Sub buttonExportToExcel_Click(sender As Object, e As EventArgs) Handles SimpleButton1.Click

ExportToExcel()

XtraMessageBox.Show("Export successfull!", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)

End Sub

End Class

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

How to get the selected row index in Devexpress Xtragrid Control using C# and VB.NET

Administrator

May 6, 2015

4 Comments

To get the selected row index in Devexpress Xtragrid Control using C# and VB.NET you can use the snippet below.

Samples

Sample C#

int selectedRowIndex = gridView1.FocusedRowHandle;

1	int selectedRowIndex = gridView1.FocusedRowHandle;

Sample VB.NET

Dim selectedRowIndex as Integer = gridView1.FocusedRowHandle

1	Dim selectedRowIndex as Integer = gridView1.FocusedRowHandle

Compatibility:

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 4.5

.NET 4.6

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

ColumnView.FocusedRowHandle Property

How to Display an Image in Devexpress XtraGrid Control using C# and VB.NET

Administrator

March 23, 2015

4 Comments

To Display an Image in Devexpress XtraGrid Control using C# and VB.NET see the example below.

Sample C#

#region

using System.Data;
using System.Drawing;
using System.Windows.Forms;
using WindowsFormsApplication77.Properties;
using DevExpress.XtraEditors.Repository;

#endregion

namespace de.fesslersoft.XtraGridImageTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            gridControl1.DataSource = CreateTable(3);
            gridView1.Columns["Image"].ColumnEdit = new RepositoryItemPictureEdit();
        }

        private DataTable CreateTable(int rowCount)
        {
            var image = Resources.Image1;
            var tbl = new DataTable();
            tbl.Columns.Add("ID", typeof (int));
            tbl.Columns.Add("URL", typeof (string));
            tbl.Columns.Add("Image", typeof (Image));
            for (var i = 0; i < rowCount; i++)
            {
                tbl.Rows.Add(new object[] {i, "http://codesnippets.fesslersoft.de", image});
            }
            return tbl;
        }
    }
}

Sample VB.NET

#Region ""

Imports System.Data
Imports System.Drawing
Imports System.Windows.Forms
Imports WindowsFormsApplication77.Properties
Imports DevExpress.XtraEditors.Repository

#End Region

Namespace de.fesslersoft.XtraGridImageTest
	Public Partial Class Form1
		Inherits Form
		Public Sub New()
			InitializeComponent()
			gridControl1.DataSource = CreateTable(3)
			gridView1.Columns("Image").ColumnEdit = New RepositoryItemPictureEdit()
		End Sub

		Private Function CreateTable(rowCount As Integer) As DataTable
			Dim image = Resources.Image1
			Dim tbl = New DataTable()
			tbl.Columns.Add("ID", GetType(Integer))
			tbl.Columns.Add("URL", GetType(String))
			tbl.Columns.Add("Image", GetType(Image))
			For i As var = 0 To rowCount - 1
				tbl.Rows.Add(New Object() {i, "http://codesnippets.fesslersoft.de", image})
			Next
			Return tbl
		End Function
	End Class
End Namespace

Result

XtraGrid ColumnImages

How to get focusedrow cell value using Devexpress XtraGrid in C# and VB.NET

Administrator

February 12, 2015

4 Comments

To get focusedrow cell value using Devexpress XtraGrid in C# and VB.NET you can use one of the following ways.

Samples

Sample C#

string value = gridView1.GetFocusedRowCellValue("ColumnName").ToString();
string value = gridView1.GetDataRow(e.FocusedRowHandle)["ColumnName"].ToString();
string value = (gridView1.GetFocusedRow() as DataRowView).Row["ColumnName"].ToString();
string value = gridView1.GetFocusedDataRow()["ColumnName"].ToString();

string value = gridView1.GetFocusedRowCellValue("ColumnName").ToString();

string value = gridView1.GetDataRow(e.FocusedRowHandle)["ColumnName"].ToString();

string value = (gridView1.GetFocusedRow() as DataRowView).Row["ColumnName"].ToString();

string value = gridView1.GetFocusedDataRow()["ColumnName"].ToString();

Sample VB.NET

Dim value as String = gridView1.GetFocusedRowCellValue("ColumnName").ToString()
Dim value as String = gridView1.GetDataRow(e.FocusedRowHandle)("ColumnName").ToString()
Dim value as String = TryCast(gridView1.GetFocusedRow(), DataRowView).Row("ColumnName").ToString()
Dim value as String = gridView1.GetFocusedDataRow()("ColumnName").ToString()

Dim value as String = gridView1.GetFocusedRowCellValue("ColumnName").ToString()

Dim value as String = gridView1.GetDataRow(e.FocusedRowHandle)("ColumnName").ToString()

Dim value as String = TryCast(gridView1.GetFocusedRow(), DataRowView).Row("ColumnName").ToString()

Dim value as String = gridView1.GetFocusedDataRow()("ColumnName").ToString()

Compatibility:

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 4.5

.NET 4.6

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

How to disable Devexpress Node Movement while Drag Drop in C# and VB.NET

Administrator

February 3, 2015

1 Comment

To disable Devexpress Node Movement while Drag Drop in C# and VB.NET you can use the following snippet.

Sample C#

private void treeList1_DragOver(object sender, DragEventArgs e) 
{
	e.Effect = DragDropEffects.None;
}

private void treeList1_CalcNodeDragImageIndex(object sender, CalcNodeDragImageIndexEventArgs e) 
{
	e.ImageIndex = -1;
}

Sample VB.NET

Private Sub treeList1_DragOver(ByVal sender As Object, ByVal e As DragEventArgs)
	e.Effect = DragDropEffects.None
End Sub

Private Sub treeList1_CalcNodeDragImageIndex(ByVal sender As Object, ByVal e As CalcNodeDragImageIndexEventArgs)
	e.ImageIndex = -1
End Sub

How to use Doubleclick in Devexpress Gridview in C# and VB.NET

Administrator

January 29, 2015

1 Comment

Using doubleclick events in the Devexpress Gridview Control is a simple task.
There are 2 different ways of doing this. The variant you choose, depends on the Gridview’s gridView.OptionsBehavior.Editable property. If this property is set to false you have to use the DoubleClick event. If this property is set to true you have to use the ShownEditor and HiddenEditor event. I will also give an example on how to combine both methods, if you are using both (true and false) on the gridView.OptionsBehavior.Editable.

Samples

OptionsBehavior.Editable set to False

C# Sample

private void gridView1_DoubleClick(object sender, EventArgs e)
{
	GridView view = (GridView)sender;
	Point pt = view.GridControl.PointToClient(MousePosition);
	GridHitInfo info = view.CalcHitInfo(pt);
	if ((info.InRow || info.InRowCell) &amp;&amp; info.Column != null)
	{
		Object cellValue = view.GetRowCellValue(info.RowHandle, info.Column);
		MessageBox.Show(string.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue));
	}
}

private void gridView1_DoubleClick(object sender, EventArgs e)

{

GridView view = (GridView)sender;

Point pt = view.GridControl.PointToClient(MousePosition);

GridHitInfo info = view.CalcHitInfo(pt);

if ((info.InRow || info.InRowCell) && info.Column != null)

{

Object cellValue = view.GetRowCellValue(info.RowHandle, info.Column);

MessageBox.Show(string.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue));

}

VB.NET Sample

Private Sub GridView1_DoubleClick( sender As Object,  e As EventArgs) Handles GridView1.DoubleClick
        Dim view As GridView = DirectCast(sender, GridView)
        Dim pt As Point = view.GridControl.PointToClient(MousePosition)
        Dim info As GridHitInfo = view.CalcHitInfo(pt)
        If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then
	        Dim cellValue As [Object] = view.GetRowCellValue(info.RowHandle, info.Column)
	        MessageBox.Show(String.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue))
        End If
End Sub

Private Sub GridView1_DoubleClick( sender As Object, e As EventArgs) Handles GridView1.DoubleClick

Dim view As GridView = DirectCast(sender, GridView)

Dim pt As Point = view.GridControl.PointToClient(MousePosition)

Dim info As GridHitInfo = view.CalcHitInfo(pt)

If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then

Dim cellValue As [Object] = view.GetRowCellValue(info.RowHandle, info.Column)

MessageBox.Show(String.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue))

End If

End Sub

OptionsBehavior.Editable set to True

When inplace editing is enabled, a click on a grid cell activates the inplace editor (rowedit).
All mouse events will be sent to the editor and cannot be handled by the GridView directly. The DoubleClick event handler is no longer being executed.

C# Sample

private void gridView1_ShownEditor(object sender, EventArgs e)
{
	BaseEdit inplaceEditor = ((GridView)sender).ActiveEditor;
	inplaceEditor.DoubleClick += inplaceEditor_DoubleClick;
}

void inplaceEditor_DoubleClick(object sender, EventArgs e)
{
	BaseEdit editor = (BaseEdit)sender;
	GridControl grid = (GridControl)editor.Parent;
	Point pt = grid.PointToClient(Control.MousePosition);
	GridView view = (GridView)grid.FocusedView;
	GridHitInfo info = view.CalcHitInfo(pt);
	if ((info.InRow || info.InRowCell) &amp;&amp; info.Column != null)
	{
		Object cellValue = view.GetRowCellValue(info.RowHandle, info.Column);
		MessageBox.Show(string.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue));
	}
}

private void gridView1_HiddenEditor(object sender, EventArgs e)
{
	if (sender.GetType() == typeof (BaseEdit))
	{
		BaseEdit editor = (BaseEdit) sender;
		editor.DoubleClick -= inplaceEditor_DoubleClick;
	}
}

private void gridView1_ShownEditor(object sender, EventArgs e)

{

BaseEdit inplaceEditor = ((GridView)sender).ActiveEditor;

inplaceEditor.DoubleClick += inplaceEditor_DoubleClick;

}

void inplaceEditor_DoubleClick(object sender, EventArgs e)

{

BaseEdit editor = (BaseEdit)sender;

GridControl grid = (GridControl)editor.Parent;

Point pt = grid.PointToClient(Control.MousePosition);

GridView view = (GridView)grid.FocusedView;

GridHitInfo info = view.CalcHitInfo(pt);

if ((info.InRow || info.InRowCell) && info.Column != null)

{

Object cellValue = view.GetRowCellValue(info.RowHandle, info.Column);

MessageBox.Show(string.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue));

}

private void gridView1_HiddenEditor(object sender, EventArgs e)

{

if (sender.GetType() == typeof (BaseEdit))

{

BaseEdit editor = (BaseEdit) sender;

editor.DoubleClick -= inplaceEditor_DoubleClick;

}

VB.NET Sample

Private Sub gridView1_ShownEditor(sender As Object, e As EventArgs) Handles GridView1.ShownEditor
	Dim inplaceEditor As BaseEdit = DirectCast(sender, GridView).ActiveEditor
	AddHandler inplaceEditor.DoubleClick, AddressOf inplaceEditor_DoubleClick
End Sub

Private Sub inplaceEditor_DoubleClick(sender As Object, e As EventArgs)
	Dim editor As BaseEdit = DirectCast(sender, BaseEdit)
	Dim grid As GridControl = DirectCast(editor.Parent, GridControl)
	Dim pt As Point = grid.PointToClient(Control.MousePosition)
	Dim view As GridView = DirectCast(grid.FocusedView, GridView)
	Dim info As GridHitInfo = view.CalcHitInfo(pt)
	If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then
		Dim cellValue As Object = view.GetRowCellValue(info.RowHandle, info.Column)
		MessageBox.Show(String.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue))
	End If
End Sub

Private Sub gridView1_HiddenEditor(sender As Object, e As EventArgs) Handles GridView1.HiddenEditor
	If sender.GetType() = GetType(BaseEdit) Then
		Dim editor As BaseEdit = DirectCast(sender, BaseEdit)
		RemoveHandler editor.DoubleClick, AddressOf inplaceEditor_DoubleClick
	End If
End Sub

Private Sub gridView1_ShownEditor(sender As Object, e As EventArgs) Handles GridView1.ShownEditor

Dim inplaceEditor As BaseEdit = DirectCast(sender, GridView).ActiveEditor

AddHandler inplaceEditor.DoubleClick, AddressOf inplaceEditor_DoubleClick

End Sub

Private Sub inplaceEditor_DoubleClick(sender As Object, e As EventArgs)

Dim editor As BaseEdit = DirectCast(sender, BaseEdit)

Dim grid As GridControl = DirectCast(editor.Parent, GridControl)

Dim pt As Point = grid.PointToClient(Control.MousePosition)

Dim view As GridView = DirectCast(grid.FocusedView, GridView)

Dim info As GridHitInfo = view.CalcHitInfo(pt)

If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then

Dim cellValue As Object = view.GetRowCellValue(info.RowHandle, info.Column)

MessageBox.Show(String.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue))

End If

End Sub

Private Sub gridView1_HiddenEditor(sender As Object, e As EventArgs) Handles GridView1.HiddenEditor

If sender.GetType() = GetType(BaseEdit) Then

Dim editor As BaseEdit = DirectCast(sender, BaseEdit)

RemoveHandler editor.DoubleClick, AddressOf inplaceEditor_DoubleClick

End If

End Sub

OptionsBehavior.Editable set to True or False at Runtime

C# Sample

private void gridView1_DoubleClick(object sender, EventArgs e)
{
	GridView view = (GridView)sender;
	Point pt = view.GridControl.PointToClient(MousePosition);
	GridHitInfo info = view.CalcHitInfo(pt);
	if ((info.InRow || info.InRowCell) && info.Column != null)
	{
		DoSomething(view, info);
	}
}

private void DoSomething(GridView view, GridHitInfo info)
{
	Object cellValue = view.GetRowCellValue(info.RowHandle, info.Column);
	MessageBox.Show(string.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue));
}

private void gridView1_ShownEditor(object sender, EventArgs e)
{
	BaseEdit inplaceEditor = ((GridView)sender).ActiveEditor;
	inplaceEditor.DoubleClick += inplaceEditor_DoubleClick;
}

void inplaceEditor_DoubleClick(object sender, EventArgs e)
{
	BaseEdit editor = (BaseEdit)sender;
	GridControl grid = (GridControl)editor.Parent;
	Point pt = grid.PointToClient(Control.MousePosition);
	GridView view = (GridView)grid.FocusedView;
	GridHitInfo info = view.CalcHitInfo(pt);
	if ((info.InRow || info.InRowCell) && info.Column != null)
	{
		DoSomething(view, info);
	}
}

private void gridView1_HiddenEditor(object sender, EventArgs e)
{
	if (sender.GetType() == typeof (BaseEdit))
	{
		BaseEdit editor = (BaseEdit) sender;
		editor.DoubleClick -= inplaceEditor_DoubleClick;
	}
}

private void gridView1_DoubleClick(object sender, EventArgs e)

{

GridView view = (GridView)sender;

Point pt = view.GridControl.PointToClient(MousePosition);

GridHitInfo info = view.CalcHitInfo(pt);

if ((info.InRow || info.InRowCell) && info.Column != null)

{

DoSomething(view, info);

}

private void DoSomething(GridView view, GridHitInfo info)

{

Object cellValue = view.GetRowCellValue(info.RowHandle, info.Column);

MessageBox.Show(string.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue));

}

private void gridView1_ShownEditor(object sender, EventArgs e)

{

BaseEdit inplaceEditor = ((GridView)sender).ActiveEditor;

inplaceEditor.DoubleClick += inplaceEditor_DoubleClick;

}

void inplaceEditor_DoubleClick(object sender, EventArgs e)

{

BaseEdit editor = (BaseEdit)sender;

GridControl grid = (GridControl)editor.Parent;

Point pt = grid.PointToClient(Control.MousePosition);

GridView view = (GridView)grid.FocusedView;

GridHitInfo info = view.CalcHitInfo(pt);

if ((info.InRow || info.InRowCell) && info.Column != null)

{

DoSomething(view, info);

}

private void gridView1_HiddenEditor(object sender, EventArgs e)

{

if (sender.GetType() == typeof (BaseEdit))

{

BaseEdit editor = (BaseEdit) sender;

editor.DoubleClick -= inplaceEditor_DoubleClick;

}

VB.NET Sample

Private Sub gridView1_DoubleClick(sender As Object, e As EventArgs)
	Dim view As GridView = DirectCast(sender, GridView)
	Dim pt As Point = view.GridControl.PointToClient(MousePosition)
	Dim info As GridHitInfo = view.CalcHitInfo(pt)
	If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then
		DoSomething(view, info)
	End If
End Sub

Private Sub DoSomething(view As GridView, info As GridHitInfo)
	Dim cellValue As Object = view.GetRowCellValue(info.RowHandle, info.Column)
	MessageBox.Show(String.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue))
End Sub

Private Sub gridView1_ShownEditor(sender As Object, e As EventArgs)
	Dim inplaceEditor As BaseEdit = DirectCast(sender, GridView).ActiveEditor
	AddHandler inplaceEditor.DoubleClick, AddressOf inplaceEditor_DoubleClick
End Sub

Private Sub inplaceEditor_DoubleClick(sender As Object, e As EventArgs)
	Dim editor As BaseEdit = DirectCast(sender, BaseEdit)
	Dim grid As GridControl = DirectCast(editor.Parent, GridControl)
	Dim pt As Point = grid.PointToClient(Control.MousePosition)
	Dim view As GridView = DirectCast(grid.FocusedView, GridView)
	Dim info As GridHitInfo = view.CalcHitInfo(pt)
	If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then
		DoSomething(view, info)
	End If
End Sub

Private Sub gridView1_HiddenEditor(sender As Object, e As EventArgs)
	If sender.GetType() = GetType(BaseEdit) Then
		Dim editor As BaseEdit = DirectCast(sender, BaseEdit)
		RemoveHandler editor.DoubleClick, AddressOf inplaceEditor_DoubleClick
	End If
End Sub

Private Sub gridView1_DoubleClick(sender As Object, e As EventArgs)

Dim view As GridView = DirectCast(sender, GridView)

Dim pt As Point = view.GridControl.PointToClient(MousePosition)

Dim info As GridHitInfo = view.CalcHitInfo(pt)

If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then

DoSomething(view, info)

End If

End Sub

Private Sub DoSomething(view As GridView, info As GridHitInfo)

Dim cellValue As Object = view.GetRowCellValue(info.RowHandle, info.Column)

MessageBox.Show(String.Format("Made a doubleclick at rowhandle: {0}, columnhandle: {1}, value: {2}.", info.RowHandle, info.Column.ColumnHandle, cellValue))

End Sub

Private Sub gridView1_ShownEditor(sender As Object, e As EventArgs)

Dim inplaceEditor As BaseEdit = DirectCast(sender, GridView).ActiveEditor

AddHandler inplaceEditor.DoubleClick, AddressOf inplaceEditor_DoubleClick

End Sub

Private Sub inplaceEditor_DoubleClick(sender As Object, e As EventArgs)

Dim editor As BaseEdit = DirectCast(sender, BaseEdit)

Dim grid As GridControl = DirectCast(editor.Parent, GridControl)

Dim pt As Point = grid.PointToClient(Control.MousePosition)

Dim view As GridView = DirectCast(grid.FocusedView, GridView)

Dim info As GridHitInfo = view.CalcHitInfo(pt)

If (info.InRow OrElse info.InRowCell) AndAlso info.Column IsNot Nothing Then

DoSomething(view, info)

End If

End Sub

Private Sub gridView1_HiddenEditor(sender As Object, e As EventArgs)

If sender.GetType() = GetType(BaseEdit) Then

Dim editor As BaseEdit = DirectCast(sender, BaseEdit)

RemoveHandler editor.DoubleClick, AddressOf inplaceEditor_DoubleClick

End If

End Sub

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

How to use Node Doubleclick in Devexpress Treelist in C# and VB.NET

Administrator

January 29, 2015

1 Comment

How to use Node Doubleclick in Devexpress Treelist in C# and VB.NET you can use the following snippet.

Sample C#

private void treeList1_DoubleClick(object sender, EventArgs e) 
{
	var treeList = sender as TreeList;
	var hitInfo = treeList.CalcHitInfo(treeList.PointToClient(MousePosition));
	if(hitInfo.Node != null) 
	{
		//do something
	}
}

Sample VB.NET

Private Sub treeList1_DoubleClick(sender As Object, e As EventArgs)
	Dim treeList = TryCast(sender, TreeList)
	Dim hitInfo = treeList.CalcHitInfo(treeList.PointToClient(MousePosition))
			'do something
	If hitInfo.Node IsNot Nothing Then
	End If
End Sub

How to get Devexpress Wizardpage by Name in C# and VB.NET

Administrator

January 27, 2015

1 Comment

To get Devexpress Wizardpage by Name in C# and VB.NET you can use the following snippet.

Sample C#

public static WizardPage GetWizardPageByName(WizardControl wizard, string name)
{
	var controls = wizard.Controls.Find(name, false);
	if (controls.Length > 0 && controls[0] is WizardPage)
	{
		return controls[0] as WizardPage;
	}
	return null;
}

Sample VB.NET

Public Shared Function GetWizardPageByName(wizard As WizardControl, name As String) As WizardPage
	Dim controls = wizard.Controls.Find(name, False)
	If controls.Length > 0 AndAlso TypeOf controls(0) Is WizardPage Then
		Return TryCast(controls(0), WizardPage)
	End If
	Return Nothing
End Function

CODE SNIPPETS

CODESNIPPETS FOR .NET, SQL, JAVASCRIPT, JQUERY and more

Devexpress

How to export Gridview data to Excel using devexpress XtraGrid

Samples

C# Sample

VB.NET Sample

How to get the selected row index in Devexpress Xtragrid Control using C# and VB.NET

Samples

Sample C#

Sample VB.NET

How to Display an Image in Devexpress XtraGrid Control using C# and VB.NET

Sample C#

Sample VB.NET

Result

How to get focusedrow cell value using Devexpress XtraGrid in C# and VB.NET

Samples

Sample C#

Sample VB.NET

How to get Devexpress Wizardpage by Name in C# and VB.NET

Sample C#

Sample VB.NET