Exemplo n.º 1
0
        public static ArrayList getTautomerRules(SqlConnection connection, string bingo_schema)
        {
            ArrayList result = new ArrayList();

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = connection;

            cmd.CommandText    = String.Format(@"select id, begg, endd from
                 {0}.TAUTOMER_RULES", bingo_schema);
            cmd.CommandType    = CommandType.Text;
            cmd.CommandTimeout = 3600;

            using (SqlDataReader reader = cmd.ExecuteReader())
            {
                while (reader.Read())
                {
                    TautomerRule rule = new TautomerRule();

                    rule.n   = Convert.ToInt32(reader[0]);
                    rule.beg = Convert.ToString(reader[1]);
                    rule.end = Convert.ToString(reader[2]);

                    result.Add(rule);
                }
            }

            return(result);
        }
Exemplo n.º 2
0
      public static ArrayList getTautomerRules (SqlConnection connection, string bingo_schema)
      {
         ArrayList result = new ArrayList();

         SqlCommand cmd = new SqlCommand();
         cmd.Connection = connection;

         cmd.CommandText = String.Format(@"select id, begg, endd from
                 {0}.TAUTOMER_RULES", bingo_schema);
         cmd.CommandType = CommandType.Text;
         cmd.CommandTimeout = 3600;

         using (SqlDataReader reader = cmd.ExecuteReader())
         {
            while (reader.Read())
            {
               TautomerRule rule = new TautomerRule();

               rule.n = Convert.ToInt32(reader[0]);
               rule.beg = Convert.ToString(reader[1]);
               rule.end = Convert.ToString(reader[2]);

               result.Add(rule);
            }
         }

         return result;
      }