yonghuairuogu的专栏

（1）单表内字段更新update PipeLine set state='0' where Address='33'（2）两个表间单字段关联更新 sql = "update Videos set ID =(select ID from TMPLINETotal where Videos.Lno=TMPLINETotal.Lno ) ";（3）多字段更新 sql = "update ResultRecord ...

FreeSql （十五）查询数据 FreeSql在查询数据下足了功能，链式查询语法、多表查询、表达式函数支持得非常到位。static IFreeSql fsql = new FreeSql.FreeSqlBuilder() .UseConnectionString(FreeSql.DataType.MySql, "Data Source=127.0...

void AddCuix() { try { object oldCmdEcho = Application.GetSystemVariable("CMDECHO"); object oldFileDia = Application.GetSystemVariable("FILEDIA"); string cuifile = System....

private void btn_dwg2dxf_Click(object sender, EventArgs e) { Autodesk.AutoCAD.Interop.AcadApplication acadApp = (Autodesk.AutoCAD.Interop.AcadApplication)Autodesk.AutoCAD.ApplicationServices.Application.AcadAppl...

private void btn_outpdf_Click(object sender, EventArgs e) { AcadDocument doc = null; string destPath = string.Empty; foreach (var file in fileslist) { doc = _app.Documents.Open(file,...

（1）单表内字段更新update PipeLine set state='0' where Address='33'（2）两个表间关联更新在Access数据库中，UPDATE指令不能够含有From语句。因此在多表关联批量更新数据时操作不是那么方便。update table1 as t1,table2 as t2 set t1.name=t2.namewhere t1.id=t...