修改数据集中的数据

// 修改数据集中的数据

// ModifyDataTable.cs

using   System;

using   System.Data;

using   System.Data.SqlClient;

namespace   Ch13

{

      class   ModifyDataTable

    {

          static   void   Main(   string [] args)

        {

              string   strConn =   "server=.\\MSSQL2012;integrated security=true;database=Northwind;" ;                       

              string   sql =   "select * from employees where country='UK'"   ;

            SqlConnection conn =   new   SqlConnection(strConn);

              try

            {

                SqlDataAdapter da =   new   SqlDataAdapter();

                da.SelectCommand =   new   SqlCommand(sql, conn);

                DataSet ds =   new   DataSet();

                da.Fill(ds,   "emp" );

                DataTable dt = ds.Tables[   "emp" ];               

                  // 改变字段列的模式信息

                dt.Columns[   "firstname" ].AllowDBNull =   true   ;

                  // 将数据集第一行的City列改为Wilmington

                  // dt.Rows[0]["City"] = "Wilmington";

                  // 添加新行

                DataRow newrow = dt.NewRow();

                newrow[   "firstname" ] =   "张"   ;

                newrow[   "lastname" ] =   "三"   ;

                newrow[   "titleofcourtesy" ] =   "先生"   ;

                newrow[   "city" ] =   "深圳"   ;

                newrow[   "country" ] =   "中国"   ;

                dt.Rows.Add(newrow);

               

                  foreach   (DataRow row   in   dt.Rows)

                {

                      Console .WriteLine(   "{0} {1} {2}" ,

                        row[   "firstname" ].ToString().PadLeft(10),

                        row[   "lastname" ].ToString().PadRight(15),

                        row[   "city" ]);

                }

            }

              catch   (   Exception   ex)

            {

                  Console .WriteLine(   "发生错误:"   + ex);

            }

              finally

            {

                conn.Close();

                  Console .ReadLine();

            }

        }

    }

}

--------------------------------

    Steven Buchanan        London

   Michael Suyama          London

    Robert King            London

      Anne Dodsworth       London

         张 三               深圳

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/bloodfist/p/3276724.html