构建 DataTable 类的新实例。
全称 | mx.datas.DataTable |
命名空间 | mx.datas |
类 | DataTable |
继承层次结构 | DataTableDataObject |
源文件 | ~\mx\scripts\datas\DataTable.js |
JavaScript 代码 |
var table = new mx.datas.DataTable(); |
JavaScript 代码 |
var table = new mx.datas.DataTable({
columns:[
new mx.datas.DataColumn({id:"name", label:"名字", type:"string"}),
new mx.datas.DataColumn({id:"age", label:"年龄", type:"number"}),
new mx.datas.DataColumn({id:"sex", label:"性别", type:"number"}),
new mx.datas.DataColumn({id:"birthday", label:"生日", type:"Date", pattern:"yyyy.MM.dd"})
],
rows:[
new mx.datas.DataRow({cells:[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]}),
new mx.datas.DataRow({cells:[{value:"李四"}, {value:24},{value:"0", formattedValue:"女"}, {value:"1984-1-1"}]}),
new mx.datas.DataRow({cells:[{value:"王五"}, {value:25},{value:"1", formattedValue:"男"}, {value:"1988-1-1"}]})
]
}); |
JavaScript 代码 |
var table = new mx.datas.DataTable({
columns:[
{id:"name", label:"名字", type:"string"},
{id:"age", label:"年龄", type:"number"},
{id:"sex", label:"性别", type:"number"},
{id:"birthday", label:"生日", type:"Date", pattern:"yyyy.MM.dd"}
],
rows:[{
cells:[
[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]},
[{value:"李四"}, {value:24},{value:"0",formattedValue:"女"},{value:"1984-1-1"}],
[{value:"王五"}, {value:25},{value:"1",formattedValue:"男"}, {value:"1988-1-1"}]
]
}]
}); |
JavaScript 代码 |
var table = new mx.datas.DataTable({
cols:[
["name","名字"],
["age","年龄", "number"],
["sex","性别","number"],
["birthday","生日","Date","yyyy.MM.dd"]
],
rows:[
[{v:"张三"}, {v:23},{v:"1",f:"男"}, {v:"1985-1-1"}],
[{v:"李四"}, {v:24},{v:"0",f:"女"},{v:"1984-1-1"}],
[{v:"王五"}, {v:25},{v:"1",f:"男"}, {v:"1988-1-1"}]
]
}); |
JavaScript 代码 |
var table = new mx.datas.DataTable({
cols:[
["name","名字"],
["age","年龄", "number"],
["sex","性别","number"],
["birthday","生日","Date","yyyy.MM.dd"]
],
rows:[
["张三", 23,"男", "1985-1-1"],
["李四", 24,"女","1984-1-1"],
["王五", 25,"男", "1988-1-1"]
]
}); |
名称 | 说明 |
DataTable() | 构建 DataTable 类的新实例。 |
名称 | 说明 |
columns | 获取该表的数据行 DataColumn 的集合。 |
rows | 获取该表的数据行 DataRow 的集合。 |
sortColumn | |
sortOrder |
名称 | 说明 |
onchanged | |
onchanging | |
oncolumnCreated | |
oncolumnCreating | |
oncolumnDeleted | |
oncolumnDeleting | |
onrowCreated | |
onrowCreating | |
onrowDeleted | |
onrowDeleting |
JavaScript 代码 |
table.addColumn(new mx.datas.DataColumn({type :"number", label :"身高", id:"height"}));
table.addColumn({id:"height", label :"身高", type :"number"});
table.addColumn(["height", "身高", "number"]);
table.addColumn("height", "身高", "number"); |
JavaScript 代码 |
table.addColumn(new mx.datas.DataColumn({type :"number", label :"身高", id:"height"}));
table.addColumn({id:"height", label :"身高", type :"number"});
table.addColumn(["height", "身高", "number"]);
table.addColumn("height", "身高", "number"); |
JavaScript 代码 |
// 示例 1
table.addColumns([
{id:"name", label:"名字", type:"string"},
{id:"age", label:"年龄", type:"number"},
new mx.datas.DataColumn({id:"sex", label:"性别", type:"number"}),
{id:"birthday", label:"生日", type:"Date", pattern:"yyyy.MM.dd"}
]);
// 示例 2
table.addColumns([
["name", "名字", "string"],
["age", "年龄", "number"],
["sex", "性别","number"}],
["birthday", "生日","Date", "yyyy-MM-dd"]
]); |
JavaScript 代码 |
// 增加空行,本行 cells 中的 value 为空
table.addRow();
// 参数为json对象时
table.addRow(
{cells:[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]}
);
// 参数为DataRow对象时
table.addRow(
new mx.datas.DataRow({cells:[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]})
); |
JavaScript 代码 |
// 在索引为 1 的位置插入一列的示例
table.insertColumn(1, new mx.datas.DataColumn({type :"number", label :"身高", id:"height"}));
table.insertColumn(1, {id:"height", label :"身高", type :"number"});
table.insertColumn(1, ["height", "身高", "number"]);
table.insertColumn(1, "height", "身高", "number"); |
JavaScript 代码 |
// 在索引为 1 的位置插入一列的示例
table.insertColumn(1, new mx.datas.DataColumn({type :"number", label :"身高", id:"height"}));
table.insertColumn(1, {id:"height", label :"身高", type :"number"});
table.insertColumn(1, ["height", "身高", "number"]);
table.insertColumn(1, "height", "身高", "number"); |
JavaScript 代码 |
// 示例 1
table.insertColumns(1, [
{id:"name", label:"名字", type:"string"},
{id:"age", label:"年龄", type:"number"},
new mx.datas.DataColumn({id:"sex", label:"性别", type:"number"}),
{id:"birthday", label:"生日", type:"Date", pattern:"yyyy.MM.dd"}
]);
// 示例 2
table.insertColumns(1, [
["name", "名字", "string"],
["age", "年龄", "number"],
["sex", "性别","number"}],
["birthday", "生日","Date", "yyyy-MM-dd"]
]); |
JavaScript 代码 |
// 在索引为 1 的位置插入一空行的示例
table.insertRow(1);
// 在索引为 1 的位置插入一行的示例
table.insertRow(1,
{cells:[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]}
);
table.insertRow(1,
new mx.datas.DataRow({cells:[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]})
);
table.insertRow(1, {value:"张三"}, {value:23},{value:"1",formattedValue:"男"}, {value:"1985-1-1"});
table.insertRow(1, [{v:"张三"}, {v:23},{v:"1",f:"男"}, {v:"1985-1-1"}]);
table.insertRow(1, ["张三", 23,"男", "1985-1-1"]); |
JavaScript 代码 |
// 在下标为 1 的地方增加 3 空行
table.insertRows(1, 3);
// 参数为对象时的示例
table.insertRows(1, [
new mx.datas.DataRow({cells:[{value:"张三"}, {value:23},{value:"1",formattedValue:"男"}, {value:"1985-1-1"}]}),
new mx.datas.DataRow({cells:[{value:"李四"}, {value:24},{value:"0",formattedValue:"女"}, {value:"1984-1-1"}]}),
new mx.datas.DataRow({cells:[{value:"王五"}, {value:25},{value:"1",formattedValue:"男"}, {value:"1988-1-1"}]})
]);
// p_rows 为json对象时的示例
table.insertRows(1, [
{cells:[{value:"张三"}, {value:23},{value:"1", formattedValue:"男"}, {value:"1985-1-1"}]},
[{value:"李四"}, {value:24},{value:"0",formattedValue:"女"}, {value:"1984-1-1"}],
[{value:"王五"}, {value:25},{value:"1",formattedValue:"男"}, {value:"1988-1-1"}]
]);
table.insertRows(1, [
[{v:"张三"}, {v:23},{v:"1",f:"男"}, {v:"1985-1-1"}],
[{v:"李四"}, {v:24},{v:"0",f:"女"},{v:"1984-1-1"}],
[{v:"王五"}, {v:25},{v:"1",f:"男"}, {v:"1988-1-1"}]
]);
table.insertRows(1, [
["张三", 23,"男", "1985-1-1"],
["李四", 24,"女","1984-1-1"],
["王五", 25,"男", "1988-1-1"]
]); |
JavaScript 代码 |
//移除索引为 1 的列
table.removeColumn(1);
//移除 id 为 “NAME” 的列
table.removeColumn(“NAME”);
//移除列 dataColumn
table.removeColumn(dataColumn); |
JavaScript 代码 |
//从 索引 1 位置开始移除 2 列
table.removeColumns(1,2);
//从 列 id 为 “NAME”,“SEX”,的列
table.removeColumns(["NAME","SEX"]);
//从 列 column, column2, column3
table.removeColumns([column, column2, column3]);
// 移除所有列
table.removeColumns(-1); |
JavaScript 代码 |
//移除索引为 1 的行
table.removeRows(1); |
JavaScript 代码 |
//从 索引 1 位置开始移除 2 行
table.removeRows(1,2);
// 移除所有行
table.removeRows(-1); |