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

本文介绍了如何使用DataReader从数据库检索数据?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

谁都知道C#代码..

Anyone know C# code for this.. How to retrieve data from database using datareader?

推荐答案

亲爱的朋友， 请点击以下链接:- www.akadia/services/dotnet_data_reader.html [ ^ ] 希望对您有帮助. 谢谢 Dear Friend, Please follow this link:- www.akadia/services/dotnet_data_reader.html[^] Hope it will help you out. Thanks

检查此链接 www.akadia/services/dotnet_data_reader.html [ ^ ] 它将帮助您 Check this link www.akadia/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(); } }

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

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