如何检查行是否已更新(布尔) [英] How check if rows are Updated (bool)

问题描述

我有一个小问题
代码:

Hi, I have a small question
code:

public bool SaveChangesAtbildes(string jautajums, string atbilde, string pareizaAtbilde,
           int punkts, int testAtbildesID)
       {
           var saveQueryChangesAtbildes =
               from ch in db.JautājumuAtbildes
               where ch.TestaAtbildesID = testAtbildesID
               select ch;
           var saglabaDatus2 = new JautājumuAtbilde
           {
               Jautājums = jautajums,
               Atbilde = atbilde,
               PareizāAtbilde = pareizaAtbilde,
               Punkts = punkts,
               TestaAtbildesID = testAtbildesID
           };
           db.JautājumuAtbildes.InsertOnSubmit(saglabaDatus2);
           db.SubmitChanges();
           return true;
       }

如果未更改任何行，如何返回"false"?

谢谢！ :)

how to return ''false'' if no row was not changed?

thanks! :)

推荐答案

瓦尔扎，

尝试通过try catch块来处理它.如果数据库中出现任何错误，它将捕获在catch块中.要仅插入正确的数据，可以在代码级别使用验证.

此链接可能会对您有所帮助.

http://aspalliance.com/1414_LINQ_to_SQL_Part_4__Updating_our_Database.1 [

Hi Valza,

Try to handle it through try catch block.If any error come through database then it will catch in catch block. To insert only correct data you can use validation at code level.

This link may be help you.

http://aspalliance.com/1414_LINQ_to_SQL_Part_4__Updating_our_Database.1[^]

您需要使用 System.Data.Linq.ChangeSet changes = db.GetChangeSet( ); 在db.SubmitChanges();之前；获取更改数量.

请参考URL http://forums.asp.net/t/1292641.aspx [ ^ ]

You need to use System.Data.Linq.ChangeSet changes = db.GetChangeSet(); before db.SubmitChanges(); to get the number of changes.

Please refer to URL http://forums.asp.net/t/1292641.aspx[^]

这篇关于如何检查行是否已更新(布尔)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！