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

access¸üÐÂÓï¾ä

string sql = "update leadspeak set images=@images,content=@content,author=@author,title=@title where id=@id";
  OleDbParameter[] para = new OleDbParameter[]{
  new OleDbParameter("@id",leadSpeak.Id),
  new OleDbParameter("@images",leadSpeak.Images),
  new OleDbParameter("@content",leadSpeak.Content),
  new OleDbParameter("@author",leadSpeak.Author),
  new OleDbParameter("@title",leadSpeak.Title)
  };
 int num= DBHelper.ExecuteNonQuery(sql, CommandType.Text, para);

²»±¨´íÎ󣬵«¸üв»ÁË£¬·µ»ØµÄÊÇ0£¬Ð»Ð»£¡£¡
¸Ä³É£¿ÔÙÊÔÊÔ

C# code:
string sql = "update leadspeak set images=?,content=?,author=?,title=? where id=?";
OleDbParameter[] para = new OleDbParameter[]{
new OleDbParameter("?",leadSpeak.Id),
new OleDbParameter("?",leadSpeak.Images),
new OleDbParameter("?",leadSpeak.Content),
new OleDbParameter("?",leadSpeak.Author),
new OleDbParameter("?",leadSpeak.Title)
};
int num= DBHelper.ExecuteNonQuery(sql, CommandType.Text, para);




Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

MFC ACCESSÊý¾Ý¿âµÄÎÊÌâ - VC/MFC / Êý¾Ý¿â

ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......

phpÁ¬½ÓaccessÊý¾Ý¿âʱ³ö´í

$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database.mdb");
$conn-&g ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ