怎样求出一个数据库中最后一条记录中某个字段的值？（急）

[ameng_2002]

用什么方法比较简便一些？

[saucer]

if you are using SQL Server, the simpler way is to use SQL statement like this:
select top 1 * from yourtable order by SomeIDOrDateTimeField DESC

otherwise, if you do
select * from yourtable

and if you are using DataSet, then just get
ds.Rows[ds.Rows.Count-1]["字段"]

if you are using SqlDataReader, then you need to do something like

String s;
while (dr.Read())
s = (String)dr["字段"];

[ameng_2002]

select top 1 * from yourtable order by SomeIDOrDateTimeField DESC
是反会一个数据集吗？该怎样提取某一个字段的值？
谢谢！

[saucer]

it returns only one record,

SqlConnection myConnection = new SqlConnection(myConnectionString);
SqlCommand myCommand = new SqlCommand("select top 1 * from yourtable order by SomeIDOrDateTimeField DESC", myConnection);
myCommand.Connection.Open();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (myReader.Read())
{
System.Console.WriteLine(myReader["YourField"].ToString());
}

myReader.Close();

or better yet, if you only need that one column, you can use ExecuteScalar(), for example:

SqlConnection conn = new SqlConnection("Server=localhost;Database=pubs;UID=sa;PWD=;");
SqlCommand cmd = new SqlCommand("Select top 1 au_lname from authors order by au_lname desc",conn);
conn.Open();
String s = (String)cmd.ExecuteScalar();
Console.WriteLine(s);
conn.Close();

[ameng_2002]

谢谢saucer(思归)！

[JTCY23]

tag