您的位置:首页 > 博客中心 > 数据库 >

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

时间:2022-03-13 23:49

/*添加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 = "update EKECMS_EKETEAM set ZDMJ=‘" + Request.Form["h1"].ToString() + "‘";
sql += ",jglx=‘" + Request.Form["h2"].ToString() + "‘";
sql +=" where pid in (" + Request.Form["id"].ToString() + ")";

热门排行

今日推荐

热门手游