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

Gowtham Raj R

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????

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gowtham Raj R11y ago
Sorry I cant Able to underStand that
Sabyasachi Mishra11y ago
See the link
SQLite, Read Write Datetime values using C#
Gowtham Raj R11y ago
Field denote as Column name !!!!! But its only retrive empty column
Sabyasachi Mishra11y ago
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 R11y ago
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 Mishra11y ago
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