如何使用DataReader从数据库检索数据? [英] How to retrieve data from database using datareader?

问题描述

谁都知道C#代码..

Anyone know C# code for this..

How to retrieve data from database using 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[^]

这篇关于如何使用DataReader从数据库检索数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！