如何从MySQL的日期时间字段读 [英] How to read from mysql datetime field

问题描述

我想从MySQL领域的读取日期时间类型，我尝试了一切，始终是返回字段的名称而已。

I'm trying to read from mysql field with datetime type and I was trying everything and always it's return field name only.

下面是我的code：

using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
    connection.Open();

    string query = @"SELECT `sID`, 'sDate', `sGameLogin`, `dGameAmount`, 
                    'sPayMethod' FROM `XeronRequests` WHERE `iStatus` = 0";

    MySqlCommand cmd = new MySqlCommand(query, connection);
    cmd.CommandType = CommandType.Text;

    using (MySqlDataReader dataReader = cmd.ExecuteReader())
    {                    
        while (dataReader.Read())
        {
            list.Add(new PaymentInfoText(dataReader["sID"] + "", 
                     dataReader["sDate"] + "", 
                     dataReader["sGameLogin"] + "", 
                     dataReader["dGameAmount"] + "", 
                     dataReader["sPayMethod"] + ""));
        }
    }

    e.Result = list;
}

推荐答案

使用

Use 

而不是

dataReader["sDate"] + ""

和消除周围的列蜱在sql，如：

and remove the ticks around your columns in the sql, e.g.

SDATE 而不是SDATE。你需要他们只为保留字，或者如果你有空格的列名：

sDate instead of 'sDate'. You need them only for reserved words or if you have spaces in your column names:

9.3。保留字

<一个href="http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-1.html"相对=nofollow> 2.2。在MySQL中保留字5.1

这篇关于如何从MySQL的日期时间字段读的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！