DesktopHelper.DB.SqlAction.DataTableQuery C# (CSharp) Method

DataTableQuery() public method

执行查询SQL,返回查询结果表
public DataTableQuery ( string sql, SQLiteParameter parameters ) : DataTable
sql string sql语句
parameters System.Data.SQLite.SQLiteParameter 参数
return System.Data.DataTable
        public DataTable DataTableQuery(string sql, SQLiteParameter[] parameters)
        {
            DataTable data = new DataTable();
            try
            {
                SQLiteDBHelper dbHelper = new SQLiteDBHelper();
                data = dbHelper.ExecuteDataTable(sql, parameters);
            }
            catch
            {
            }
            return data;
        }

Usage Example

Exemplo n.º 1
0
 /// <summary>
 /// 获取固定网址数据
 /// </summary>
 /// <returns></returns>
 public DataTable GetFixedWebsite()
 {
     DataTable data = new DataTable();
     try
     {
         string sqlString = @"select *  from t_website order by WebOrder";
         SqlAction action = new SqlAction();
         data = action.DataTableQuery(sqlString, null);
     }
     catch
     {
     }
     return data;
 }
All Usage Examples Of DesktopHelper.DB.SqlAction::DataTableQuery