public StringQuery ( string sql, |
||
sql | string | sql语句 |
parameters | 参数 | |
리턴 | string |
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;
}
public string GetDefaultSearch() { string result = string.Empty; try { string sqlString = @"select Value from t_config where Name = 'DefaultSearch'"; SqlAction action = new SqlAction(); result = action.StringQuery(sqlString, null); } catch { } return result; }