#region private static method: Read DB, return DataTable /// <summary> /// DB Read returning DataTable on SQL command text /// </summary> /// <param name="SQL">string</param> /// <returns>DataTable</returns> private static DataTable SqlCeReadTable(string cnString, string SQL) { DataTable _dt; try { using (SqlCeConnection _cn = new SqlCeConnection(cnString)) { using (SqlCeCommand _cmd = new SqlCeCommand(SQL, _cn)) { _cmd.CommandType = CommandType.Text; _cn.Open(); using (SqlCeDataReader _dr = _cmd.ExecuteReader(CommandBehavior.CloseConnection)) { _dt = new DataTable(); _dt.Load(_dr); _dr.Close(); } } _cn.Close(); return _dt; } } catch { return null; } } #endregion
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)