using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data;

using System.Data.SqlClient;

 

namespace 查询一个结果

{

    class Program

    {

        static void Main(string[] args)

        {

            string connectionString = "server=.;database=Test;integrated security=true";

            using (SqlConnection connection = new SqlConnection(connectionString))

            {

                connection.Open();

                using (SqlCommand cmd = new SqlCommand())

                {

                    //string sql = "select stuName from TbStudent where stuNumber='174804005'";

                    string sql = "select * from TbStudent";

                    cmd.CommandText = sql;

                    cmd.Connection = connection;

                    //cmd.ExecuteNonQuery();

                    //ExecuteScalar()用来执行一条select语句，并且返回一个数据

                    //int count = Convert.ToInt32(cmd.ExecuteScalar());

                    //Console.WriteLine("全院一共有{0}学生",count);

                    //ExecuteScalar()用来执行一条select语句，并且返回查询结果第一行第一列中的数据

                    Console.WriteLine(cmd.ExecuteScalar());

                    Console.ReadKey();

                }

            }

        }

    }

}