using System;
using System.Data;
using System.Data.SqlClient;namespace Northwind
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection sqlConn = null;
            try
            {
                //创建连接对象,使用集成安全方式连接,更安全
                sqlConn = new SqlConnection(@"server=localhost;database=northwind;uid=sa;pwd=tianshi520");
                //打开数据库
                sqlConn.Open();                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(
                    "select CategoryID, CategoryName form Categories", sqlConn);                sqlDataAdapter.UpdateCommand = new SqlCommand(
                    "update Categories set CategoryName=@CategoryCame" +
                    "where CategoryID=@CategoryID", sqlConn);
                sqlDataAdapter.UpdateCommand.Parameters.Add("@CategoryName",
                    SqlDbType.NVarChar, 15, "CategoryName");                SqlParameter workParm = sqlDataAdapter.UpdateCommand.Parameters.Add(
                    "@CategoryID", SqlDbType.Int);
                workParm.SourceColumn = "CategoryID";
                workParm.SourceVersion = DataRowVersion.Original;
                                DataSet ds = new DataSet();
                sqlDataAdapter.Fill(ds, "Categories");                DataRow row = ds.Tables["Categories"].Rows[0];
                row["CategoryName"] = "New Category";                sqlDataAdapter.Update(ds);                foreach (DataRow dr in ds.Tables["Categories"].Rows)
                {
                    Console.WriteLine("{0, -15}{1, -15}",
                       dr["CategoryID"], dr["CategoryName"]);
                }
            }
            catch (System.Exception e)
            {
                Console.WriteLine(e.Message);
                Console.WriteLine(e.Source);
            }
            finally
            {
                //断开数据库连接
                sqlConn.Close();
            }        }
    }
}
帮看看哪里出错,我们明白!