首页 > 解决方案 > 我想显示以字母 y 而不是查看器开头的模型的名称?

问题描述

问题

 public static void Carbycountry()
    {

        SqlConnection mySqlConnection = new SqlConnection("server=LAPTOP-G0RLHB36\\SQLEXPRESS01;database=singog;Integrated Security=SSPI;");
        SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
        mySqlCommand.CommandText = "select * from cars where  model like  'y% ' ;";
        mySqlConnection.Open();
        SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();


        Console.WriteLine("{0,10} {1,10} {2,10} {3,10} {4,10} ", "ID CARS", "MODELS", "WeightS", "COYNTRYS", "PRICES");
        Console.WriteLine();
        while (mySqlDataReader.Read())
        {
            Console.WriteLine("{0,10} 1,10} {2,10} {3,10 } {4,10}", mySqlDataReader["idcar"], mySqlDataReader["model"], mySqlDataReader["weight"], mySqlDataReader["country"], mySqlDataReader["price"]);
        }

        mySqlDataReader.Close();
        mySqlConnection.Close();
    }

我想显示以字母 y 而不是查看器开头的模型的名称?

标签: c#

解决方案


推荐阅读