|
sponsored links |
|
|
sponsored links
|
|
1
22nd January 00:41
External User
Posts: 1
|
Visual Foxpro OleDB / Stored Procedures / ASP.Net
I've downloaded the very latest (Aug03 version) of
vfpoledb and installed it. I'm trying to use a stored procedure in the northwind.dbc sample database included with vfpoledb, but unfortunately I cannot seem to figure out why I cannot see data on my rendered page but I only see the following : return_value True Looks like only the return value is coming back. The aspx file code is below : ******** <%@ Page Debug="true" SmartNavigation="True" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <Script RunAt="Server"> Sub Page_Load Dim dstPubs As DataSet dstPubs = New DataSet Dim dtblTitles As DataTable dtblTitles = New DataTable Dim conPubs As OleDbConnection = New OleDbConnection("PROVIDER=VFPOLEDB.1 ;data source = 'C:\Program Files\Microsoft Visual FoxPro OLE DB Provider\Samples\Northwind\northwind.dbc';password ='';user id='';nulls=false") Dim dadTitles As OleDbDataAdapter = New OleDbDataAdapter Dim cmdSelect As oleDbCommand cmdSelect = New OleDbCommand("custOrdersDetail", conPubs) cmdSelect.CommandType = CommandType.StoredProcedure cmdSelect.Parameters.Add( "tiOrderID",10248) conPubs.Open() dgrdProd.DataSource = cmdSelect.executereader() dgrdProd.DataBind() conpubs.close() END sub </Script> <html> <body> <asp  ataGridID="dgrdProd" Runat="Server" > </asp ataGrid></body> </html> Any clues what I'm doing wrong ? TIA Sunil |
|
|
Linear Mode
