SqliteÎÞ·¨¸üÐÂ
C# code:
public static bool UpdateFriendUrl(int id, string cnName, string jpName, string logoUrl, string site, int order)
{
string sql = "update FriendUrl set SiteNameCN=@SiteNameCN,SiteNameJP=@SiteNameJP,SiteLogo=@SiteLogo,SiteUrl=@SiteUrl,SiteSort=@SiteSort where ID=@ID";
using (SQLiteConnection cn = new SQLiteConnection(ConnString))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
cn.Open();
cmd.Connection = cn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ID", DbType.Int32).Value = id;
cmd.Parameters.Add("@SiteNameCN", DbType.String, 100).Value = cnName;
cmd.Parameters.Add("@SiteNameJP", DbType.String, 100).Value = jpName;
cmd.Parameters.Add("@SiteLogo", DbType.String, 100).Value = logoUrl;
cmd.Parameters.Add("@SiteUrl", DbType.String, 100).Value = site;
cmd.Parameters.Add("@SiteSort", DbType.Int32).Value = order;
try
{
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¡
sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.
Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string
ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......
ÎÒÖªµÀ´ó¼Ò¶¼ËµÊÇ64λϵͳϲ»ÄÜÓÃ32λµÄsyste.sqlite.dll¡£Õâ¸öÎÒÒѾ»»ÁË
VS2008ÖÐÔËÐж¼Ã»ÎÊÌ⣨ͬһϵͳÏ£©
Ò»·Åµ½IISÖоͱ¨´í£º
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°System.Data.SQLite¡±»òËüµÄijһ¸öÒÀÀµÏî¡£ÊÔͼ¼ÓÔØ¸ ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
ÇëÎʸ÷λ´ó¸ç,ËÓÐÉú³É·ÃÎÊsqliteÊý¾Ý¿âµÄ´úÂëÉú³ÉÆ÷,·üÍû´ó¼Ò°ïæ...
СµÜ¼±ÓÃ
wuyq11
(ÈËÉúÈçÃÎ) ÄúºÃ,wuyq11
UcfarDBAÊÇÔõôʹÓõÄ,СµÜ¿´µ½ÀïÃæÖ»ÓÐcstÎļþ,Ó¦¸ÃÊÇÄ£°å,ÕâЩģ°åÒªÔõÃ´Ê ......