ADO小叙.pptVIP

DataColumn vin = new DataColumn(Vin); vin.DataType = typeof(string); vin.MaxLength = 23; vin.Unique = true; vin.AllowDBNull = false; vin.Caption = VIN; auto.Columns.Add(vin); DataColumn make = new DataColumn(Make); make.MaxLength = 35; make.AllowDBNull = false; auto.Columns.Add(make); DataColumn year = new DataColumn(Year, typeof(int)); year.AllowDBNull = false; auto.Columns.Add(year); DataColumn yearMake = new DataColumn(Year and Make); yearMake.DataType = typeof(string); yearMake.MaxLength = 70; yearMake.Expression = Year + + Make; auto.Columns.Add(yearMake); 创建主键列 auto.PrimaryKey = new DataColumn[] { vin }; 思考题: DataColumn[]为什么用数组? DataRow newAuto = auto.NewRow(); newAuto[Vin] = 123456789ABCD; newAuto[Make] = Ford; newAuto[Year] = 2002; auto.Rows.Add(newAuto); auto.Rows.Add(987654321XYZ, Buick, 2001); auto.LoadDataRow(new object[] { 987654321XYZ, Jeep, 2002 }, LoadOption.OverwriteChanges); 使用DataRowState查看DataRow对象的状态 通过RowState属性可以获取DataRow对象的当先状态,该属性包含一个DataRowState枚举; Detached Added Unchanged Modified Deleted 使用DataRowVersion管理数据的多个副本 DataRow对象包含以下三种版本的数据: Original Current Proposed DataRow对象包含了一个HasVersion方法,可用于查询某个特定的DataRowVersion值是否存在. string retVal = string.Format( RowState: {0} \r\n, row.RowState); foreach (string versionString Enum.GetNames(typeof(DataRowVersion))) { DataRowVersion version = ( DataRowVersion)Enum.Parse( typeof(DataRowVersion), versionString); if (row.HasVersion(version)) { retVal += string.Format( Version: {0} Value: {1} \r\n, version, row[columnName, version]); } else { retVal += string.Format(