DataRowState可以检查数据行有没有修改,好像没有找到直接的方法判断数据列是否被修改过,自己写一个检查。
- private bool isColumnChanged(DataRow dr,int columnIndex)
- {
- if (dr.RowState == DataRowState.Unchanged)
- {
- System.Console.WriteLine("datarow is unchanged.");
- return false;
- }
- else if ((dr.HasVersion(DataRowVersion.Original)) && dr[columnIndex, DataRowVersion.Default] == dr[columnIndex, DataRowVersion.Original])
- {
- System.Console.WriteLine("default value equals original value");
- return false;
- }
- else
- {
- System.Console.WriteLine("column " + columnIndex + " is changed.");
- return true;
- }
- }
- private void button4_Click(object sender, EventArgs e)
- {
- SqlConnection conn = new SqlConnection();
- conn.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pubs;server=(local)";
- SqlDataAdapter da = new SqlDataAdapter("select * from authors", conn);
- conn.Open();
- DataTable dt = new DataTable();
- da.Fill(dt);
- conn.Close();
- //dataGridView1.AutoGenerateColumns = true;
- //dataGridView1.DataSource = dt;
- DataRow dr = dt.Rows[0] ;
- dr[0] = 999;
- isColumnChanged(dr, 0);//true
- isColumnChanged(dr, 1);//false
- }