c# - Unable to get data from DateTime column in SQLite -


i using sqlite db c#.net. connecting db, have used system.data.sqlite.dll.

i facing problem when trying data db table type of column datetime.

this.sqlcommand.commandtext = query; sqlitedatareader datareturned = this.sqlcommand.executereader(); while (datareturned.read()) {      (int inx = 0; inx < datareturned.visiblefieldcount; inx++)      {          if (columns[inx].columnname.contains("date"))          {               // checking               datetime dt = datareturned.getdatetime(inx);          }          else          {                // store in other way          }      } } 

query returns below row enter image description here

when run code, below exception

enter image description here

please !!


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -