向BriskDataGrid添加列

 

向BriskDataGrid添加列

出于各种各样的原因，需要往BriskDataGrid里添加列。需要注意的是，在添加列之前必须先调用BriskDataGrid.BeginTableStyle()方法。该方法唯一的参数MappingName要求传递映射表的表名。如下例中，BriskDataGrid要显示的是数据集中的employees表的数据，那么就应该传递字符串”employees”。同样不能忘记，当添加列之后必须调用BriskDataGrid.EndTableStyle()方法。如果在调用此方法之前没有调用BriskDataGrid.BeginTableStyle()方法，就会抛除异常NullReferenceException。

以下程序向BriskDataGrid添加了多个列：

Private Sub InitBriskDataGrid()

Dim dvEmployee As New DataView(Me.dsHR.Tables("employees"))

Me.BriskDataGrid.SetDataBinding(dvEmployee)

Me.BriskDataGrid.BeginTableStyle("employees")

Dim colEmpId As DataGridTextColumn

Me.BriskDataGrid.AddTextColumn(colEmpId, "emp_id", "雇员编号")

Dim colEmpName As DataGridTextColumn

Me.BriskDataGrid.AddTextColumn(colEmpName, "emp_name", "雇员姓名")

Dim colEmpSex As New DataGridSexBoxColumn

Me.BriskDataGrid.AddSexBoxColumn(colEmpSex, "emp_sex", "雇员性别")

Dim colEmpAge As DataGridTextColumn

Me.BriskDataGrid.AddTextColumn(colEmpAge, "emp_age", "雇员年龄")

Dim colEmpDepartment As DataGridComboBoxColumn

Me.BriskDataGrid.AddComboBoxColumn(colEmpDepartment, Me.dsHR.Tables("departments"), "dept_id", "dept_name", "emp_department", "所在部门")

Dim colBirth As DataGridDateTimePickerColumn

Me.BriskDataGrid.AddDateTimePickerColumn(colBirth, "emp_dateofbirth", "雇员生日")

Dim colSingle As New DataGridCheckBoxColumn

Me.BriskDataGrid.AddCheckBoxColumn(colSingle, "emp_single", "是否单身")

Me.BriskDataGrid.EndTableStyle()

End Sub