C# (CSharp) DbhelperSQLite.ExecuteSql Examples

Example #1

File: Sql_Service.cs Project: ZhuangQT/Modify-IP

        public static void InsertIP(string IP, string subnet, string gateway, string dns)
        {
            string sql = string.Format(@"INSERT INTO IP_Save (
	IP,
	subnet,
	gateway,
	dns
)
VALUES
	('{0}', '{1}', '{2}','{3}')"    , IP, subnet, gateway, dns);

            DbhelperSQLite.ExecuteSql(sql);
        }

Example #2

File: Sql_Service.cs Project: ZhuangQT/Modify-IP

        public static void DeletIP(string ID)
        {
            string sql = string.Format(@"DELETE from IP_Save where id='{0}'", ID);

            DbhelperSQLite.ExecuteSql(sql);
        }