Good day, Just want to ask some help, Please! I always encounter "Cannot find Table 0" when i call Stored Procedure in DB2 using VB .Net with Ole DBConnection Provider. Here is my code: Private Sub cmdPost_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPost.Click rsSearch = clsDAOMngr.getConfigParam(2) For i = 0 To rsSearch.Tables.Count Step 1 With rsSearch.Tables(0) MsgBox(.Rows(i)(0).ToString()) End With Next End Sub '------------------------------------------------------- Public Function getConfigParam(ByVal strParameter As String) As DataSet getConfigParam = Nothing Dim sProcedure As String = "" sProcedure = "EDMS.SAMPLE_SELECT2" getConfigParam = clsDBMngr.executeStoredProcedure_split(sProcedure, strParameter, 1) End Function '------------------------------------------------------- Public Function executeStoredProcedure_split(ByVal spname As String, …

Member Avatar
Member Avatar
+0 forum 1

Hi! Thanks for trying to help me! I'm building a program that will allow me to have a different form for each person in my database. When the program first starts, I want it to cycle through the database and open a form for each row (each person). I'm generally failing to understand the methodology for connecting directly to a DB to construct queries, and I'm still fuzzy on how DataRow works... I'm using VisualStudio 2010 .Net4 and a MS SQL Server Compact DB (no password). The database is called Persons.sdf, the only table in the DB is called PeopleTable …

Member Avatar
Member Avatar
+0 forum 2

This is not a homework problem & my first post in 2+ years. I just got asked to do this in C# based on my asp & DB experience & I am tearing my hair out as they want in done in one day & 2 MS videos say to do the same thing & it does not work (at least does not display like their examples did. I managed to get the Access Database connected (it checked out ok) and I actually can see the data in the tables in the C# IDE (solution explorer), but when I followed …

Member Avatar
Member Avatar
+0 forum 18

The End.