写一个Insert语句拼装,const string AddSql = "insert into CTM_INFORMATION{0} ({1}) values ({2})";开头是这样吧?
下面呢?实体类是:
public class CTM_INFORMATION
{
public int CUSTOMERID { get; set; }
public string USERPWD { get; set; }
public string LOGINNAME { get; set; }
public string USERNAME { get; set; }
public string TEL { get; set; }
public string MOBILETEL { get; set; }
public string IDCARD { get; set; }
public int CARDTYPE { get; set; }
public string EMAIL { get; set; }
public DateTime BIRTHDATE { get; set; }
public int SEX { get; set; }
public string PROVINCEID { get; set; }
public string CITYID { get; set; }
public string ADDRESS { get; set; }
public string POSTCODE { get; set; }
public string DEGREE { get; set; }
public string INCOME { get; set; }
public string JOB { get; set; }
public string POSITION { get; set; }
public DateTime REGTIME { get; set; }
public DateTime LOGINTIME { get; set; }
public string CID { get; set; }
public int EMAILFLAG { get; set; }
public string PWDQUESTION { get; set; }
public string PWDANSWER { get; set; }
public string ACTIVECODE { get; set; }
}
下面呢?实体类是:
public class CTM_INFORMATION
{
public int CUSTOMERID { get; set; }
public string USERPWD { get; set; }
public string LOGINNAME { get; set; }
public string USERNAME { get; set; }
public string TEL { get; set; }
public string MOBILETEL { get; set; }
public string IDCARD { get; set; }
public int CARDTYPE { get; set; }
public string EMAIL { get; set; }
public DateTime BIRTHDATE { get; set; }
public int SEX { get; set; }
public string PROVINCEID { get; set; }
public string CITYID { get; set; }
public string ADDRESS { get; set; }
public string POSTCODE { get; set; }
public string DEGREE { get; set; }
public string INCOME { get; set; }
public string JOB { get; set; }
public string POSITION { get; set; }
public DateTime REGTIME { get; set; }
public DateTime LOGINTIME { get; set; }
public string CID { get; set; }
public int EMAILFLAG { get; set; }
public string PWDQUESTION { get; set; }
public string PWDANSWER { get; set; }
public string ACTIVECODE { get; set; }
}
解决方案 »
- 用Reflector反编译后如何重新生成dll?
- 怎样生成一个19位的唯一的id
- 页面有html 控件的button和webform的button怎么证焦点都在html的button上
- 借此版问winform 怎么判断HttpWebRequest 下载回来的图片是否损坏的呢?求思路,求思路
- gridview能实现给每条记录显示为一个超链接指向对应的详细信息吗?
- 如何注册Javascript脚本?急急急急!!!!各位高手拜托了!
- .net开发的网站,不定时出现以下错误Internet explorer无法打开Internet站点,XXXX.已经终止操作
- 浅谈服务器的压力解决方案
- CR FOR VS2010
- 怎么老是说“column”参数不能为空
- C# Emit问题->DataReader 转Entity....
- 关于windows消息队列
下面写是实体类。
语句的拼装该怎么写啊?
有没有详细一点点的啊
我昨天才第一次开Oracle啊!
动软生成的,
就是那个sql语句里面加insert into CTM_INFORMATION{0} ({1}) values ({2})占位符啊
然后再怎么搞呢?
就是不知道后面怎么写~。~
public void AddTest(Models.CTM_INFORMATION model)
{
string str_Cmd = "insert into CTM_INFORMATION (CUSTOMERID,USERPWD,LOGINNAME,USERNAME,TEL,MOBILETEL,IDCARD,CARDTYPE,EMAIL,BIRTHDATE,SEX,PROVINCEID,CITYID,ADDRESS,POSTCODE,DEGREE,INCOME,JOB,POSITION,REGTIME,LOGINTIME,CID,EMAILFLAG,PWDQUESTION,PWDANSWER,ACTIVECODE)"
+"values ('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24')";
string str = "insert into CTM_INFORMATION (SEQ_CTM_INFORMATION.NEXTVAL,USERPWD,LOGINNAME,USERNAME,TEL,MOBILETEL,IDCARD,CARDTYPE,EMAIL,BIRTHDATE,SEX,PROVINCEID,CITYID,ADDRESS,POSTCODE,DEGREE,INCOME,JOB,POSITION,REGTIME,LOGINTIME,CID,EMAILFLAG,PWDQUESTION,PWDANSWER,ACTIVECODE)";
str += "values(";
str += "'" + model.USERPWD + "'";
str += "'" + model.LOGINNAME + "'";
str += "'" + model.USERNAME + "'";
str += "'" + model.TEL + "'";
str += "'" + model.MOBILETEL + "'";
str += "'" + model.IDCARD + "'";
str += "'" + model.CARDTYPE + "'";
str += "'" + model.EMAIL + "'";
str += "'" + model.BIRTHDATE + "'";
str += "'" + model.SEX + "'";
str += "'" + model.PROVINCEID + "'";
str += "'" + model.CITYID + "'";
str += "'" + model.ADDRESS + "'";
str += "'" + model.POSTCODE + "'";
str += "'" + model.DEGREE + "'";
str += "'" + model.INCOME + "'";
str += "'" + model.JOB + "'";
str += "'" + model.POSITION + "'";
str += "'" + model.REGTIME + "'";
str += "'" + model.LOGINTIME + "'";
str += "'" + model.CID + "'";
str += "'" + model.EMAILFLAG + "'";
str += "'" + model.PWDQUESTION + "'";
str += "'" + model.PWDANSWER + "'";
str += "'" + model.ACTIVECODE + "')";
try
{
}
catch(Exception e)
{
Console.WriteLine(e.Message);
} }
现在又不知道try里面怎么写了