如何在c＃android中检查Sqlite是否存在记录

作者: 苞米地里的蒙面妖
发布时间: 2025-02-25 02:05:38 (2天前)
转自：

2 条回复

0#
回复此人
蜡笔小辛 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 试试这个方法。我不确定你的sqlite代码是如何工作的所以我只是在这里猜测。我也猜测你想检查新创建的记录是否存在，所以这段代码基于此。 </p> <pre> <code> conn.CreateTable<Record>(); //check if records exist var items = conn.Table<Record>().Where(array => array.Jobno == photo.Jobno && array.Applicationletter == photo.Applicationletter && array.Signno == photo.Signno); if (items?.Count() == 0) { var numberofrows = conn.Insert(record); if (numberofrows > 0) { DisplayAlert("Success", "record has been saved successfully", "Ok"); MainImage.Source = " "; } else { DisplayAlert("Failure", "Error occoured while saving record", "Try again"); } } else { DisplayAlert("Failure", "Photo already exist", "ok"); } //clear the notes field notesentry.Text = ""; </code> </pre> </DIV>

编辑

登录后才能参与评论