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

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µÄÇë½øÀ´£¡£¡£¡£¡£¡

´ó¼ÒºÃ£¡
  sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.

Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string

ÄãµÄ´úÂëÊÇʲô£¿
double sqlite3_column_double(sqli ......

Çë½ÌʹÓÃTree¿Ø¼þºÍSQLiteÊý¾Ý¿âµÄÎÊÌâ

ÎÒÏëÒª½«sqliteÊý¾Ý¿âÖеÄÊý¾Ý£¬ÒÔÊ÷¿Ø¼þµÄÐÎʽ¶Á³ö£¬²¢ÇÒÏÔʾÔÚ¶Ô»°¿òÉÏÃæ£¬²»ÖªµÀÔõô×ö£¬À´Çë½Ìһϡ£
ps£º¿´µ½ÓÐʹÓÃÊ÷¿Ø¼þºÍaccessµÄ£¬ÀïÃæÓÐÊý¾Ý¿âÒýÇæÀ´Á¬½ÓÊý¾Ý¿âºÍ³ÌÐò£¬ÎÒ²»ÖªµÀSQLiteÈçºÎÓë³ÌÐòÁ¬½ÓÆð ......

SQLiteÈ¡ÕûÊýº¯ÊýÊÇÄĸö£¿

¸üÐÂÓï¾äÖУº
UPDATE sc SET AA=INT(BB)
ÎÒÏëÈÃAAµÃµ½BBµÄÕûÊýÖµ¡£¿ÉÊÇÔËÐб¨´í¡£
²»ÖªµÀSQLiteÏ ȡÕûÊý²¿·ÖµÄº¯ÊýÊÇÄĸö£¿£¨ËÄÉáÎåÈëµÄº¯ÊýÓÖÊÇÄĸö£¿£©¡£
Èç¹ûÖªµÀ»¹ÓÐÆäËûº¯ÊýÇëÒ»²¢¸æÖª£¬Ð»Ð»¡£

ROUND
......

SQLiteÖÐÎÄÂÒÂëÎÊÌâ

ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ