如何使用DataReader从数据库检索数据?

亲爱的朋友，

请点击以下链接:-

http://www.akadia.com/services/dotnet_data_reader.html [

Dear Friend,

Please follow this link:-

http://www.akadia.com/services/dotnet_data_reader.html[^]

Hope it will help you out.

Thanks

检查此链接

http://www.akadia.com/services/dotnet_data_reader.html [

Check this link

http://www.akadia.com/services/dotnet_data_reader.html[^]

It will help You

查看此

see this

private static void ReadOrderData(string connectionString)
{
    string queryString =
        "SELECT OrderID, CustomerID FROM dbo.Orders;";

    using (SqlConnection connection =
               new SqlConnection(connectionString))
    {
        SqlCommand command =
            new SqlCommand(queryString, connection);
        connection.Open();

        SqlDataReader reader = command.ExecuteReader();

        // Call Read before accessing data.
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0}, {1}",
                reader[0], reader[1]));
        }

        // Call Close when done reading.
        reader.Close();
    }
}

来自: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx [ ^ ]

From : http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx[^]