Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Link File Question
Message
 
À
28/07/2001 02:37:46
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00536806
Message ID:
00536829
Vues:
10
>Hi,
>
>I am using VB6 with ADO on my application. I intend to
>allow flexibilty in my application by using Data link file
>insteads of hardcoding my ADO control.
>
>However, I had problem setting it up. Please advise me
>on which part I had miss out.
>
>On my form, there is a ADO data control with dbgrid control
>
>On my form load method, I had the following code
>
>With ADODC
>
> .ConnnectionString = "File Name=D:\winprog\data\pdetail.udl"
> .CommandType = adCmdTable
> .RecordSource = "pdetail"
>
>End With
>
> Set dbgrid.DataSource = ADODC <------ give error of "data source
>name too long"
>
>
>Please advise me.

Have you REFRESH the ADODC?
Also, use this syntax:
Set dbgrid.DataSource = ADODC.Recordset
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform