Csharp/CSharp Tutorial/ADO.Net/IDataReader
Get data from IDataReader
<source lang="csharp">using System; using System.Data; using System.Data.SqlClient; class MainClass {
public static void Main() { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = @"Data Source = .\sqlexpress;" + "Database = Northwind; Integrated Security=SSPI"; con.Open(); // Create and configure a new command. IDbCommand com = con.CreateCommand(); com.rumandType = CommandType.StoredProcedure; com.rumandText = "MyStoredProcedure"; // Execute the command and process the results using (IDataReader reader = com.ExecuteReader()) { while (reader.Read()) { Console.WriteLine(" {0} ", reader["FirstName"]); } } } }
}</source>