string was not recognized as a valid datetime c# sqlite sele

Question

SQLiteDataAdapter thisAdapter = new SQLiteDataAdapter("Beginning time of SELECT FROM in Table 1", conn);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "Record "); // in this line error this column query indicates the string was not recognized as a valid datetime????

dataGridView1.DataSource = thisDataSet.Tables[ "Record"];

But for other non datetime type column query the program without any problems
SQLiteDataAdapter thisAdapter = new SQLiteDataAdapter("The SELECT Title FROM Table 1", conn);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "Record");
dataGridView1.DataSource = thisDataSet.Tables["Record"];

It has the string variable into a datetime type library into the library, why at query time display the string was not recognized as a valid datetime????
It has the string variable into a datetime type library into the library, why at query time display the string was not recognized as a valid datetime????
It has the string variable into a datetime type library into the library, why at query time display the string was not recognized as a valid datetime????

Sabyasachi Mishra · Answer

SQLite does not have any class for datetimes.The built-in Date And Time Functions of SQLite are capable of storing datetimes as TEXT, REAL or INTEGER values: So while quering datetime use your query like this : SELECT datetime(field) as field FROM table

Gowtham Raj R · Answer

Sorry I cant Able to underStand that

Sabyasachi Mishra · Answer

See the link SQLite, Read Write Datetime values using C#

Gowtham Raj R · Answer

Field denote as Column name !!!!! But its only retrive empty column

Gowtham Raj R · Answer

This error While Occur on the SELECT Query Retrive Using dataReader() bind on data table (DateTime Type Column in Sqlite only this problem occur)

Sabyasachi Mishra · Answer

while doing update or insert statement convert your date time to string Convert.ToString(DatetimeTextbox.Text); or else Give proper datetime format in the textbox where you are giving datetime or else Change DateTime type to string in SQL Column