public ExecuteDataTable ( string sql, |
||
sql | string | 要执行的查询语句 |
parameters | 执行SQL查询语句所需要的参数,参数必须以它们在SQL语句中的顺序为准 | |
리턴 |
/// <summary> /// 执行查询SQL,返回查询结果表 /// </summary> /// <param name="sql">sql语句</param> /// <param name="parameters">参数</param> /// <returns>查询结果表</returns> public DataTable DataTableQuery(string sql, SQLiteParameter[] parameters) { DataTable data = new DataTable(); try { SQLiteDBHelper dbHelper = new SQLiteDBHelper(); data = dbHelper.ExecuteDataTable(sql, parameters); } catch { } return(data); }
/// <summary> /// 执行查询SQL,返回查询结果的首行首列 /// </summary> /// <param name="sql">sql语句</param> /// <param name="parameters">参数</param> /// <returns></returns> public string StringQuery(string sql, SQLiteParameter[] parameters) { string result = string.Empty; try { SQLiteDBHelper dbHelper = new SQLiteDBHelper(); DataTable data = dbHelper.ExecuteDataTable(sql, parameters); if (data != null && data.Rows.Count > 0) { result = data.Rows[0][0].ToString(); } } catch { } return(result); }