ado.not--更改精简练习

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace _06_22
{
    class Program
    {
        static void Main(string[] args)
        {

            //练习题： 

            #region  显示全部
            //1、Car表数据查出显示
            SqlConnection coon = new SqlConnection("server=.;database=Data0425;user=sa;pwd=123;");
            SqlCommand com = coon.CreateCommand();

            com.CommandText = "select * from car";
            coon.Open();
            SqlDataReader a1 = com.ExecuteReader();
            if (a1.HasRows)
            {
                while (a1.Read())
                {
                    Console.WriteLine("编号：" + a1["Code"] + " 品牌：" + a1["name"] + " 油耗：" + a1["oil"] + " 马力：" + a1["powers"] + " 排量：" + a1["exhaust"] + " 价格:" + a1["price"]);
                }
            }

            coon.Close();
            #endregion

            //2、请输入要查的汽车名称：
            //    请输入要查的汽车油耗：
            //    请输入要查的汽车马力：
            //名称：宝马
            //油耗：8
            //马力：1



            for (; ; )
            {
                Console.Write("请输入要查的汽车名称：");
                string cname = Console.ReadLine();
                Console.Write("请输入要查的汽车油耗：");
                string coil = Console.ReadLine();
                Console.Write(" 请输入要查的汽车马力：");
                string cpowers = Console.ReadLine();        //输入查询内容


                    com.CommandText = "select * from car where name like @cname and oil like @coil and powers like @cpowers ";

                    com.Parameters.Clear();
                    com.Parameters.Add("@cname", "%" + cname + "%");
                    com.Parameters.Add("@coil", "%" + coil + "%");
                    com.Parameters.Add("@cpowers", "%" + cpowers + "%");

                    coon.Open();
                    SqlDataReader c1 = com.ExecuteReader();
                    if (c1.HasRows)
                    {
                        while (c1.Read())
                        {
                            Console.WriteLine("编号：" + c1["Code"] + " 品牌：" + c1["name"] + " 油耗：" + c1["oil"] + " 马力：" + c1["powers"] + " 排量：" + c1["exhaust"] + " 价格:" + c1["price"]);
                        }
                        Console.Write("是否结束？[y/n]");
                        string js = Console.ReadLine();
                        if (js == "y")
                        { break; }
                    }
                    else
                    { Console.WriteLine("查无此项！！！重新输入！！"); }
                    coon.Close();
         




            }
            Console.ReadLine();
        }
    }
}