获取表中返回的记录的位置 [英] Getting the position of the record returned, in the table

问题描述

你好；

在程序中，有一个访问表，该表具有一列数​​字类型的列，称为ID_Number.该列是表的主键.当我需要查找特定记录时，请使用以下SELECT命令.我需要知道返回记录的位置.例如，我想知道返回的记录是表的第三行还是第十行.
您能告诉我如何在表格中找到结果的位置吗?

非常感谢

Hello;

In a program there is an Access Table with a column of number type called ID_Number. The column is the primary key of the table. When I need to look for a specific record, I use the SELECT Command as below. I need to know the position of the record returned. For example I want to know if the returned record is the 3rd or 10th... row of the table.
Could you please let me know how I could get the position of the result in the table?

Thanks a lot

string Sql_Comnd = "Select * from MyTable WHERE ID_Number = 1537";

推荐答案

您看到此提示了吗?

http://www.codeproject.com/Tips/53440/如何选择记录基于行号.aspx [

Did you see this tip ?

http://www.codeproject.com/Tips/53440/How-To-Select-Record-Based-on-Row-Number.aspx[^]

It produces the Row Number for the rows.

这篇关于获取表中返回的记录的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！