static void Main1(string[] args)
{
//用戶輸入一個需要查詢的條件 car表
Console.WriteLine("請輸入");
string code = Console.ReadLine();
SqlConnection conn = new SqlConnection("server=.;database=mydb;user=sa;pwd=100867");
SqlCommand cmd= conn.CreateCommand();
cmd.CommandText = "select * from car where code=@code";
//給變量綁定參數
cmd.Parameters.AddWithValue("@code",code); ? 分兩部分輸出
conn.Open();
SqlDataReader dr= cmd.ExecuteReader();
if(dr.HasRows)
{
while (dr.Read())
{
Console.WriteLine("");
}
}
conn.Close();
Console.ReadLine();
}
)
)
