DATA_EMG_test_170310

基于C#的数据库SQLite的一些读取和写入的操作方法。包含数据库操作语句。(Some reading and writing methods of the database SQLite based on C#. The database operation statement is included.)

以G列分成多个工作表(以宏运行VBA) (Sub aa() Dim a As Integer, b As Integer, c As Integer, sh As Worksheet For a = 2 To [g65536].End(3).Row If Cells(a, 7) <> Cells(a- 1, 7) Then b = a End If c = Range("g:g").Find(Cells(a, 7), , , , , xlPrevious).Row Set sh = Sheets.Add(, Sheets(Sheets.Count)) sh.Name = Sheets("sheet1").Cells(a, 7).Value With Sheets("Sheet1") Sheets("Sheet1").Range(.Cells(b, 1), .Cells(c, 10)).Copy Destination:=sh.[a2] Sheets("Sheet1").Range("a1:j1").Copy Destination:=sh.[a1] a = c End With Sheets("Sheet1").Select Next End Sub )

一个可以打开 SqlCe 数据库文件, 输入 SQL 进行查询的小工具.(SqlCe client tool.)

Handling null fields in SQL queries

此demo包含vc操作Access数据库的链接、以及增删改查的基本操作，均提供的有接口，方便用户操作，并且提供了一些模糊查询语句供用户参考~~(This demo contains the Access database, the link vc operations, as well as additions or deletions to change the basic operation of search are provided with interfaces, user-friendly operation, and provides a number of fuzzy query for the user' s reference ~ ~)

说明：  此压缩文件包含2002年-2017年200多个地级市资本存量的数据，里面有详细的计算过程与说明。(This document contains the capital stock data of more than 200 cities in 2002-2017, including detailed calculation process and description, which is convenient for scholars to understand and master)

通过引用redis基础类库，实现对redis的读取和写入操作。例子比较初级。(By referring to the redis base class library, we can read and write redis. The example is more elementary.)

这是ACCESS的数据库编程文件，可以容易的用在MFC，VC,DELPH等工程环境(ACCESS ADO DATABASE ,MFC VS2008 AND VS2010)

说明：  小巧的天气预报实时显示系统，采用GDI+技术开发，实现了基本且简单的功能，能在图片上实时显示温度/气温等天气预报情况，并能进行数据的维护更新。小巧的天气预报实时显示系统，采用GDI+技术开发，实现了基本且简单的功能，能在图片上实时显示温度/气温等天气预报情况，并能进行数据的维护更新。(compact real-time weather display system using GDI technology development, achieve the basic and simple functions, in real-time pictures show that the temperature/weather conditions such as temperature, and for the maintenance and update of data. The compact, real-time weather system, using GDI technology development, achieve the basic and simple functions, in real-time pictures show that the temperature/weather conditions such as temperature, and for the maintenance and update of data.)

This is certification dumbs for db2 version 9.