Is FindBy<Key> Method applicable to design time dataset

[Keith]

Hi,

I created a dataset during run time and assigned it to the datagrid.
But i cant get the FindBy<Key> method to work. During design time, i
got a error "dtProdHdr is not a member of System.Data.Dat aSet" error

Is it that FindBy<Key> method is used only for DataSet generated
during design time by the wizard? Can i actually use FindBy<Key>
method if i am using a design time created dataset?

below is a sample of my codes

Shared dsProdInfo As DataSet
Shared dtProdHdr As DataTable
Shared dtProdDtl As DataTable

Dim myDataRow As DataRow

Sub myFunction()
dsProdInfo.Data SetName = "dsProdInfo "

dtProdHdr = New DataTable("dtPr odHdr")
dtProdHdr.Colum ns.Add("PROD_CA T")
dtProdHdr.Colum ns.Add("PROD_TY PE")
dtProdHdr.Colum ns.Add("KIT_NO" )
dtProdHdr.Colum ns.Add("PROD_DE SC")

dsProdInfo.Tabl es.Add(dtProdHd r)

Dim dr as DataRow

' Error "dtProdHdr is not a member of System.Data.Dat aSet" occurs
below
dr = dsProdInfo.dtPr odHdr.FindByPRO D_DET_ID()

End Sub
Thanks for any advice

Keith

[Keith]

Hi,

Forgot to mentioned that i did set the datakey of my DataGrid1 to PROD_DET_ID

and also ...

dr = dsProdInfo.dtPr odHdr.FindByPRO D_DET_ID()

shd be as

dr = dsProdInfo.dtPr odHdr.FindByPRO D_DET_ID(key)
any one has any idea what i missed out?

ke******@singte l.com (Keith) wrote in message news:<53******* *************** ****@posting.go ogle.com>...

Hi,

I created a dataset during run time and assigned it to the datagrid.
But i cant get the FindBy<Key> method to work. During design time, i
got a error "dtProdHdr is not a member of System.Data.Dat aSet" error

Is it that FindBy<Key> method is used only for DataSet generated
during design time by the wizard? Can i actually use FindBy<Key>
method if i am using a design time created dataset?

below is a sample of my codes

Shared dsProdInfo As DataSet
Shared dtProdHdr As DataTable
Shared dtProdDtl As DataTable

Dim myDataRow As DataRow

Sub myFunction()
dsProdInfo.Data SetName = "dsProdInfo "

dtProdHdr = New DataTable("dtPr odHdr")
dtProdHdr.Colum ns.Add("PROD_CA T")
dtProdHdr.Colum ns.Add("PROD_TY PE")
dtProdHdr.Colum ns.Add("KIT_NO" )
dtProdHdr.Colum ns.Add("PROD_DE SC")

dsProdInfo.Tabl es.Add(dtProdHd r)

Dim dr as DataRow

' Error "dtProdHdr is not a member of System.Data.Dat aSet" occurs
below
dr = dsProdInfo.dtPr odHdr.FindByPRO D_DET_ID()

End Sub
Thanks for any advice

Keith