ASP.NET Formview 项插入事件

发布于 2024-07-08 08:37:57 字数 554 浏览 11 评论 0原文

我使用 ASP.NET 中的 FormView 控件将一个简单的表单插入到 MS SQL DB 中。我有一个 onItemInserting 事件来设置一些值（例如时间戳等），并且很好奇如何检查 onItemInserting 事件中的某些用户输入的值并取消插入项目。我想在后面的代码中执行此操作的原因是查询数据库并使用这些值来验证用户输入的数据。

伪代码如下：

protected void Form_addRoom_ItemInserting(object sender, FormViewInsertEventArgs e)
{
  ... Query DB for some values ...
  if(enteredMaxPeople > queryMaxPeople)
  {
    **Cancel** DB Insert
    statusLabel.text = "Value entered not valid";
  }
}

最后问题是如何在后面的代码中取消FormView的插入？

谢谢你！肖恩

原文

I'm using the FormView control in ASP.NET for a simple form to insert into a MS SQL DB. I have an event for onItemInserting to set some values behind (such as time stamp, etc) and was curious how to check some user entered values in the onItemInserting event and cancel the item from being inserted. The reason I want to do it in the code behind is to query the database and use the values to validate the user entered data.

Pseudo Code is as follows:

protected void Form_addRoom_ItemInserting(object sender, FormViewInsertEventArgs e)
{
  ... Query DB for some values ...
  if(enteredMaxPeople > queryMaxPeople)
  {
    **Cancel** DB Insert
    statusLabel.text = "Value entered not valid";
  }
}

In the end the question comes down to how do I cancel a FormView from inserting in the code behind?

Thank you!
Sean

分享到QQ

分享到微博