示例#1
0
        public DataTable ReadTable()
        {
            return(HelperBase.ReadTable(cmd));

            /*
             *  DataTable dt=new DataTable();
             * DbDataReader reader = null;
             * try
             * {
             *  reader = cmd.ExecuteReader();
             *  int fieldc=reader.FieldCount;
             *  for (int i = 0; i < fieldc; i++)
             *  {
             *      DataColumn dc = new DataColumn(reader.GetName(i), reader.GetFieldType(i));
             *      dt.Columns.Add(dc);
             *  }
             *  while (reader.Read())
             *  {
             *      DataRow dr = dt.NewRow();
             *      for (int i = 0; i < fieldc; i++)
             *      {
             *          dr[i] = reader[i];
             *      }
             *      dt.Rows.Add(dr);
             *  }
             *  return dt;
             * }
             * finally
             * {
             *  if (reader != null) reader.Close();
             * }*/
        }
示例#2
0
        public static DataTable ReadTable(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
        {
            SqlCommand cmd = new SqlCommand();

            SqlServerHelper.PrepareCommand(cmd, connection, (SqlTransaction)null, cmdType, cmdText, commandParameters);
            DataTable dataTable = HelperBase.ReadTable((DbCommand)cmd);

            cmd.Parameters.Clear();
            return(dataTable);
        }
示例#3
0
        public static DataTable ReadTable(OracleConnection connection, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
        {
            OracleCommand cmd = new OracleCommand();

            PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
            DataTable dt = HelperBase.ReadTable(cmd);

            cmd.Parameters.Clear();
            return(dt);
        }
        public static DataTable ReadTable(SqlTransaction transaction, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
        {
            SqlCommand cmd = new SqlCommand();

            PrepareCommand(cmd, transaction.Connection, transaction, cmdType, cmdText, commandParameters);
            DataTable dt = HelperBase.ReadTable(cmd);

            cmd.Parameters.Clear();
            return(dt);
        }
示例#5
0
 public DataTable ReadTable()
 {
     return(HelperBase.ReadTable(this.cmd));
 }