·您现在的位置： 云翼网络 >> 文章中心 >> 网站建设 >> 网站建设开发 >> ASP.NET网站开发 >> asp.net(C#)写SQL语句技巧

【如有意向点此提交需求】关于我们

asp.net(C#)写SQL语句技巧

作者：佚名      ASP.NET网站开发编辑：admin      更新时间：2022-07-23

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() + ")";