Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call Vfp Database StoreProc with Parameter
Message
 
To
21/09/2002 01:55:55
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00703020
Message ID:
00703050
Views:
32
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform