Solved

Localdatabase table problem

Posted on 2014-11-27
1
116 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
start a process from a service 3 36
VB.NET 2008 - Windows Protected Your PC 7 52
Iteration Help (Asp.net VB) 5 35
Need help converting bitmap to image in VB.Net 8 44
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

680 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