如何知道行的价值及其在GridView中插入过吗？ [英] How to know a row's value before its inserted in gridview?

问题描述

我有这个疑问：

SELECT COUNT(date) FROM patients WHERE date= 2012/02/23

如果说COUNT返回10，将有告诉给它不能接受详情，请访问该用户发出警报。
我如何验证？我怎么能知道？
在PHP我只是要做到这一点：

If that COUNT returns 10, there will be an alert that tells to the user that it cannot accept more visit. How do i validate that? How can i know that? In php i just have to do this:

<?php

$QUERY = "SELECT COUNT(date) AS count_results FROM patients WHERE date= 2012/02/23";
$execute_query = $CONEXION ->prepare($query);
$execute_query->execute();
$results = execute_query->fetch(PDO::FETCH_ASSOC);

if(results['count_results ']==10)
{
echo "Cannot accept know visit.";
}else{
echo "Ok";
}
?>

但我不知道该怎样做，在ASP.NET C＃的想法。
帮助？

But i have no idea of how to do that in ASP.NET C#. Help??

推荐答案

在Page_Load事件执行检查，如果您要验证登录的用户。或者，如果您需要根据您正试图插入一个用户值来验证，使用button_click事件被插入的记录。

Perform a check in the page_load event, if you are validating the logged in user. Or if you need to validate depending on a user value that you are attempting to insert, use the button_click event for record being inserted.

SqlCommand cmdEvent = new SqlCommand("SELECT COUNT(date) FROM patients WHERE date= '2012/02/23'", yourSqlConnection);
object myCount;
if (yourSqlConnection.State == ConnectionState.Closed){ yourSqlConnection.Open(); }
myCount = cmdEvent.ExecuteScalar();
if (yourSqlConnection.State == ConnectionState.Open){ yourSqlConnection.Close(); }

if (myCount != null)
{
  if ((int)myCount >= 10)
  {
    // Logic here e.g myLabel.Text = "You have reached your maximum of 10 visits!";
    return;
  }
}

这篇关于如何知道行的价值及其在GridView中插入过吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！