选择具有相同 ID 的多行
本文关键字:ID 选择 | 更新日期: 2023-09-27 18:36:34
我的"订单"表如下所示:
orderId CustomerName
1 customer1
2 customer2
3 customer1
4 customer1
我的代码只得到一个订单ID
SqlCommand command = new SqlCommand("SELECT orderId FROM orders WHERE CustomerName='"+name+"'", connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read()){
MyOrders order1 = new MyOrders(reader.GetInt32(0));
orders.Add(order1);
}
return orders.ToArray();
如何获得客户 1 的所有订单 ID 1,3,4?
使用循环添加所有订单。喜欢这个
while (reader.Read())
{
MyOrders order1 = new MyOrders(reader.GetInt32(reader("orderId")));
orders.Add(order1);
}