首页 \ 问答 \ 为什么此WPF数据网格显示从具有date数据类型的SQL Server数据库导入数据的时间?(Why is this WPF datagrid showing a time when importing data from SQL Server database with date datatype?)

为什么此WPF数据网格显示从具有date数据类型的SQL Server数据库导入数据的时间?(Why is this WPF datagrid showing a time when importing data from SQL Server database with date datatype?)

这就是SQL Server Management Studio中数据库数据的样子:

这是设计视图:

这就是datagrid的样子:

这是我用于将数据从SQL Server导入数据网格的代码。

        SqlConnection connection = new SqlConnection(@"Data Source=.;Initial Catalog=TheatreDatabase2.0;Integrated Security=True");
        try
        {
            connection.Open();
            SqlCommand cmd = new SqlCommand("SELECT * FROM performanceTable", connection);

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable data = new DataTable();
            da.Fill(data);
            dgdPerformance.ItemsSource = data.DefaultView;
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
        finally
        {
            connection.Close();
        }

我想知道为什么数据网格中每个日期末尾都有“12:00:00 AM”,以及如何删除它。


This is what the database data looks like in SQL Server Management Studio:

Here it is in design view:

This is what the datagrid looks like:

This is the code that I am using to import the data from SQL Server into the datagrid.

        SqlConnection connection = new SqlConnection(@"Data Source=.;Initial Catalog=TheatreDatabase2.0;Integrated Security=True");
        try
        {
            connection.Open();
            SqlCommand cmd = new SqlCommand("SELECT * FROM performanceTable", connection);

            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable data = new DataTable();
            da.Fill(data);
            dgdPerformance.ItemsSource = data.DefaultView;
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
        finally
        {
            connection.Close();
        }

I am wondering why there is the "12:00:00 AM" at the end of each date in the datagrid and how I would go about removing it.


原文:https://stackoverflow.com/questions/27759080
更新时间:2021-11-09 22:11

最满意答案

在这一行:

IEnumerable<int> listOfValues = 
                       property.GetValue(transformedData, null) as IEnumerable<int>;

您正在尝试在List<SomeModel>对象上检索ViewValue属性的值,但List<SomeModel>没有ViewValue属性。 你可以做的一件事是:

IEnumerable<int> listOfValues = 
                       transformedData.Select(i => (int)property.GetValue(i, null));

但更清洁的解决方案是完全避免反射,因为这里不需要:

interface IViewValue
{
    int ViewValue { get; set; }
}

public class SomeViewModel : IViewValue
{
    public int ViewValue { get; set; }
}

private int SumValues<T, TRes>(IEnumerable<T> data, Func<T, TRes> transformation)
                                            where TRes : IViewValue
{
    var transformedData = data.Select(transformation);
    IEnumerable<int> listOfValues = transformedData.Select(i => i.ViewValue);
    var sum = listOfValues.Sum();

    return sum;
}

In this line:

IEnumerable<int> listOfValues = 
                       property.GetValue(transformedData, null) as IEnumerable<int>;

You're trying to retrieve the value of the ViewValue property on a List<SomeModel> object, but List<SomeModel> doesn't have a ViewValue property. One thing you could do is this:

IEnumerable<int> listOfValues = 
                       transformedData.Select(i => (int)property.GetValue(i, null));

But a much cleaner solution would be to avoid reflection entirely as it's not needed here:

interface IViewValue
{
    int ViewValue { get; set; }
}

public class SomeViewModel : IViewValue
{
    public int ViewValue { get; set; }
}

private int SumValues<T, TRes>(IEnumerable<T> data, Func<T, TRes> transformation)
                                            where TRes : IViewValue
{
    var transformedData = data.Select(transformation);
    IEnumerable<int> listOfValues = transformedData.Select(i => i.ViewValue);
    var sum = listOfValues.Sum();

    return sum;
}

相关问答

更多

相关文章

更多

最新问答

更多
  • 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
  • 如何通过引用返回对象?(How is returning an object by reference possible?)
  • 矩阵如何存储在内存中?(How are matrices stored in memory?)
  • 每个请求的Java新会话?(Java New Session For Each Request?)
  • css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
  • 无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
  • xcode语法颜色编码解释?(xcode syntax color coding explained?)
  • 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
  • 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
  • 从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
  • 西安哪有PLC可控制编程的培训
  • 在Entity Framework中选择基类(Select base class in Entity Framework)
  • 在Android中出现错误“数据集和渲染器应该不为null,并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
  • 电脑二级VF有什么用
  • Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
  • 金华英语角.
  • 手机软件如何制作
  • 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
  • 注意:未定义的偏移量:PHP(Notice: Undefined offset: PHP)
  • 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
  • Unity 5 Heighmap与地形宽度/地形长度的分辨率关系?(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
  • 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程?(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
  • python的访问器方法有哪些
  • DeviceNetworkInformation:哪个是哪个?(DeviceNetworkInformation: Which is which?)
  • 在Ruby中对组合进行排序(Sorting a combination in Ruby)
  • 网站开发的流程?
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。