Jerry,

At first glance, what you've done looks right ... I don't know how you can speed it up.

~~Bonnie



>I have created a C# form to access a VFP table on our network. The following is the code I am using to query this table. Everything works but the speed isn't that good. It takes about 2 seconds to return the result. The same query in VFP is immediate.
>
>The oConn.Open(); and the oDataAdapter.Fill(oDataSet,"MyTable"); seem to take the longest to execute. Is there anything I can do to speed up this query? Or a different way to do this?
>
>

>
>string strAccessConn = "Provider=VFPOLEDB.1;Data " +
>"Source=P:\\Mydir\\;Mode=ReadWrite|Share Deny None;Extended " +
>"Properties=\"\";User ID=\"\";Password=\"\";Mask Password=False;Cache " +
>"Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN=\"\"";
>
>string strAccessSelect = "SELECT * FROM MyTable WHERE MyField = '" + lcMyVar + "'";
>
>DataSet oDataSet = new DataSet();
>oDataSet.Tables.Add("MyTable");
>
>OleDbConnection oConn = new OleDbConnection(strAccessConn);
>OleDbCommand oAccessCommand = new OleDbCommand(strAccessSelect,oConn);
>OleDbDataAdapter oDataAdapter = new OleDbDataAdapter(oAccessCommand);
>
>oConn.Open();   //Slow here.
>oDataAdapter.Fill(oDataSet,"MyTable"); //Slow here.
>
>

>
>Thanks,
>
>Jerry