using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Data;

namespace CS_Console_MsSQL

{

    class Program

    {

        static
void Pause()

        {

            Console.Write(“Press any key to continue . . . “);

            Console.ReadKey(true);

        }

        static
void Main(string[]
args)

        {

            //http://livin.tw/?p=555

            //第A一@：G連s結g2SQL資Me料A庫w

            String
IP = “127.0.0.1”;

            String
DBName = “v7”;

            String
User = “root”;

            String
Password = “asd700502”;

            String
Connection = String.Format(“server={0}; database={1};uid={2};pwd={3}”,
IP, DBName, User, Password);

            SqlConnection
conn = new SqlConnection(Connection);

            conn.Open();

            //http://stackoverflow.com/questions/3005095/can-i-get-name-of-all-tables-of-sql-server-database-in-c-sharp-application

            DataTable
dt = conn.GetSchema(“Tables”);

            List<string> tables = new
List<string>();

            foreach
(DataRow row in
dt.Rows)

            {

                string
tablename = (string)row[2];

                tables.Add(tablename);

                Console.WriteLine(tablename);

            }

            /*

            //第A二G：G執Xo行aSQL指u令DO

            string sqlstr =
“select * from
資Me料A表i”;

            SqlCommand cmd = new
SqlCommand(sqlstr, conn);

            SqlDataReader dr =
cmd.ExecuteReader();

            //第A三T：G印L出DX資Me料A

            while (dr.Read())

            {

                String s =
dr[”
資Me料A欄a位i”].ToString();

            }

            //第A四D|：G關o閉?連s線u

            cmd.Cancel();

            dr.Close();

            */

            Pause();

            conn.Close();

            conn.Dispose();

        }

    }

}