WinCE下的数据源操作以及天气软件的制作(2)

this.textBox1.Text = "中山"; this.bSetCity2.Text = "查询中..."; callWeatherService(); showTodayWeather(); getFromSer();

this.bSetCity2.Text = "中山";

this.button1.Enabled = true; this.button2.Enabled = true; this.button3.Enabled = true; //this.bReadDB.Enabled = true; }

private void bReadDB_Click(object sender, EventArgs e) {

readDB();

this.button1.Enabled = true; this.button2.Enabled = true; this.button3.Enabled = true; }

WinCE下的数据源操作以及天气软件的制作

//---------------------数据库部分

//创建本地数据库

private void setData(string[] hello) {

if (System.IO.File.Exists(dbPath)) System.IO.File.Delete(@dbPath);//删除原文件 if (!System.IO.File.Exists(dbPath)) {

System.Data.SQLite.SQLiteConnection.CreateFile(dbPath);//创建数据库文件

//连接数据库

System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();

conn.ConnectionString = "data source=" + dbPath; conn.Open();

//创建表

System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); string sql = "CREATE TABLE weather(province varchar(20),city varchar(20),date1 varchar(20),tem1 varchar(20),wind1 varchar(20),pic1 varchar(20),date2 varchar(20),tem2 varchar(20),wind2 varchar(20),pic2 varchar(20),date3 varchar(20),tem3 varchar(20),wind3 varchar(20),pic3 varchar(20))"; mandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery();

//插入数据

sql = "INSERT INTO weather VALUES('" + hello[0] + "','" + hello[1] + "','" + hello[2] + "','" + hello[3] + "','" + hello[4] + "','" + hello[5] + "','" + hello[6] + "','" + hello[7] + "','" + hello[8] + "','" + hello[9] + "','" + hello[10] + "','" + hello[11] + "','" + hello[12] + "','" + hello[13] + "');";

mandText = sql; cmd.ExecuteNonQuery();

MessageBox.Show("创建本地数据库:" + dbPath); conn.Close();

System.Data.SQLite.SQLiteConnection.ClearAllPools();

} }

WinCE下的数据源操作以及天气软件的制作

//服务器的数据信息存到数组中 private void getFromSer() {

string[] hello = new string[15]; hello[0] = array[0]; hello[1] = array[1]; hello[2] = array[6]; hello[3] = array[5]; hello[4] = array[7]; hello[5] = array[8]; hello[6] = array[13]; hello[7] = array[12]; hello[8] = array[14]; hello[9] = array[15]; hello[10] = array[18]; hello[11] = array[17]; hello[12] = array[19]; hello[13] = array[20]; setData(hello); }

private void readDB()//读取本地数据库 {

if (System.IO.File.Exists(dbPath)) {

this.bReadDB.Text= "读取ing"; //连接数据库

System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();

conn.ConnectionString = "data source=" + dbPath; conn.Open();

System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.Connection = conn;

//取出数据

string sql = "SELECT * FROM weather"; mandText = sql;

System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader(); StringBuilder sb = new StringBuilder(); while (reader.Read()) {

sb.Append(reader.GetString(0)).Append(":")

WinCE下的数据源操作以及天气软件的制作

.Append(reader.GetString(1)).Append(":") .Append(reader.GetString(2)).Append(":") .Append(reader.GetString(3)).Append(":") .Append(reader.GetString(4)).Append(":") .Append(reader.GetString(5)).Append(":") .Append(reader.GetString(6)).Append(":") .Append(reader.GetString(7)).Append(":") .Append(reader.GetString(8)).Append(":") .Append(reader.GetString(9)).Append(":") .Append(reader.GetString(10)).Append(":") .Append(reader.GetString(11)).Append(":") .Append(reader.GetString(12)).Append(":") .Append(reader.GetString(13)).Append(":"); }

string[] hello = sb.ToString().Split(':');

array[0] = hello[0]; array[1] = hello[1];

array[6] = hello[2]; array[5] = hello[3]; array[7] = hello[4]; array[8] = hello[5];

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说公务员考试WinCE下的数据源操作以及天气软件的制作(2)在线全文阅读。