我的 SQL Server 正在使用 DATE 資料型別，但我的 C# 應用程式將其讀取為 'mm/dd/yyyy 00:00:00'，誰能告訴我如何擺脫 0？（其他一切都有效）...？
var sda = new SqlDataAdapter("SELECT CustomerOrders.OrderID, Product.ProductName, OrderDetails.QuantityOrdered,"
" Customer.CustomerFirstName, Customer.CustomerLastName, CustomerOrders.OrderDate FROM CustomerOrders"
" INNER JOIN Product ON CustomerOrders.ProductID = Product.ProductID INNER JOIN Customer on CustomerOrders.CustomerID = Customer.CustomerID"
" INNER JOIN OrderDetails ON CustomerOrders.OrderID = OrderDetails.OrderID;", DatabaseConnection); // uses SQL query to read every piece of data in database
var dataset = new DataSet();
sda.Fill(dataset);
DatabaseConnection.Close();
DatabaseList.Items.Clear(); // clears all data in the list
DatabaseList.BeginUpdate();
foreach (DataRow row in dataset.Tables[0].Rows)
{
var lvi = new ListViewItem(); // rebuilds the list
lvi.Text = row["OrderID"].ToString();
lvi.SubItems.Add(row["ProductName"].ToString());
lvi.SubItems.Add(row["QuantityOrdered"].ToString());
lvi.SubItems.Add(row["CustomerFirstName"].ToString());
lvi.SubItems.Add(row["CustomerLastName"].ToString());
lvi.SubItems.Add(row["OrderDate"].ToString());
DatabaseList.Items.Add(lvi);
}
DatabaseList.EndUpdate();
uj5u.com熱心網友回復：
如果您不想要 a 的時間部分，DateTime因為String您有多種選擇：
DateTime orderDate = row.Field<DateTime>("OrderDate");
lvi.SubItems.Add(orderDate.ToShortDateString());
lvi.SubItems.Add(orderDate.ToString("d"));
lvi.SubItems.Add(orderDate.ToString("dd/MM/yyyy");
讀取：日期和時間格式字串
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/429706.html
上一篇：按鈕不可點擊c#winforms