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)
Member
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.

 Thanks,

Private

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)

cmdData.Fill(DataRead,

“WrkStations”)

Dim cb As New OleDbCommandBuilder(cmdData)

cmdData.InsertCommand = cb.GetInsertCommand()

cmdData.DeleteCommand = cb.GetDeleteCommand()

cmdData.UpdateCommand = cb.GetUpdateCommand()

GridControl1.DataSource = DataRead

GridControl1.DataMember =

“WrkStations”

Dim group As New Group()

group.GroupBy =

“DistrictIk”

group.HeaderRows.Add(

New GroupManagerRow())

GridControl1.GroupTemplates.Add(group)

GridControl1.GroupTemplates.Add(

New Group(“DistrictIk”))

 

End Sub

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