Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Access 2003 c#? ¿´¿´ÓÐûÓÐÓï·¨´íÎó°¡

string strAdd = "update tb_Note set Note='" + richTextBox1.Text + "' where NoteCode='"+strflag +"'"
¶¼ÊÇÎı¾ÀàÐ͵Ä
ÍêÈ«ÕýÈ·¡£

Äã²»ÊÔһϾÍÌá¸ß

jf

ûÎÊÌâµÄ

µ«ÊÇËû¾Í˵Óï·¨´íÎó°¡


²»Ò»¶¨ÕýÈ·

Èç¹ûrichTextBox1Öк¬Óлá¸Ä±äSQLÓï¾äÓï·¨½á¹¹µÄÌØÊâ×Ö·û¾Í»á±¨´í,±ÈÈ纬Óе¥ÒýºÅ.×îºÃÓòÎÊýÐÎʽ:

OleDbCommand cmd1=new OleDbCommand();
cmd1.Connection=conn1;
cmd1.CommandText="update tb_Note set Note=@Note where NoteCode=@NoteCode";
cmd1.Parameters.Add(new OleDbParameter("@Note",richTextBox1.Text));
cmd1.Parameters.Add(new OleDbParameter("@NoteCode",strflag));
cmd1.ExecuteNonQuery();

ÒýÓÃ
µ«ÊÇËû¾Í˵Óï·¨´íÎó°¡



´íÎóµÄ´úÂëÌù³öÀ´£¬Òª²»Äã¾ÍÓòÎÊý£¬×îºÃÓùý³Ì£¬¿ÉÒÔ·À×¢Èë¡£

Óï¾äûÎÊÌâ,²»¹ýÖµÒªÊÇÓÐNULLÖµ¾Í»á³ö´í

ÓòÎÊý¾Íµ¯³öÁË ¡°ÎÞЧµÄselect update ¡£¡£¡±µÄ¶Ô»°¿ò

ûÊÂ..

SQL code:
NoteÊǹؼü×Ö

¼ÓÉÏ[Note]


¶ÔµÄ

string strAdd = "update tb_Note set Note='" + richTextBox1.Text + "' where NoteCode='"+strflag +"'"£»
×îºóÓиö£»ºÅ¡£ÊÇÕâ¸öÎÊÌâÂð¡£ÄãÊÔÊÔ¡£

10Â¥£¬ºÜ¿ÉÄÜ

²»»áÊÇ[Note]


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

C# Á¬½ÓSQLÊý¾Ý¿â³£ÓõÄÁ¬½Ó×Ö·û´®¸ÃÈçºÎд£¿

£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";   
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......

ACCESSÊý¾Ý¿â¹ØÁª²éѯÎÊÌ⣿

³õÓÃACCESSÊý¾Ý¿â£¬ÒªÊµÏÖÒ»¸ö¹ØÁª²éѯ£¬sqlÓï¾äÈçÏ£ºselect pid,product_Type.name as tid,name,img_url,context,remark from Product join product_Type on product.type_id = product_Type.type_id order by pid ......

Access Êý¾ÝÉýǨµ½ SQLServer2005

ÎÒÔ­±¾ÊÇÓÃACCESSµÄÊý¾Ý¿â£¬ÏÖÔÚ¸ÄÓÃSQLServer2005ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£
ÏÖÓÐÎÊÌâÈçÏ£º

1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô­±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ