C#无法向数据库插入数据的问题

Question

我有如下代码，希望向Northwind的employees表中插入一条数据。我运行这段代码，在控制台显示我已成功插入数据，但我打开SQL Server 2005 Management Stutio却找不到我的那条数据。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace Chapter9
{
    class SqlServerProvider
    {
        static void Main(string[] args)
        {
            string connectionString = @"server=(local)\sqlexpress; integrated security = sspi; database = Northwind";
            string commandQueryNameString = @"SELECT FirstName,LastName FROM employees";
            string commandInsertString = @"INSERT INTO employees(FirstName,LastName) VALUES('Barack','Obama')";            SqlConnection conn = new SqlConnection();
            SqlCommand cmdQueryName = new SqlCommand();
            SqlCommand cmdInsert = new SqlCommand();
            SqlDataReader nameReader = null;            try
            {
                //Set connection string and open
                conn.ConnectionString = connectionString;
                conn.Open();                cmdInsert.Connection = conn;
                cmdInsert.CommandText = commandInsertString;                cmdQueryName.Connection = conn;
                cmdQueryName.CommandText = commandQueryNameString;
                //Execute insertion
                cmdInsert.ExecuteNonQuery();                nameReader = cmdQueryName.ExecuteReader();
                while (nameReader.Read())
                {
                    Console.WriteLine("{0}{1}",nameReader["FirstName"].ToString().PadRight(10),nameReader["LastName"].ToString().PadRight(15));
                }
                
            }
            catch (SqlException e)
            {
                Console.WriteLine(e.ToString());
            }
            finally
            {
                conn.Close();
            }
        }
    }
}
请问这是怎么回事？

Answer 1

如下是我运行程序时在控制台显示的结果：
Nancy     Davolio
Andrew    Fuller
Janet     Leverling
Margaret  Peacock
Steven    Buchanan
Michael   Suyama
Robert    King
Laura     Callahan
Anne      Dodsworth
Barack    Obama
Press any key to continue . . .
如下是我SQL Server Management Stutio中的查询结果:

Answer 2

 string connectionString = @"Data Source=R-BILL-YUAN\SQLEXPRESS;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=123456";
            string commandQueryNameString = @"SELECT * FROM tb1";
            string commandInsertString = @"INSERT INTO tb1(qx1,dsc) VALUES('a','b')";
吧你的语句改成我的数据库完全可以