不错呦!smile@林凯西,确保“准备文件”中的几个文件都有安装,S...您好,看了您这篇帖子觉得很有帮助。但是有个问题想请...我的修改过了怎么还被恶意注册呢 @jjjjiiii 用PJ快9年了,主要是A...PJ3啊,貌似很少有人用PJ了,现在不是WP就是z...@332347365,我当时接入时错误码没有-10...楼主,ChkValue值应为-103是什么意思呢?...大哥 你最近能看到我发的信息,请跟我联系,我有个制...
获取DataTable单元格修改前的值示例
编辑:dnawo 日期:2009-10-28
复制内容到剪贴板
程序代码

//创建 DataTable
DataTable categories = new DataTable("Categories");
//添加字段
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "CategoryID";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
categories.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "CategoryName";
categories.Columns.Add(column);
//设置主键
DataColumn[] pKey = new DataColumn[1];
pKey[0] = categories.Columns["CategoryID"];
categories.PrimaryKey = pKey;
//添加记录
DataRow newRow = categories.NewRow();
newRow["CategoryName"] = "Category1";
categories.Rows.Add(newRow);
newRow = categories.NewRow();
newRow["CategoryName"] = "Category2";
categories.Rows.Add(newRow);
//提交更新
categories.AcceptChanges();
for (int i = 0; i < categories.Rows.Count; i++)
textBox1.Text += categories.Rows[i].RowState + "\r\n";
textBox1.Text += "----------------------------------\r\n";
//修改值
categories.Rows[0]["CategoryName"] = "New Category1";
for (int i = 0; i < categories.Rows.Count; i++)
textBox1.Text += categories.Rows[i].RowState + "\r\n";
textBox1.Text += "----------------------------------\r\n";
//获取原始值(修改前的值)
if(categories.Rows[0].HasVersion(DataRowVersion.Original))
textBox1.Text += categories.Rows[0]["CategoryName", DataRowVersion.Original];
DataTable categories = new DataTable("Categories");
//添加字段
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "CategoryID";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
categories.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "CategoryName";
categories.Columns.Add(column);
//设置主键
DataColumn[] pKey = new DataColumn[1];
pKey[0] = categories.Columns["CategoryID"];
categories.PrimaryKey = pKey;
//添加记录
DataRow newRow = categories.NewRow();
newRow["CategoryName"] = "Category1";
categories.Rows.Add(newRow);
newRow = categories.NewRow();
newRow["CategoryName"] = "Category2";
categories.Rows.Add(newRow);
//提交更新
categories.AcceptChanges();
for (int i = 0; i < categories.Rows.Count; i++)
textBox1.Text += categories.Rows[i].RowState + "\r\n";
textBox1.Text += "----------------------------------\r\n";
//修改值
categories.Rows[0]["CategoryName"] = "New Category1";
for (int i = 0; i < categories.Rows.Count; i++)
textBox1.Text += categories.Rows[i].RowState + "\r\n";
textBox1.Text += "----------------------------------\r\n";
//获取原始值(修改前的值)
if(categories.Rows[0].HasVersion(DataRowVersion.Original))
textBox1.Text += categories.Rows[0]["CategoryName", DataRowVersion.Original];
结果:

Unchanged
Unchanged
----------------------------------
Modified
Unchanged
----------------------------------
Category1
Unchanged
----------------------------------
Modified
Unchanged
----------------------------------
Category1






评论: 0 | 引用: 0 | 查看次数: 7054
发表评论
请登录后再发表评论!