sqliteÊý¾Ý¿â²»ÄÜÁ¬Ðø´æÈëÊý¾ÝµÄÎÊÌâ
ÎÒÓÃevc±àдµÄ³ÌÐò£¬½«¶Ô»°¿òÖеÄÊý¾Ý´æÈëÊý¾Ý¿â£¬µÚÒ»´Î¿ÉÒÔ´æÈ룬²»¹ýµÚ¶þ´ÎÊäÈëµÄÊý¾Ý²»ÄÜ´æÈëµ½Êý¾Ý¿âÖС£
ÏÂÃæÊÇÎҵijÌÐò
UpdateData(TRUE); // TODO: Add your control notification handler code here
if (!CheckVaild())//¼ì²éÊäÈëÐÅÏ¢ÊÇ·ñÍêÕû
{
AfxMessageBox(L"ÊäÈëÐÅÏ¢²»ÍêÕû!");
return;
}
int result;
CString str;
char *sql="INSERT INTO\"faultcode\" VALUES(NULL,'a','a','a','a'); ";
str="INSERT INTO faultcode VALUES(NULL,'";
str+=m_Snumber;
str+="','";
str+=m_Sname;
str+="','";
str+=m_Sreason;
str+="','";
str+=m_Sstep;
str+="');";
memset(sql, 0,100);
WideCharToMultiByte(CP_ACP, 0, str, -1, sql, 100, NULL, NULL);
str=sql;
RETAILMSG(1, (TEXT("%s \n\r\n"),str));
result=sqlite3_exec( db , sql , 0 , 0 , &zErrMsg);
if(result !=SQLITE_OK)
printf("zErrMsg = %s \n", zErrMsg);
m_Snumber = _T("");
m_Sname = _T("");
m_Sreason = _T("");
m_Sstep = _T("");
UpdateData(FALSE);
AfxMe
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°ÁËÒ»¸ösqlite developer,Ò»¸ö¿ÉÊÓ»¯µÄ¹¤¾ß¡£
½Ó×Å£¬ÎÒÓÖ°²×°ÁËSQLite.NET,²¢ÔÚVSÀïÃæÌí¼ÓºÃÁËdll¡£
ÏÖÔÚ£¬ÎÒÔÚsqlite developerÀï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬¿âÖаüº¬ÎÒ×Ô¼º¶¨ÒåµÄÒ»ÕÅ±í¡£
ÎÊÌ⣺ÈçºÎÊ¹Ó ......
ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿
c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿
linux ÉÏÄÜÔËÐУ㣡¡?
Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë
http://www.sqlite.org/downl ......
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
ÏÖÔÚÏë×öÒ»¸ö½øÏú´æ,¿ÉÄÜ»áÓÐ20ÈËͬʱһÆðÓÃ
²»ÖªµÀµ½ÊÇÑ¡Ôñ sqlite »¹ÊÇ access
´ó¼Ò¸ø¸øÒâ¼û°É
»¹ÊÇÓÃaccess°É£¬ÒòΪÄã¿Ï¶¨ÊÇÓÃ.net¿ª·¢£¬³öÁËʲôÎÊÌâµÄ»°ºÃ½â¾öһЩ¡£
Èç¹ûÓÃsqlite×ÊÁÏÏà¶Ô±È½ÏÉÙ¡£
²»¹ýÌý ......