如何使用asp.net c＃在标签中显示最后一个记录列值 [英] How to display last record column value in label using asp.net c#

问题描述

大家好，



如何使用asp.net c显示标签中的最后一个记录列值＃



我正在使用asp.net c＃sqlserver 2005.



在我的sqltable中我有DateColumn的最后一条记录，我想在标签中显示最后一条记录列值



这是我的代码。

 SqlDataReader rdr = SQLcmd。的ExecuteReader（）; 
  while （rdr.Read（））
 {
 lblCreatedDate.text = 
} 
  string  lastVal = rdr [ 0 ]。ToString（）; 
 rdr.Close（）

请帮助

解决方案

您的代码将无法编译。你可以这样做

 SqlDataReader rdr = SQLcmd.ExecuteReader（）; 
  while （rdr.Read（））
 {
  //  这将覆盖每一行，但最后你有最后一行的值 
 lblCreatedDate.text = rdr [ 0 ]的ToString（）; 
} 

因为你只需要一个列值，你最好更改下面的sql语句

  SELECT   TOP   1  column_name  FROM  table_name 
  ORDER   BY  column_name < span class =code-keyword> DESC ; 

然后你会得到一行作为结果。

http：/ /www.dotnetfunda.com/forums/show/8641/how-to-get-the-value-of-the-last-row-in-a-gridview [ ^ ]

返回标识（自动增量）在SQL Server数据库中使用ADO.Net和C＃插入记录后的列值VB.Net [ ^ ]



< a href =http://www.codeproject.com/Questions/60437/how-to-get-last-record-value-in-sql-server-without>如何在不使用sql server的情况下获取最后一个记录值MAX / TOP子句？ [ ^ ]

 string col1Value = rdr [ColumnOneName]。ToString（）; 

hi all,

How to display last record column value in label using asp.net c#

am working on asp.net c# sqlserver 2005.

In my sqltable I have last record with DateColumn, Just I want to display this last record column value in label

This is my code.

SqlDataReader rdr = SQLcmd.ExecuteReader();
    while (rdr.Read())
    {
lblCreatedDate.text =
    }
    string lastVal = rdr[0].ToString();
    rdr.Close()

Please help

解决方案

Your code will not compile. you can do as below

SqlDataReader rdr = SQLcmd.ExecuteReader();
while (rdr.Read())
{
   //this will overwrite in every row but at the end you have the value of last row  
   lblCreatedDate.text = rdr[0].ToString();
}

since you only need one column value you better change the sql statement something like below

SELECT TOP 1 column_name FROM table_name
ORDER BY column_name DESC;

then you will get one row as the result.

http://www.dotnetfunda.com/forums/show/8641/how-to-get-the-value-of-the-last-row-in-a-gridview[^]
Return Identity ( Auto Increment ) Column value after record insert in SQL Server Database using ADO.Net with C# and VB.Net[^]

how to get last record value in sql server without using MAX/TOP clause?[^]

string col1Value = rdr["ColumnOneName"].ToString();

这篇关于如何使用asp.net c＃在标签中显示最后一个记录列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！