1.  数据绑定：
   (1)绑定到datagrid(webapp)

if(emps.loadall())
{
     dvemps = emps.defaultview;
     dgemps.datasource = dvemps;
     dgemps.databind();
}

  (2)绑定到combobox(winapp)

//get data
emps.query.addresultcolumn(employees.columnnames.employeeid);
emps.query.addresultcolumn(employees.columnnames.lastname);
emps.query.addorderby(employees.columnnames.lastname,
whereparameter.dir.asc);
emps.query.load();
//bind to combobox
cmbemployees.displaymember = employees.columnnames.lastname;
cmbemployees.valuemember = employees.columnnames.employeeid;
cmbemployees.datasource = emps.defaultview;

  (3)绑定到dropdownlist(webapp)

 //get data
 emps.query.addresultcolumn(employees.columnnames.employeeid);
 emps.query.addresultcolumn(employees.columnnames.lastname);
 emps.query.addorderby(employees.columnnames.lastname,
 whereparameter.dir.asc);
 emps.query.load();
 //bind to drop-down list
 ddlemployees.datasource = emps.defaultview;
 ddlemployees.datatextfield = employees.columnnames.lastname;
 ddlemployees.datavaluefield = employees.columnnames.employeeid;
 ddlemployees.databind();

2.  特殊函数：执行自定义存储过程和sql语句

examples:
（1）loadfromsql:(从数据库中检索并返回检索结果集,查询结果保存到datatable中)

listdictionary parms = new listdictionary();
parms.add("@parametername1", value1);
parms.add("@parametername2", value2);
parms.add……
if(this.loadfromsql("proc_getspecialemployee", parms))
{
  ...
}

（2）loadfromsqlnoexec:(执行无结果集的存储过程，返回受影响的行数)
        int nbrofchecks = this.loadfromsqlnoexec("proc_calculatepayroll");
        例如：删除一条记录，doodad提供的文档中的方法是：先loadbyprimarykey,再markasdeleted,最后再save进数据库；这个过程要对数据库进行两次操作。实际上，我们可以只操作一次数据库(直接用doodads模板生成的存储过程)，而不用先load。
 listdictionary parms = new listdictionary();
 parms.add("@id", empid);
 int effectline = this.loadfromsqlnoexec("proc_employeedelete",parms);

（3）loadfromsqlreader:(返回sqldatareader)
 sqldatareader rdr = this.loadfromsqlreader("proc_getspecialemployee", parms) as sqldatareader;

（4）loadfromsqlscalar:(返回单个值)
 datetime earliesthiredate;
 listdictionary parms = new listdictionary();
 parms.add("@active", 1);
 earliesthiredate = convert.todatetime(this.loadfromsqlscalar("getearliesthiredate",parms));

（5）loadfromrawsql:
 this.loadfromrawsql("select min(em_hiredate) from temployees

[1] [2] 下一页

where em_active = {0}","1");

3.  事务处理:

transactionmgr tx = transactionmgr.threadtransactionmgr();
try
{
    employees emps = new employees();
    emps.addnew();
    emps.firstname = "jimmy";
    emps.lastname = "doe";
    products prds = new products();
    prds.addnew();
    prds.productname = " lunch box ";
    prds.discontinued = false;
    tx.begintransaction();
    emps.save();
    prds.save();
    tx.committransaction();
}
catch(exception ex)
{
    tx.rollbacktransaction();
    transactionmgr.threadtransactionmgrreset();
}

上一页  [1] [2]