(C#)写SQL语句技巧

王朝学院·作者佚名  2016-05-21
窄屏简体版  字體: 小  |  中  |  大  |  超大  

asp.net(C#)写SQL语句技巧/*添加SQL*/string fields = "";string values = "";fields += "xm"; values += "'" + Request.Form["xm"].ToString() + "'";fields += ",xb"; values += ",'" + Request.Form["xb"].ToString() + "'";fields += ",sfz"; values += ",'" + Request.Form["sfz"].ToString() + "'";fields += ",dzyj"; values += ",'" + Request.Form["dzyj"].ToString() + "'";sql = "insert into EKECMS_EKETEAM (" + fields + ") values (" + values + ")";

/*修改SQL*/sql = "updateEKECMS_EKETEAM set ZDMJ='" + Request.Form["h1"].ToString() + "'";sql += ",jglx='" + Request.Form["h2"].ToString() + "'";sql +=" where pid in (" + Request.Form["id"].ToString() + ")";

 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
© 2005- 王朝網路 版權所有 導航