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();
}