黑龙江快乐十分

C#中使用SQLite数据库简介(上)

8/3/2015来源:C#应用人气:17115

C#中使用SQLite简介(上)

【sqliteshujuku】

sqliteshiyigekaiyuandeqingliangjidezhuomianxingshujuku,tajiangjihusuoyoushujukuyaosu(baokuodingyi、biao、suoyinheshujubenshen)doubaocunzaiyigedanyidewenjianzhong。sqliteyongcbianxieshixian,tazaineicunxiaohao、wenjiantiji、caozuoxingneng、jiandanxingfangmiandouyoubucuodebiaoxian。sqlitekeyiyunxingzaiduogepingtai,baokuowindows//unixdengzhuliuxitong,haizhichiqianrushixitongruandroidhuowindows mobile。

黑龙江快乐十分sqlitejuyouyixiatezheng:shixianduoshusql92debiaozhun,baokuoshiwu(yuanzixing、yizhixing、gelixinghechijiuxing)、chufaqihedaduoshudefuzachaxun。buduicharuhuozhegengxindeshujujinxingleixingjiancha,birunikeyijiangzifuchuancharudaozhengshuliezhong。

sqlitedangqiandebanben3zhichideshujuleixingyou5zhong:

1.null:kongzhi。

2.integer:youfuhaozhengshu,genjuqingkuangyong1、2、3、4、6huo8gezijiecunchu。

3.real:fudianshu。

4.text:wenben,yongzifujiutf-8、utf-16be huo utf-16lecunchu,shishujukubianmageshierding。

5.blob:erjinzhizijiexulie,yibancunfangbuyiyongshuzhihuowenbenbiaoshideduixiang,danlilunshangkeyicunfangrenhedongxi。

黑龙江快乐十分ruguotongchangyongdeyixieshujukubijiao,keyifaxian,shangmianzhishaoqueshaobitxinghedatetimexing,shishishang,zaisqlitezhong,tongchangbitxingtongzhengshugongyongintegerxing,datetimetongwenbengongyongtextxing。dangintegerleixingziduanzhiwei0huo1shi,sqlitekeyijiangqidangchengbitxing(zhenhuojia)shiyong;dangtextleixingziduanzhifuheyidinggeshishi,sqlitekeyijiangqidangchengdatetimelaishiyong。changyongdekekanchengdatetimedewenbengeshiweiyyyy-mm-ddhuoyyyy-mm-dd hh:mm:ss。zhuyi:zifuchuan"2012-01-09"weihefariqigeshi,erzifuchuan"2012-1-9"、"2012-1-09"he"2012-01-9"beidangchengdatetimedoushibuhefade。

黑龙江快乐十分【c#zhongruhelianjiesqlite】

黑龙江快乐十分zuichangjiandeweisystem.data.sqlite.dllshujufangwenqudong,tashisqlitezhuanmenwei.netshejikaifade,zhiyaoxiangmuzhongyinyonglegaidllwenjianerwuxuanzhuangqitarenhedongxi,tuijianshiyong。



优质网站模板

  • 1
  • 2
  • 3