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]
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½Ãæȥѧϰ
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
CatalogClass cat=new CatalogClass();
cat.Creat(@"provider=microsoft.jet.oledb.4.0;data source="+path+";");
ÓÃÒÔÉÏ´úÂë´´½¨Îļþ³É¹¦ÁË£¬ÕÒµ½Îļþºó´ò¿ª£¬Ìáʾ²»¿Éʶ±ðµÄÊý¾ ......
ÎÒÓÐÒ»¸öUnits±í,½á¹¹Îª:
ID UnistsName
UN1 ºÚÁú½¶«·½Ñ§Ôº
UN2   ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......