string strsql="Insert Into ShopCompany(userID,password,secpassword,name,flat,qylb,qyjj,linkman,phone,mobilephone,email,address,postcode,yxrq,inputtime,expiretime,note,picture) Values( '0000','0000','0000','0000','0000','0000','0000', '0000','0000','0000','0000','0000','0000','0000','2000-1-1','2000-1-1','0000','0000')";

解决方案 »

  1.   

    string strsql="Insert Into ShopCompany ";
    strsql += "(userID,password,secpassword,name,flat,qylb,qyjj,linkman,phone,";
    strsql += "mobilephone,email,address,postcode,yxrq,inputtime,expiretime,";
    strsql += "note,picture) Values( '0000','0000','0000','0000','0000','0000',";
    strsql += "'0000', '0000','0000','0000','0000','0000','0000','0000',";
    strsql += "'2000-1-1','2000-1-1','0000','0000')";
      

  2.   

    string strsql = @"Insert Into ShopCompany(userID,password,secpassword,
        name,flat,qylb,qyjj,linkman,phone,mobilephone,
        email,address,postcode,yxrq,inputtime,expiretime,
        note,picture) Values( '0000','0000','0000','0000',
        '0000','0000','0000', '0000','0000','0000','0000',
        '0000','0000','0000','2000-1-1','2000-1-1','0000','0000')";