public void OnSreach(Object sender, EventArgs e) { DataAdapter c; String Year; myStrat = int.Parse(this.startYear.Text); Year = this.endYear.Text; useYear = int.Parse(Year); //数据库绑定 DataSet b = new DataSet(); datacontrol a = (datacontrol)Session["database"]; c = a.avaliableCar(myStrat, useYear); try { c.Fill(b); this.carGrid.DataSource = b; this.carGrid.DataBind(); } catch (System.Data.SQLite.SQLiteException) { Response.Write("<script>alert('没有合适车辆');</script>"); } }
public static void Main(string[] argvs) { datacontrol a=new datacontrol("asd.data"); a.insert("H12345",2013,true,true,true); a.insert("C12345",2013,true,true,true); a.insert("J12345",2013,false,true,true); a.insert("G12345",2011,true,true,true); a.insert("M123","123",true,"Amy","19950125","1234"); a.insert("M456","456",false,"Tom","19941212","5678"); a.insert("M789","789",false,"kitty","19941212","0789"); a.insert("H12345","M123",20101020,20151020,true,true); a.insert("G12345","M456",20121020,20151020,false,true); a.insert("H12345","M123",20151020,20171020,false,true); a.insert("G12345","M789",20151020,20171020,true,true); a.avaliableCar(2020); a.insert("J12345","H12345",20121010,20151010,true,true); Console.Read(); }
public static void Main(string[] argvs) { datacontrol a = new datacontrol("asd.data"); a.insert("H12345", 2013, true, true, true); a.insert("C12345", 2013, true, true, true); a.insert("J12345", 2013, false, true, true); a.insert("G12345", 2011, true, true, true); a.insert("M123", "123", true, "Amy", "19950125", "1234"); a.insert("M456", "456", false, "Tom", "19941212", "5678"); a.insert("M789", "789", false, "kitty", "19941212", "0789"); a.insert("H12345", "M123", 20101020, 20151020, true, true); a.insert("G12345", "M456", 20121020, 20151020, false, true); a.insert("H12345", "M123", 20151020, 20171020, false, true); a.insert("G12345", "M789", 20151020, 20171020, true, true); a.avaliableCar(2020); a.insert("J12345", "H12345", 20121010, 20151010, true, true); Console.Read(); }