DataTable object initializer with Primary Key

debugcn 에 게시 Dev

Tea With Cookies

I'm having difficulty initializing a DataTable specifying the Columns and PrimaryKey with an object initializer:

private DataTable _products = new DataTable
    {
        Columns = { { "Product", typeof(string) }, { "Lot", typeof(string) }, { "Qty", typeof(int) } },
        PrimaryKey = Columns[0]  //Columns doens't exist in the current context
    };

Is there a way to make it work?

Tim Schmelter

No, you cannot use object initializer syntax if you want to use an object in it which is also initialized in it. But that wouldn't make much sense either.

Instead use the constructor since that is the appropriate place:

private DataTable _products;

public void ClassName()
{
    _products = new DataTable
    {
        Columns = { { "Product", typeof(string) }, { "Lot", typeof(string) }, { "Qty", typeof(int) } }
    };
    _products.PrimaryKey = new[] { _products.Columns[0] };
}

이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.

침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제

에서 수정2021-06-2

몇 마디 만하겠습니다

0리뷰

로그인참여 후 검토

Related 관련 기사

기사

DataTable object initializer with Primary Key

DataTable object initializer with Primary Key

Primary Key and Composite Key

Select record by Primary Key

jsf - foreign key in datatable

How to add primary key to a view?

set two fields as primary key

Overpassing SqlBulkCopy - Violation of Primary Key

Using String values for primary key

Sqlite JPA Primary Key error

Generating Primary key without set it as key

Postgresql and primary key, foreign key indexing

Compile error / Object initializer with Type ChartArea

Oracle IDENTITY 열 대 PRIMARY KEY

DynamoDB - how to query by something that is not the primary key

MS Access query table without primary key

Autoincrement Primary key generate weird values

JPA: persisting entity with composite primary key

Skipping SQLite operation if primary key already in table

how to get last inserted primary key

How to create a table with _id as composite primary key?

sqlite constraint exception primary key must be unique

Cassandra primary key design to cater range query

django redirect with full url and primary key in template

Hibernate Primary Foreign Key 필드

Django unique_together on primary key

INT PRIMARY KEY와 INTEGER PRIMARY KEY SQLite의 차이점

Django CharField primary key doesn't work, creating rowid primary key automatically

Saving Related Objects with Primary Object in Parse

How to reset the primary key id in ruby on rails 6?

Insert column to make the primary key in T-SQL