数据库连接，读取

         连接SQL Server

   SqlConnection myConnection = new SqlConnection(

            @"Persist Security Info=False;Integrated Security=SSPI;database=Dream;server=(local)");

            myConnection.Open();

            SqlCommand myCommand = myConnection.CreateCommand();

            myCommand.CommandText = "select Name,Sex from BaseInfo";

            SqlDataReader myRead = myCommand.ExecuteReader();

            while (myRead.Read())

            {

                Console.WriteLine("/t{0}/t{1}", myRead["Name"], myRead["Sex"]);

            }

            Console.WriteLine("/t{0}/t{1}", myConnection.Database, myConnection.DataSource);

            myRead.Close();

            myConnection.Close();

           

   连接Oracle

   OracleConnection myConnection = new OracleConnection(

            "Date Source=Dream;user=sa;password=sa");

            myConnection.Open();

            SqlCommand myCommand = myConnection.CreateCommand();

            myCommand.CommandText = "select Name,Sex from BaseInfo";

            SqlDataReader myRead = myCommand.ExecuteReader();

            while (myRead.Read())

            {

                Console.WriteLine("/t{0}/t{1}", myRead["Name"], myRead["Sex"]);

            }

            Console.WriteLine("/t{0}/t{1}", myConnection.Database, myConnection.DataSource);

            myRead.Close();

            myConnection.Close();