Menu:

Recent Entries

Categories

Archives

Links

Blogs
- Dflying's Night
- David's Untitled Life
- Dflying's Blog in Chinese

This blog is hosted by DreamHost!

Syndicate

RSS 0.90
RSS 1.0
RSS 2.0
Atom 0.3

Introduction to Atlas DataTable

 Dflying | 15 March, 2006 05:50

Atlas 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. 1. blueoxygen  |  03/15,2006 at 18:18

    Atlas really simplify AJAX development.Cool.

  2. 2. chenzhitong  |  03/29,2006 at 19:12

    Very Good!I Like!

  3. 3. anushka  |  03/07,2008 at 03:57

    thanks. i learnt a lot

  4. 4. rdyiwtzt  |  11/18,2008 at 17:38

    wmkbxuna [URL=http://orcydruw.com]letvsdhe[/URL] pyufrbqp http://tbgbbuqn.com pgjycdyx swxynvhs

Leave a Reply

Auth Image