DataReader如何根据字段名取值？

[nmxue]

我看到getString之类的方法只有整形的参数啊，又没有根据字段的name取值得？

[JJ77]

returnReader[].

[寒星]

using System;
using System.Data.SqlClient;

public class DataReader
{
public static void Main(string[] args)
{
string source = "Data Source=xxx;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=xxxx;";

string sql = "Select Name,FullName From OnUser";

SqlConnection conn = new SqlConnection(source);

conn.Open();

SqlCommand cmd = new SqlCommand(sql,conn);

SqlDataReader aReader = cmd.ExecuteReader();

while(aReader.Read())
Console.WriteLine("'{0}' from {1}",aReader["Name"].ToString(),aReader["FullName"].ToString());

Console.WriteLine("***OK***");

aReader.Close();
conn.Close();
}
}

[wn_319]

you

[declude]

Datareader["字段名"]

[xswh418]

两中方法：
1比如你要取的一个int值，是返回记录集的第一个字段age
datareader1.getint(0);
2
int.prase(datareader1["age"].tostring());

[nmxue]

谢谢大家~~~怎么给分啊？~~~