//
// 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));
}
public ActionResult Index(FormCollection form)
{
string name = form["name"];
//SQLite date函数datetime('now','localtime') 当前的本地时间
string strSQL = string.Format("INSERT INTO demo VALUES({0},'{1}',{2})", "null", name, "datetime('now','localtime')");
int result = SQLiteHelper2.ExecuteQuery(strSQL, CommandType.Text);
string message = "失败";
if (result > 0)
{
message = "成功";
}
ViewBag.Message = message;
DataSet ds = SQLiteHelper2.ExecuteDataset("select id,name,createdate from demo order by createdate desc", CommandType.Text);
return(View(ds));
}
