2 replies to this topic

[Mozana]

i want to setup a primary key without using the datacolumn class, what i tryd is...
DataSet ds;
ds.Tables["Customer"].PrimaryKey = ds.Tables["Customer"].Columns["CustID"]
then i get error that i cannot implicitly convert type system.data.datacolumn[] to system.data.datacolumn

[wim DC]

How about the following?

DataColumn[] pk= new DataColumn[1];
pk[0] = ds.Tables["Customer"].Columns["CustID"];
ds.Tables["Customer"].PrimaryKey = pk;

[Mozana]

thanks, i got the answer by using the missingSchemaAction i did not want use the dataColum