ÇëÎÊ ÔÚC#ÖÐ ¿ÉÒÔÖ±½ÓÓà insert into table (column1,cloumn2,....) values (values1,values2,....)²åÈëORACLE Êý¾Ý¿âÂð``` update ͬÑù¿ÉÒÔÂ𣿣¿
û°ì·¨``ÒÔǰûÓùý`û½Ó´¥¹ý`ûѧ¹ý``ÏÖÔÚÊÇʼ±ÂíÐÐÌÁÙʱ±§·ð½ÅÀ²``¸÷λ¸ßÊÖÖªµÀµÄ˵ÏÂ
¾ßÌåÔõôÑùÄØ``¿ÉÒÔ·¢Ò»Ð©¸ñʽ³öÀ´Âð£¿
ÓÐÈËÂð£¿
T-SQLÓï¾ä»ù±¾¶¼ÊÇͨÓõģ¬
µ«ÄãҪ˵Çå³þµØÎÊÌ⣬
ÄãÕâ¸öÎʵúÜÄ£ºý£¡
.NET³ÌÐòÁ¬½ÓORACLEÊÇ¿ÉÒԵģ¬
²Ù×÷Êý¾Ý¸úÁ¬½ÓSQL SERVERÊÇÒ»ÑùµÄ¡£
T-SQLÓï¾ä»ù±¾¶¼ÊÇͨÓÃµÄ Ã»ÓÐʲô̫´óµÄÇø±ð
SQL code:
sql = "INSERT INTO ticket(ticketnum,ticketnumext,subject,comments,datetime,domain,site,sector,channel,creatorteam,destinationteam,language,"
+"creator,skill,treatingagent,status,type,customer,dossiernum,callednum) VALUES (ticket_uid.nextval, '" +
ticNumExtBox.Text + "','" +
subjectBox.Text + "','" +
commentBox.Text + "','"+
dateTimePicker1.Value + "','" +
domainBox.Text + "','" +
siteBox.Text + "','" +
sectorBox.Text + "','" +
channelCom.Text + "','" +
cTBox.Text + "',
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......