To select a item on rightclick using devexpress ListboxControl you need to use the MouseDown Event.
See the samples below.
private void listBoxControl1_MouseDown(object sender, MouseEventArgs e)
{
listBoxControl1.SelectedIndex = listBoxControl1.IndexFromPoint(new Point(e.X, e.Y));
}
Private Sub listBoxControl1_MouseDown(sender As Object, e As MouseEventArgs) listBoxControl1.SelectedIndex = listBoxControl1.IndexFromPoint(New Point(e.X, e.Y)) End Sub
To change the BackgroundColor of a XtraGrid Grouprow you need to use the Gridviews CustomDrawGroupRow Event.
private void gridView1_CustomDrawGroupRow(object sender, RowObjectCustomDrawEventArgs e)
{
var converter = new ColorConverter();
var convertFromString = converter.ConvertFromString("#ebebeb");
if (convertFromString != null)
{
e.Appearance.BackColor = (Color) convertFromString;
}
}
Private Sub gridView1_CustomDrawGroupRow(sender As Object, e As RowObjectCustomDrawEventArgs)
Dim converter = New ColorConverter()
Dim convertFromString = converter.ConvertFromString("#ebebeb")
If convertFromString IsNot Nothing Then
e.Appearance.BackColor = DirectCast(convertFromString, Color)
End If
End Sub
To get the selected row index in Devexpress Xtragrid Control using C# and VB.NET you can use the snippet below.
|
1 |
int selectedRowIndex = gridView1.FocusedRowHandle; |
|
1 |
Dim selectedRowIndex as Integer = gridView1.FocusedRowHandle |
If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.
Related links:
To split a delimited string to multiple rows using MSSQL you can use the snippet below.
CREATE FUNCTION dbo.StringSplit
(
@Input NVARCHAR(MAX),
@Delimiter NVARCHAR(255)
)
RETURNS TABLE
AS
RETURN (
SELECT Number = ROW_NUMBER() OVER (ORDER BY Number),
Item FROM (
SELECT Number, Item = LTRIM(RTRIM(SUBSTRING(@Input, Number, CHARINDEX(@Delimiter, @Input + @Delimiter, Number) - Number)))
FROM (SELECT ROW_NUMBER() OVER (ORDER BY ao.[object_id])
FROM sys.all_objects AS ao CROSS APPLY sys.all_objects) AS n(Number)
WHERE Number <= CONVERT(INT, LEN(@Input))
AND SUBSTRING(@Delimiter + @Input, Number, 1) = @Delimiter
) AS item);
GO
To Display an Image in Devexpress XtraGrid Control using C# and VB.NET see the example below.
#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;
}
}
}
#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
XtraGrid ColumnImages
To query a DataTable using LINQ in C# and VB.NET you can use the snippet below.
In order to use the snippet, you need to reference System.Data.DataSetExtensions.
var resultData = (from myDataRow in myDataTable.AsEnumerable() where myDataRow.Field<Int32>("Fieldname") == 1 select myRow);
Dim resultData = (From myDataRow In myDataTable.AsEnumerable() Where myDataRow.Field(Of Int32)("Fieldname") = 1myRow)
To get focusedrow cell value using Devexpress XtraGrid in C# and VB.NET you can use one of the following ways.
|
1 2 3 4 |
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(); |
|
1 2 3 4 |
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() |
If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.
Related links:
To read a textfile line by line in VBA you can use the following snippet.
To read a textfile complete into a string you can use How to read a textfile in VBA.
public sub ReadTextFileLinebyLine()
Dim sFileName As String
Dim iFile As Integer
Dim sLine As String
on error goto errorhandler
sFileName = "C:\Users\Codesnippets\Desktop\Test.txt"
If Len(Dir$(sFileName)) = 0 Then
Exit Sub
End If
iFile = FreeFile()
Open sFileName For Input As iFile
Do While Not EOF(iFile)
Line Input #iFile, sLine
Debug.Print sLine
Loop
Close iFile
exit sub
errorhandler:
'handle the error your way
End Sub
To create zebra table effect with jQuery and CSS you can use the following snippet.
$("tr:odd").addClass("oddRowsEffect");
in the css you need something like
tr.oddRowsEffect{
/* background: choose a color; *
/* color: choose a color; *
}
To select a random row in MySQL you can use the following query.
SELECT COLUMNNAME FROM TABLENAME ORDER BY RAND() LIMIT 1