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]
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC) '=========================================================================== SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû S ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡ ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖà 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Êý¾Ý¿â£¬ÒªÊµÏÖÒ»¸ö¹ØÁª²éѯ£¬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ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£ ÏÖÓÐÎÊÌâÈçÏ£º 1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......