Home Backend Development C#.Net Tutorial C# DataRow.ItemArray 属性

C# DataRow.ItemArray 属性

Feb 21, 2017 am 11:03 AM
c#

DataRow.ItemArray property
Gets or sets all the values ​​of this row through an array.
Namespace: System.Data

Assembly: System.Data (in system.data.dll)

Code example:


1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

private void CreateRowsWithItemArray()

{

    // Make a DataTable using the function below.

    DataTable dt = MakeTableWithAutoIncrement();

    DataRow relation;

    // Declare the array variable.

    object [] rowArray = new object[2];

    // Create 10 new rows and add to DataRowCollection.

    for(int i = 0; i <10; i++)

    {

        rowArray[0]=null;

        rowArray[1]= "item " + i;

        relation = dt.NewRow();

        relation.ItemArray = rowArray;

        dt.Rows.Add(relation);

    }

    PrintTable(dt);

}

  

private DataTable MakeTableWithAutoIncrement()

{

    // Make a table with one AutoIncrement column.

    DataTable table = new DataTable("table");

    DataColumn idColumn = new DataColumn("id",

        Type.GetType("System.Int32"));

    idColumn.AutoIncrement = true;

    idColumn.AutoIncrementSeed = 10;

    table.Columns.Add(idColumn);

 

    DataColumn firstNameColumn = new DataColumn("Item",

        Type.GetType("System.String"));

    table.Columns.Add(firstNameColumn);

    return table;

}

  

private void PrintTable(DataTable table)

{

    foreach(DataRow row in table.Rows)

    {

        foreach(DataColumn column in table.Columns)

        {

            Console.WriteLine(row[column]);

        }

    }

}

Copy after login

Exception:



##Exception typeConditions
ArgumentException

The array is greater than the number of columns in the table.

InvalidCastException

The value in the array does not match the DataType in its corresponding DataColumn.

ConstraintException

The editor broke the constraint.

ReadOnlyException

An editor attempted to change the value of a read-only column.

NoNullAllowedException

编辑试图将空值放在 DataColumn 对象的 AllowDBNull 为 false 的列中。

DeletedRowInaccessibleException

该行已被删除。

DataRow.ItemArray 属性源代码实现:


1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

public object[] ItemArray

{

    get

    {

        int defaultRecord = this.GetDefaultRecord();

        object[] array = new object[this._columns.Count];

        for (int i = 0; i < array.Length; i++)

        {

            DataColumn dataColumn = this._columns[i];

            array[i] = dataColumn[defaultRecord];

        }

        return array;

    }

    set

    {

        if (value == null)

        {

            throw ExceptionBuilder.ArgumentNull("ItemArray");

        }

        if (this._columns.Count < value.Length)

        {

            throw ExceptionBuilder.ValueArrayLength();

        }

        DataColumnChangeEventArgs dataColumnChangeEventArgs = null;

        if (this._table.NeedColumnChangeEvents)

        {

            dataColumnChangeEventArgs = new DataColumnChangeEventArgs(this);

        }

        bool flag = this.BeginEditInternal();

        for (int i = 0; i < value.Length; i++)

        {

            if (value[i] != null)

            {

                DataColumn dataColumn = this._columns[i];

                if (-1L != this.rowID && dataColumn.ReadOnly)

                {

                    throw ExceptionBuilder.ReadOnly(dataColumn.ColumnName);

                }

                if (dataColumnChangeEventArgs != null)

                {

                    dataColumnChangeEventArgs.InitializeColumnChangeEvent(dataColumn, value[i]);

                    this._table.OnColumnChanging(dataColumnChangeEventArgs);

                }

                if (dataColumn.Table != this._table)

                {

                    throw ExceptionBuilder.ColumnNotInTheTable(dataColumn.ColumnName, this._table.TableName);

                }

                if (-1L != this.rowID && dataColumn.ReadOnly)

                {

                    throw ExceptionBuilder.ReadOnly(dataColumn.ColumnName);

                }

                if (this.tempRecord == -1)

                {

                    this.BeginEditInternal();

                }

                object obj = (dataColumnChangeEventArgs != null) ? dataColumnChangeEventArgs.ProposedValue : value[i];

                if (obj == null)

                {

                    if (dataColumn.IsValueType)

                    {

                        throw ExceptionBuilder.CannotSetToNull(dataColumn);

                    }

                    obj = DBNull.Value;

                }

                try

                {

                    int proposedRecordNo = this.GetProposedRecordNo();

                    dataColumn[proposedRecordNo] = obj;

                }

                catch (Exception e)

                {

                    if (ADP.IsCatchableOrSecurityExceptionType(e) && flag)

                    {

                        this.CancelEdit();

                    }

                    throw;

                }

                this.LastChangedColumn = dataColumn;

                if (dataColumnChangeEventArgs != null)

                {

                    this._table.OnColumnChanged(dataColumnChangeEventArgs);

                }

            }

        }

        this.EndEdit();

    }

}

Copy after login

以上就是C#  DataRow.ItemArray 属性的内容,更多相关内容请关注PHP中文网(www.php.cn)!


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Active Directory with C# Active Directory with C# Sep 03, 2024 pm 03:33 PM

Guide to Active Directory with C#. Here we discuss the introduction and how Active Directory works in C# along with the syntax and example.

C# Serialization C# Serialization Sep 03, 2024 pm 03:30 PM

Guide to C# Serialization. Here we discuss the introduction, steps of C# serialization object, working, and example respectively.

Random Number Generator in C# Random Number Generator in C# Sep 03, 2024 pm 03:34 PM

Guide to Random Number Generator in C#. Here we discuss how Random Number Generator work, concept of pseudo-random and secure numbers.

C# Data Grid View C# Data Grid View Sep 03, 2024 pm 03:32 PM

Guide to C# Data Grid View. Here we discuss the examples of how a data grid view can be loaded and exported from the SQL database or an excel file.

Factorial in C# Factorial in C# Sep 03, 2024 pm 03:34 PM

Guide to Factorial in C#. Here we discuss the introduction to factorial in c# along with different examples and code implementation.

Patterns in C# Patterns in C# Sep 03, 2024 pm 03:33 PM

Guide to Patterns in C#. Here we discuss the introduction and top 3 types of Patterns in C# along with its examples and code implementation.

Prime Numbers in C# Prime Numbers in C# Sep 03, 2024 pm 03:35 PM

Guide to Prime Numbers in C#. Here we discuss the introduction and examples of prime numbers in c# along with code implementation.

The difference between multithreading and asynchronous c# The difference between multithreading and asynchronous c# Apr 03, 2025 pm 02:57 PM

The difference between multithreading and asynchronous is that multithreading executes multiple threads at the same time, while asynchronously performs operations without blocking the current thread. Multithreading is used for compute-intensive tasks, while asynchronously is used for user interaction. The advantage of multi-threading is to improve computing performance, while the advantage of asynchronous is to not block UI threads. Choosing multithreading or asynchronous depends on the nature of the task: Computation-intensive tasks use multithreading, tasks that interact with external resources and need to keep UI responsiveness use asynchronous.

See all articles