program.cs

来自「C#高级编程第6版随书源代码 值得下载」· CS 代码 · 共 28 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;

namespace QuerySystem
{
   class Program
   {
      static void Main()
      {
         string indexerConnectionString = "provider=Search.CollatorDSO.1;EXTENDED PROPERTIES='Application=Windows'";
         OleDbConnection connection = new OleDbConnection(indexerConnectionString);
         connection.Open();
         string sql = "SELECT System.ItemName, System.Title, System.Size FROM SYSTEMINDEX WHERE System.Size > 1024";
         OleDbCommand command = connection.CreateCommand();
         command.CommandText = sql;
         OleDbDataReader reader = command.ExecuteReader();
         while (reader.Read())
         {
            Console.WriteLine("{0} {1} {2}", reader[0], reader[1], reader[2]);
         }

         connection.Close();
      }
   }
}