Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Call Vfp Database StoreProc with Parameter
Message
 
À
21/09/2002 01:55:55
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00703020
Message ID:
00703050
Vues:
33
thank's a lot Bonnie,

I Found the problem...
That's what it should like...
OleDbConnection oCon = new OleDbConnection(@"provider=vfpoledb;data source=C:\Devellopement\Data\Video.dbc");
		
OleDbCommand poCmd = new OleDbCommand();
poCmd.Connection = oCon;
poCmd.CommandText = "test(?)";
poCmd.CommandType = CommandType.Text;


OleDbParameter x = new OleDbParameter("psParam",OleDbType.VarChar);
x.Value = "Salut";
poCmd.Parameters.Add(x);
			
poCmd.Connection.Open();
string y  = (string)poCmd.ExecuteScalar();
Vfp SP code...
PROCEDURE Test() as String
	LPARAMETERS psXmlParam as String
	RETURN TRANSFORM(psXmlParam)
ENDPROC
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform