修改数据集中的数据
// 修改数据集中的数据
// 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
张 三 深圳