1、SQLite数据库定义为日期类型

2、XPtable中日期字段定义与显示

 //显示时间表columnModel1.Columns.Clear();columnModel1.Columns.Add(new NumberColumn("id", 30));NumberColumn numberColumn = new NumberColumn("次数", 50);numberColumn.Maximum = 10000;columnModel1.Columns.Add(numberColumn);NumberColumn numberColumn2 = new NumberColumn("公里", 80);numberColumn2.Maximum = 9999999;columnModel1.Columns.Add(numberColumn2);DateTimeColumn dateTimeColumn = new DateTimeColumn("日期", 120);dateTimeColumn.CustomDateTimeFormat = "yyyy.MM.dd";columnModel1.Columns.Add(dateTimeColumn);tableModel1.Rows.Clear();foreach (var item in FormHome.db.Times.Where(p => p.carid == one.id).OrderBy(p => p.times)){XPTable.Models.Row r = new XPTable.Models.Row();tableModel1.Rows.Add(r);r.Cells.Add(new XPTable.Models.Cell(item.id));r.Cells.Add(new XPTable.Models.Cell(item.times));r.Cells.Add(new XPTable.Models.Cell(item.km));r.Cells.Add(new XPTable.Models.Cell(item.zdate.Value)); }

3、保存到数据库中

        // 时间编辑停止:id,次数，公里，日期private void table1_EditingStopped(object sender, XPTable.Events.CellEditEventArgs e){var tmp = FormHome.db.Times.Where(c => c.id == MT.i(tableModel1.Rows[e.Row].Cells[0].Data)).FirstOrDefault();tmp.carid = one.id;                tmp.times = MT.i(tableModel1.Rows[e.Row].Cells[1].Data);tmp.km = MT.i(tableModel1.Rows[e.Row].Cells[2].Data);tmp.zdate = MT.ddd(tableModel1.Rows[e.Row].Cells[3].Data);FormHome.db.SaveChanges();FormHome.downtxt.Text = "数据已经保存！";   }

4、自己的函数处理一下转换

public static int i(object x1){return Convert.ToInt32(x1);} public static string s(object x1){return Convert.ToString(x1);}public static Decimal d(object x1){return Convert.ToDecimal(x1);}public static DateTime ddd(object x1){return Convert.ToDateTime(x1);}