i not sure how deal error getting: "cannot convert object string"
row["timeinseconds"] = timespan.fromseconds( double.parse( r["timeinseconds"] ) ).tostring(@"hh\:mm\:ss"); the timeinseconds coming sqlite database , stored integer value
i need parse double can use seconds method of timespan can convert right format
private void updatedgvtimesheet() { dgvtimesheet.rows.clear(); foreach (datarow r in dataset.tables[0].rows) { datarow row = this.dataset.tables[0].newrow(); row["taskname"] = r["taskname"]; row["timeinseconds"] = timespan.fromseconds( double.parse( r["timeinseconds"] ) ).tostring(@"hh\:mm\:ss"); row["date"] = r["date"]; row["paid"] = r["paid"]; dgvtimesheet.rows.add(row); } }
you have convert r["timeinseconds"].tostring()
change function be:
private void updatedgvtimesheet() { dgvtimesheet.rows.clear(); foreach (datarow r in dataset.tables[0].rows) { datarow row = this.dataset.tables[0].newrow(); row["taskname"] = r["taskname"]; row["timeinseconds"] = timespan.fromseconds( double.parse( r["timeinseconds"].tostring() ) ).tostring(@"hh\:mm\:ss"); row["date"] = r["date"]; row["paid"] = r["paid"]; dgvtimesheet.rows.add(row); } } 