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
when run code, below exception
please !!
Comments
Post a Comment