>>Hi everybody,
>>
>>I type the ItemNo and using BL/DS I select info and then populate the textboxes on the form with the Information. This is very slow - looks like almost a minute before the info appears on the screen.
>
>Are all SQL accesses that slow? I'd bet the problem is likely to be, for whatever reason, a slow SQL connect. Are you using Windows or SQL authentication?
>
I believe it's Windows, I only specify DataSource

 //this._connection.ConnectionString = ("Data Source =" 
            //            + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\SDCBarcodeData.sdf;"));

            this._connection.ConnectionString = Settings.Default.LocalConnectionString;

I have to change the designer code every time back to the second setting after I make any changes in DS.

With the Index on ItemNo it's quicker now, but not as quick as I want.