C# code:
private void savBtn_Click(object sender, EventArgs e)
{
string sql;
try
{
conn.Open();
if (ticketNum != "")
{
MessageBox.Show("adasdfasdfsafdsafad ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»ÖªµÀÊǹÜÀíÔ±¡£
Á¬½Ó¼ÓÃÜAccessÊý¾Ý¿âµÄ×Ö·û´®ÉèÖ÷½·¨
AccessÊý¾Ý¿âÔÚһЩСµÄϵͳ³ÌÐòÖо³£Ó ......
ÎÒÏòaccessÀï±£´æµÄÐÅÏ¢Ôõô¹ý¶Îʱ¼ä¾ÍûÓÐÁË£¿ÎªÊ²Ã´Ö»ÊDZ£´æÔÚÁËÄÚ´æÀÎÒÐÂÌí¼ÓµÄÁÐÒ²»áÔÚÒ»¶Îʱ¼äÀïÏûʧ¡£
ÇëÎÊÕâÊÇÔõôһ»ØÊ£¿
¿´¿´ÊÇ·ñδִÐÐCommit£¨£©Ìá½»ÊÂÎñ£¬µ¼Ö»عö£¡
ÊDz»ÊÇÊý¾Ý¿âÌæ»»ÁË
http://topic.csdn.net/u/20100327/10/8e03683c-7c8a-44b4-ab8a-02b5d8a9e7fd.html
......
SQL code:
CREATE PROCEDURE [dbo].[Pr_Plan_TaskSend_GetTaskTypeCodefromTaskSendID]
(@TaskSendID int, @TaskTypeCode VARCHAR(4) output)
C# code:
using (SqlDataReader dataReader = SqlHelper.ExecuteReader(ConnectionString.OmsRead, CommandType.StoredProcedure, commandName, parms))
......
ÇëÎÊ ÔÚC#ÖÐ ¿ÉÒÔÖ±½ÓÓà insert into table (column1,cloumn2,....) values (values1,values2,....)²åÈëORACLE Êý¾Ý¿âÂð``` update ͬÑù¿ÉÒÔÂ𣿣¿
û°ì·¨``ÒÔǰûÓùý`û½Ó´¥¹ý`ûѧ¹ý``ÏÖÔÚÊÇʼ±ÂíÐÐÌÁÙʱ±§·ð½ÅÀ²``¸÷λ¸ßÊÖÖªµÀµÄ˵ÏÂ
¾ßÌåÔõôÑùÄØ``¿ÉÒÔ·¢Ò»Ð©¸ñʽ³öÀ´Âð£¿
ÓÐÈËÂð£¿
T-SQLÓï¾ä»ù±¾¶¼ÊÇÍ ......
<div css="a"> 1</div>
1µÄÄÚÈÝ
<div css="b">1.1</div>
1.1µÄÄÚÈÝ
<div css="b">1.2</div>
1.2µÄÄÚÈÝ
<div css="a">2</div>
1µÄÄÚÈÝ
<div css="b">2.1</div>
2.1µÄÄÚÈÝ
<div css="b&qu ......