How to use reader.GetDateTime(i) to get DateTime from sqlite database？

Question

string sql = "select * from User where sUserName = '" + sUserName + "' AND sUserPassword = '" + sUserPassword + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
if (reader.Read())
{
    DateTime Time = reader.GetDateTime(0);
    System.DateTime timeNow_FromLocal = System.DateTime.Now; 
    if (timeNow_FromLocal < Time)
    {
        return true;
    }
    else
    {
        return false;
    }
}
else
{
    return false;
}

I want to get DateTime from sqlite database to compare with system time, but I can not reader.GetDateTime(0) successfully.

Possible duplicate of [What are good ways to prevent SQL injection?](https://stackoverflow.com/questions/14376473/what-are-good-ways-to-prevent-sql-injection) — mjwills, Nov 09 '18 at 09:32
@WangXinBoy09 what is the error you get? It could very well be that on position 1 there is no DateTime value. — Robert, Nov 09 '18 at 09:42
the error is The string is not recognized as a valid DateTime. Thanks for answering my question! — WangXinBoy09, Nov 09 '18 at 09:50
@Rob I think you are right. But I have checked it, it is DateTime value. It is 2018-11-9 12:00:00 in my sqlite database. — WangXinBoy09, Nov 09 '18 at 09:56
@Rob I am so sorry that I use stackoverflow for the first time. I don't konw how to post the table structure to you. — WangXinBoy09, Nov 09 '18 at 10:15
@WangXinBoy09 post it as a text. I just want to see the layout of the table that's all. — Robert, Nov 09 '18 at 10:17
Select the column you want in the query instead of '*' to ensure that your datetime column is in the first position. — Rabban, Nov 09 '18 at 10:17
@Rob Time sUserName sUserPassWord 2018-11-9 12:13:14 HangZhou 123456 — WangXinBoy09, Nov 09 '18 at 10:20
@Rabban OK, I will try it. But GetDateTime(0) have shown that I am getting the value of column 0. — WangXinBoy09, Nov 09 '18 at 10:22
You can also try to get the DateTime as string and parse it by hand with `DateTime.Parse()` — Rabban, Nov 09 '18 at 10:27

score 0 · Answer 1 · answered Nov 09 '18 at 10:31

0

try this

DateTime Time = DateTime.Parse(reader["columnName"].ToString());

answered Nov 09 '18 at 10:31

Dhanushka Dayawansha

366
2
10

Thanks you very much. I have done it well with the help of you. I spent an afternoon working on my original way but spend little time to do it well by your way.Although I still have doubts about the original method, I intend to finish the project first and then study why it is not right. – WangXinBoy09 Nov 09 '18 at 12:52

How to use reader.GetDateTime(i) to get DateTime from sqlite database？

1 Answers1