Solved

Localdatabase table problem

Posted on 2014-11-27
1
107 Views
Last Modified: 2014-11-27
Hi Experts
Since I re installed  Visual Studio 2013 Pro completely , I am having problem with any table that was created after re install. I can use that table in reportviewer but when I try to fill a datatable

    Dim daTempInvoice As New SqlDataAdapter(" select *   FROM TempInvoice  ", conexp)

        daTempInvoice.Fill(dSTempInvoice, "TempInvoice")
        dtTempInvoice = dSTempInvoice.Tables("TempInvoice")

I have this message

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Invalid object name 'TempInvoice'.
Screenshot-2014-11-27-08.21.05.png
0
Comment
Question by:b001
1 Comment
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 40469655
Check to make sure that your database contains a table or a view named TempInvoice.

If it does, then make sure that your connection string points to the proper file.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now