讨论DataTable.PrimaryKey

Question

//生成DataTable
strSql="SELECT * FROM TableName";
objDataTable=db.Query(strSql); //从数据类型中,计算主键集合
arryPrimaryKey=objDataTable.PrimaryKey;问题: objDataTable.PrimaryKey无法返回在Sql server中,对表定义的主键集合.
为什么?

Answer 1

how are you getting the data? with DataAdpater, tryDataAdapter1.MissingSchemaAction = MissingSchemaAction.AddWithKey ;
...//Fillor use FillSchema, seehttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaddingexistingconstraintstodataset.asp