日期格式化WPF数据网格(Date formatting WPF datagrid)

 我有一个特殊的问题，首先看起来很容易，但我不知道任何解决方案。 目前我编写了一个C＃-WPF-应用程序，可以节省预订。 预订还有一个日期，我从日历中获取。 我将预订保存到我的Sql-Express数据库，日期的值是“DD.MM.YYYY”，数据类型是日期。 
 
 现在，我将数据加载到我的应用程序中的数据网格中： 
 
    public DataSet SaveDataToDataSet(DataSet dataset)
    {

        string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\Harald\\Desktop\\Farmer´s Calc\\Programmierung\\WPF\\Finanz_WPF\\Finanz_WPF\\FarmersCalc.mdf;Integrated Security=True;User Instance=True";
        string query = "select bezeichnung 'Bezeichnung', einausgaben 'Einnahmen-Ausgaben',  kostenstelle 'Kostenstelle',  datum 'Buchungsdatum', betrag 'Betrag', details 'Details' from Buchung";
        using (SqlConnection connection =
            new SqlConnection(connectionString))
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(
                query, connection);

            adapter.Fill(dataset);
            return dataset;

        }
    }
 
 奇怪的是，DataGrid中的日期列格式为“DD.MM.YYYY HH：MM：SS”，但我只想要“DD.MM.YYYY”！ 我需要说的是，我没有定义列，我使用AutoGenerateColumns = true。 有人知道这个解决方案吗？ 

I´ve got a special problem, that first seems very easy but I don´t know any solution. At the moment I programm a C#-WPF-Application that makes it possible to save bookings. A booking also has a date, which I take from a calender. I save the booking to my Sql-Express Database and the value of a date is "DD.MM.YYYY", the datatype is date.
 
Now, I load the data into a datagrid in my application: 
 
    public DataSet SaveDataToDataSet(DataSet dataset)
    {

        string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\Harald\\Desktop\\Farmer´s Calc\\Programmierung\\WPF\\Finanz_WPF\\Finanz_WPF\\FarmersCalc.mdf;Integrated Security=True;User Instance=True";
        string query = "select bezeichnung 'Bezeichnung', einausgaben 'Einnahmen-Ausgaben',  kostenstelle 'Kostenstelle',  datum 'Buchungsdatum', betrag 'Betrag', details 'Details' from Buchung";
        using (SqlConnection connection =
            new SqlConnection(connectionString))
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(
                query, connection);

            adapter.Fill(dataset);
            return dataset;

        }
    }
 
Strangely, the date column in the DataGrid has the format "DD.MM.YYYY HH:MM:SS", but I only want "DD.MM.YYYY"! What I need to say is, that I don´t have Columns defined, I make it with AutoGenerateColumns=true. Does anybody know a solution for that?

原文：https://stackoverflow.com/questions/7981447