// // GET: /SQLiteDe/ public ActionResult Index() { HCLUtility.MyJsonResultMessageEntity jms = new HCLUtility.MyJsonResultMessageEntity(); jms.Message = "成功"; jms.IsSuccess = true; //ViewBag.Message = JsonConvert.SerializeObject(jms); #region MyRegion //string strSQL = string.Format("INSERT INTO customers VALUES({0},'{1}','{2}','{3}','{4}','{5}',{6})", 8, "Joe", "上海", "潜在客户", DateTime.Now, "admin", 9); //string message = "失败"; //try //{ // int i = SQLiteHelper2.ExecuteQuery(strSQL, CommandType.Text); // if (i > 0) // { // message = "成功"; // } //} //catch (Exception ex) //{ // message = ex.ToString(); //} //ViewBag.Message = message + ""; // SQLiteConnection conn = null; //string dbPath = "Data Source ="+Server.MapPath("App_Data/test.db"); //conn = new SQLiteConnection(dbPath);//创建数据库实例,指定文件位置 //conn.Open();//打开数据库,若文件不存在会自动创建 // string sql = "CREATE TABLE IF NOT EXISTS student(id integer, name varchar(20), sex varchar(2));";//建表语句 // SQLiteCommand cmdCreateTable = new SQLiteCommand(sql, conn); //cmdCreateTable.ExecuteNonQuery();//如果表不存在,创建数据表 //SQLiteCommand cmdInsert = new SQLiteCommand(conn); // cmdInsert.CommandText = "INSERT INTO student VALUES(1, '小红', '男')";//插入几条数据 // cmdInsert.ExecuteNonQuery(); // cmdInsert.CommandText = "INSERT INTO student VALUES(2, '小李', '女')"; // cmdInsert.ExecuteNonQuery(); // cmdInsert.CommandText = "INSERT INTO student VALUES(3, '小明', '男')"; // cmdInsert.ExecuteNonQuery(); //conn.Close(); #endregion DataSet ds = SQLiteHelper2.ExecuteDataset("select id,name,createdate from demo order by id desc", CommandType.Text); return View(ds); }
// // GET: /SQLiteDe/ public ActionResult Index() { HCLUtility.MyJsonResultMessageEntity jms = new HCLUtility.MyJsonResultMessageEntity(); jms.Message = "成功"; jms.IsSuccess = true; //ViewBag.Message = JsonConvert.SerializeObject(jms); #region MyRegion //string strSQL = string.Format("INSERT INTO customers VALUES({0},'{1}','{2}','{3}','{4}','{5}',{6})", 8, "Joe", "上海", "潜在客户", DateTime.Now, "admin", 9); //string message = "失败"; //try //{ // int i = SQLiteHelper2.ExecuteQuery(strSQL, CommandType.Text); // if (i > 0) // { // message = "成功"; // } //} //catch (Exception ex) //{ // message = ex.ToString(); //} //ViewBag.Message = message + ""; // SQLiteConnection conn = null; //string dbPath = "Data Source ="+Server.MapPath("App_Data/test.db"); //conn = new SQLiteConnection(dbPath);//创建数据库实例,指定文件位置 //conn.Open();//打开数据库,若文件不存在会自动创建 // string sql = "CREATE TABLE IF NOT EXISTS student(id integer, name varchar(20), sex varchar(2));";//建表语句 // SQLiteCommand cmdCreateTable = new SQLiteCommand(sql, conn); //cmdCreateTable.ExecuteNonQuery();//如果表不存在,创建数据表 //SQLiteCommand cmdInsert = new SQLiteCommand(conn); // cmdInsert.CommandText = "INSERT INTO student VALUES(1, '小红', '男')";//插入几条数据 // cmdInsert.ExecuteNonQuery(); // cmdInsert.CommandText = "INSERT INTO student VALUES(2, '小李', '女')"; // cmdInsert.ExecuteNonQuery(); // cmdInsert.CommandText = "INSERT INTO student VALUES(3, '小明', '男')"; // cmdInsert.ExecuteNonQuery(); //conn.Close(); #endregion DataSet ds = SQLiteHelper2.ExecuteDataset("select id,name,createdate from demo order by id desc", CommandType.Text); return(View(ds)); }