Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the return value from a foxpro stored procedure
Message
 
To
All
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
Getting the return value from a foxpro stored procedure
Miscellaneous
Thread ID:
00821760
Message ID:
00821760
Views:
53
Is there any way to get a return value from a stored procedure? Here is the code that I am using. I need to get the return value of the stored procedure "getnextid()."

OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = ConfigurationSettings.AppSettings["DataPath"];

OleDbCommand vfpNextId = new OleDbCommand();
vfpNextId.Connection = myConnection;
vfpNextId.CommandText = "getnextid( asnctlg, id_asnctlg )";

myConnection.Open();

try
{
vfpNextId.ExecuteNonQuery();
}
catch(Exception ex)
{
this.SetError(ex.Message);
return false;
}
Next
Reply
Map
View

Click here to load this message in the networking platform