Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call Vfp Database StoreProc with Parameter
Message
From
21/09/2002 10:48:41
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00703020
Message ID:
00703059
Views:
27
Rock,

Well, looks like I was close. <g> Glad you figured it out ...

~~Bonnie


>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
>
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform