Introduction to Atlas DataTable
Dflying | 15 March, 2006 05:50Atlas provides Web.Data.DataTable control which is just like the behavior of ADO.NET DataTable object and the Atlas Framework can also make the conversion between the two types for you automatically. Here are some common operations on Atlas DataTable.
Get DataTable from server
Server side code in C#:[WebMethod] public DataTable GetDataTable() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("FirstName", typeof(string))); dt.Columns.Add(new DataColumn("LastName", typeof(string))); dt.Columns.Add(new DataColumn("Email", typeof(string))); dt.Rows.Add("Dflying", "Chen", "dflying@dflying.net"); dt.Rows.Add("Someone", "Else", "someone@someone.net "); return dt; }
Client side code in JavaScript:
function getDataTable() { MyWebService.GetDataTable(onComplete); } function onComplete(result) { var dataTable = result; }
Send DataTable to server
Client side code in JavaScript:function sendDataTable() { MyWebService.SendDataTable(myDataTable); }
Server side code in C#:
[WebMethod] public void SendDataTable(DataTable someTable) { DataTable dt = someTable; }
Rows count of DataTable
var nRows = dataTable.length;
Get data in a single cell of DataTable
var data = dataTable.getItem(rowIndex).getProperty(colName);
Add a new row to DataTable
var oRow = { FirstName:'New', LastName:'Row', Email: 'new@new.com' } dataTable.add(oRow);
Update row
dataTable.getItem(rowIndex).setProperty(colName, value);
Delete row
dataTable.remove(dataTable.getItem(rowIndex));
DataTable changed
var hasChanges = dataTable.get_isDirty();
Get updated/inserted/deleted rows
var updatedRows = dataTable.getChanges().updated; var insertedRows = dataTable.getChanges().inserted; var deletedRows = dataTable.getChanges().deleted;
Get columns’ properties
var oCol = dataTable.getColumn(colName); var colName = oCol.get_columnName(); var colDataType = oCol.get_dataType(); var colDefaultValue = oCol.get_defaultValue();
Get DataTable from DataSet
DataSet is also an Atlas object, just like the ADO.NET object DataSet which may contain many DataTables.
var dataTable = dataSet[dataTableIndex];
Posted in
Atlas.
Comment: (4).
Trackbacks:(192).
Permalink
«Next post |
Previous post»
Referers
Comments
-
1. blueoxygen | 03/15,2006 at 18:18
Atlas really simplify AJAX development.Cool.
-
2. chenzhitong | 03/29,2006 at 19:12
Very Good!I Like!
-
3. anushka | 03/07,2008 at 03:57
thanks. i learnt a lot
-
4. rdyiwtzt | 11/18,2008 at 17:38
wmkbxuna [URL=http://orcydruw.com]letvsdhe[/URL] pyufrbqp http://tbgbbuqn.com pgjycdyx swxynvhs




