>yes, but i also use ado.net da.Fill(DsStock) to load the data and Me.TableAdapterManager.UpdateAll(Me.DsStock) to save data.
>In fact , i found this method is very slow in network driver.
> Sorry what mean is Where PrimaryKey=1 ? eg. Table name is apos ( primary key is Scode)
> Data 2
> 3
> 4
>you mean i should try select scode from apos where scode='2' in Foxpro or not?
>i already set the primary key field is indexed.
The exercise was to select only one record to see if you could get an instant result. PrimaryKey is just a reference to where you should name that with your primary key field. So, if you retrieve only one record and that primary key field is indexed and that is still slow then this would eliminate the possibility of this performance issue to be related to your SQL command syntax. Then, you will be able to concentrate your research elsewhere.