Home Forums WinForms controls Xceed Grid for WinForms Xceed Grid for .Net Programmatically Grouping Data Reply To: Xceed Grid for .Net Programmatically Grouping Data

User (Old forums)
Post count: 23064

Well, I’ve found some code in the documentation that should work but fomr some reason I still can’t get the grid to group for me. I have included some code this time. If any of you can see what I am doing wrong I would appreciate the help.



Sub WorkStations_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim objConn As OleDbConnection = New OleDbConnection(“Server=HRCANVSOPS\OPSTORE1;uid=*******;pwd=*******;database=OSP; Application Name=OSP;Provider=SQLOLEDB”)

Dim DataRead As New DataSet

Dim cmdData As OleDbDataAdapter = New OleDbDataAdapter(“Select OfficeID, DistrictIk, NumWorkStations, BusinessTypeID, CreatedBy, CreatedDate From OfficeWorkStations”, objConn)



Dim cb As New OleDbCommandBuilder(cmdData)

cmdData.InsertCommand = cb.GetInsertCommand()

cmdData.DeleteCommand = cb.GetDeleteCommand()

cmdData.UpdateCommand = cb.GetUpdateCommand()

GridControl1.DataSource = DataRead

GridControl1.DataMember =


Dim group As New Group()

group.GroupBy =



New GroupManagerRow())



New Group(“DistrictIk”))


End Sub

Imported from legacy forums. Posted by Jeff (had 511 views)