Example #1
0
        public DataTable select(string sql, HAESQLiteVO vo)
        {
            DataTable dt = new DataTable();

            try
            {
                conn.Open();
                sqlCmd             = conn.CreateCommand();
                sqlCmd.CommandText = sql;
                string columnName = string.Empty;
                for (int idx = 0; idx < vo.size(); idx++)
                {
                    columnName = vo.getKeys(idx);
                    sqlCmd.Parameters.AddWithValue("@" + columnName, vo.get(columnName));
                }
                SQLiteDataReader reader = sqlCmd.ExecuteReader();
                dt.Load(reader);
            }
            catch
            {
            }
            finally
            {
                conn.Close();
            }
            return(dt);
        }
Example #2
0
        public int executeQuery(string sql, HAESQLiteVO vo)
        {
            int exeCnt = 0;

            try
            {
                conn.Open();
                sqlCmd             = conn.CreateCommand();
                sqlCmd.CommandText = sql;
                string columnName = string.Empty;
                for (int idx = 0; idx < vo.size(); idx++)
                {
                    columnName = vo.getKeys(idx);
                    sqlCmd.Parameters.AddWithValue("@" + columnName, vo.get(columnName));
                }
                exeCnt = sqlCmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
            }
            finally
            {
                conn.Close();
            }
            return(exeCnt);
        }