using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient ;

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection mySqlConnection = new SqlConnection("server=local;database=Northwind;uid=sa;pwd=");
            SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
             = "SELECT TOP 5 ProductID,ProductName,UnitPrice," + "UnitsInStock,Discontinued" + "FROM Products" + "ORDER BY ProductID";
            mySqlConnection.Open();
            SqlDataReader productsSqlDataReader = mySqlCommand.ExecuteReader();
            int productIDColPos = productsSqlDataReader.GetOrdinal("ProduuctID");
            int productNameColPos = productsSqlDataReader.GetOrdinal("ProduuctName");
            int unitPriceColPos = productsSqlDataReader.GetOrdinal("UnitPrice");
            int unitsInStockColPos = productsSqlDataReader.GetOrdinal("UnitsInStock");
            int discontinuedColPos = productsSqlDataReader.GetOrdinal("Discontinued");
            while (productsSqlDataReader.Read())
            {
                Console.WriteLine("ProductID=" + productsSqlDataReader[productIDColPos]);
                Console.WriteLine("ProductName=" + productsSqlDataReader[productNameColPos]);
                Console.WriteLine("UnitPrice=" + productsSqlDataReader[unitPriceColPos]);
                Console.WriteLine("UnitsInStock=" + productsSqlDataReader[unitsInStockColPos]);
                Console.WriteLine("Discontinued=" + productsSqlDataReader[discontinuedColPos]);
            }
            productsSqlDataReader.Close();
            mySqlConnection.Close();
            Console.ReadKey();
        }
    }
}
运行时显示红体字部分有问题，为什么啊？请指教啊！谢谢

什么问题也不说明下。

粗略看了下。这个语句 from 那里 应该加个空格
= "SELECT TOP 5 ProductID,ProductName,UnitPrice," + "UnitsInStock,Discontinued" + "FROM Products" + "ORDER BY ProductID";
改成
= "SELECT TOP 5 ProductID,ProductName,UnitPrice," + "UnitsInStock,Discontinued" + " FROM Products " + "ORDER BY ProductID";

呵呵 楼主也不说明什么问题啊   

楼上的说的对  在使用语句连接的时候  要注意原语句是否需要有链接空，因为+连接时没有空格的

看看异常报告就知道啦，肯定是sql语句没法运行