DataRowState manipulation : DataRow « ADO.Net « C# / CSharp Tutorial






using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.IO;
using System.Runtime.Serialization.Formatters.Binary;

  class Program
  {
    static void Main(string[] args)
    {
      DataTable temp = new DataTable("Temp");
      temp.Columns.Add(new DataColumn("TempColumn", typeof(int)));

      DataRow row = temp.NewRow();           
      Console.WriteLine("After calling NewRow(): {0}", row.RowState);

      temp.Rows.Add(row);
      Console.WriteLine("After calling Rows.Add(): {0}", row.RowState);

      row["TempColumn"] = 10;
      Console.WriteLine("After first assignment: {0}", row.RowState);

      temp.AcceptChanges();
      Console.WriteLine("After calling AcceptChanges: {0}", row.RowState);

      row["TempColumn"] = 11;
      Console.WriteLine("After first assignment: {0}", row.RowState);

      temp.Rows[0].Delete();
      Console.WriteLine("After calling Delete: {0}", row.RowState);
    }
  }








32.33.DataRow
32.33.1.DataRow UpdateDataRow Update
32.33.2.Accessing Data Values in a DataRow Array by column name
32.33.3.Accessing Data Values in a DataRow Array by column name and return default value
32.33.4.Accessing Data Values in a DataRow Array by index
32.33.5.Accessing Data Values in a DataRow Array in a generic way by index
32.33.6.Accessing Data Values in a DataRow Array in a generic way by name
32.33.7.DataView and DataRowView
32.33.8.Filling a DataTable from the DataRow array using CopyToDataTable()
32.33.9.Filling a DataTable from the DataRow array using CopyToDataTable(DataTable, LoadOption)
32.33.10.Using foreach statement with DataRow in DataTable
32.33.11.For loop over DataRow array
32.33.12.Get first index in a row
32.33.13.DataRowState manipulation
32.33.14.Create and fill the DataRow array
32.33.15.Get column value in a row
32.33.16.Get value from a row with default value