ASP.NET中的数据库连接与读取

 SqlConnection dataConnection = new SqlConnection();
            try
            {
                //使用SQLSERVER身份验证
                //string userName = sa;
                //string password = 123456;
                //dataConnection.ConnectionString = "User ID=" + userName + ";Password=" + password + ";Initial Catalog = Northwind;Data Source=10784D9B9C6A44C//SQLEXPRESS";
                //dataConnection.Open();

                //使用WINDOW身份验证
                dataConnection.ConnectionString = "Integrated Security=true;" + "Database=Northwind;" + "Data Source=10784D9B9C6A44C//SQLEXPRESS";
                dataConnection.Open();

                Console.WriteLine("请输入用户ID: ");
                string customerid = Console.ReadLine();

                SqlCommand dataCommand = new SqlCommand();
                dataCommand.Connection = dataConnection;
                dataCommand.CommandText = "select orderid,orderdate,shippeddate,shipname,shipaddress,shipcity,shipcountry from Orders where customerID='" + customerid + "'";
                Console.WriteLine("用户信息为:{0}/n/n", dataCommand.CommandText);
                SqlDataReader dataReader = dataCommand.ExecuteReader();

                while (dataReader.Read())
                {                   
                    int orderId = dataReader.GetInt32(0);
                    if (dataReader.IsDBNull(2))
                    {
                        Console.WriteLine("没有找到用户信息!请重新输入!");
                    }
                    else
                    {
                        DateTime orderDate = dataReader.GetDateTime(1);
                        DateTime shipDate = dataReader.GetDateTime(2);
                        string shipName = dataReader.GetString(3);
                        string shipAddress = dataReader.GetString(4);
                        string shipCity = dataReader.GetString(5);
                        string shipCountry = dataReader.GetString(6);
                        Console.WriteLine("Order {0}/nPlaced {1}/nShipped{2}/nTo Address {3}/n{4}{5}/n{6}/n/n", orderId, orderDate, shipDate, shipName, shipAddress, shipCity, shipCountry);
                    }
                    dataReader.Close();
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("Error accessing the database: " + e.Message);
            }
            finally
            {
                dataConnection.Close();
            }