SQLite学习笔记
[
2008/07/07 17:10 | by Else ]
2008/07/07 17:10 | by Else ]
直到学会! 学之前找资料
SQLite的sql
SQLite的sql
ATTACH DATABASE
BEGIN TRANSACTION
comment
COMMIT TRANSACTION
COPY
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DELETE
DETACH DATABASE
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
END TRANSACTION
EXPLAIN
expression
INSERT
ON CONFLICT clause
PRAGMA
REPLACE
ROLLBACK TRANSACTION
SELECT
UPDATE
BEGIN TRANSACTION
comment
COMMIT TRANSACTION
COPY
CREATE INDEX
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DELETE
DETACH DATABASE
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
END TRANSACTION
EXPLAIN
expression
INSERT
ON CONFLICT clause
PRAGMA
REPLACE
ROLLBACK TRANSACTION
SELECT
UPDATE
我的第一个软件写好了!
[ 2008/07/07 12:02 | by Else ]
2008/07/07 12:02 | by Else ]
excel2txt
哈,不知道做了多久了,先高兴,高兴一下!
谢谢:雨竹,ks的哥哥,光武!
哈,不知道做了多久了,先高兴,高兴一下!
谢谢:雨竹,ks的哥哥,光武!
C#判断一个数字的格式的正则有逗号
[ 2008/07/07 11:43 | by Else ]
2008/07/07 11:43 | by Else ]
public string check_number(string num_str)
{
num_str = num_str.Trim();
if (Regex.IsMatch(num_str, @"^\d+(\.\d+)?$|^\d+(\,\d+)+(\.\d+)?$"))
{
this.Nonum = true;
return num_str.Replace(",", "");
}
else
{
this.Nonum = false;
return num_str;
}
}
{
num_str = num_str.Trim();
if (Regex.IsMatch(num_str, @"^\d+(\.\d+)?$|^\d+(\,\d+)+(\.\d+)?$"))
{
this.Nonum = true;
return num_str.Replace(",", "");
}
else
{
this.Nonum = false;
return num_str;
}
}
eg:1.00
123,123
456,123.00
