Ad:

VB.NET Discussion Thread
Marked Solved
Views: 1531

Feb 10th, 2009

Invalid Object error, yet Table already created.

Expand Post »

I'm trying to use VB.NET to insert the data in the current row of my datagrid into a table. I wrote the following code:

VB.NET Syntax (Toggle Plain Text)
       Dim vCustomer, vBulkQty, vItem, vBaseUnit, vEachQty, vEachUnit As String
 
        vCustomer = dgCustomers.CurrentRow.Cells(0).Value
        vItem = dgItems.CurrentRow.Cells(0).Value
        vBulkQty = dgItems.CurrentRow.Cells(3).Value
        vBaseUnit = dgItems.CurrentRow.Cells(4).Value
        vEachQty = dgItems.CurrentRow.Cells(5).Value
        vEachUnit = dgItems.CurrentRow.Cells(6).Value
 
        Dim Insert As String
 
        Insert = "INSERT INTO OTM_ORDERS(CustomerID,ItemNo,BulkQty,BaseUnit,EachQty,StockUnit) " _
        & "VALUES ('" & Trim(vCustomer) & "','" & Trim(vItem) & "','" & Trim(vBulkQty) & "','" _
        & Trim(vBaseUnit) & "','" & Trim(vEachQty) & "','" & Trim(vEachUnit) & "')"
 
        Dim sqlCom As New SqlCommand(Insert, conn)
        sqlCom.ExecuteNonQuery()
       Dim vCustomer, vBulkQty, vItem, vBaseUnit, vEachQty, vEachUnit As String
       
        vCustomer = dgCustomers.CurrentRow.Cells(0).Value
        vItem = dgItems.CurrentRow.Cells(0).Value
        vBulkQty = dgItems.CurrentRow.Cells(3).Value
        vBaseUnit = dgItems.CurrentRow.Cells(4).Value
        vEachQty = dgItems.CurrentRow.Cells(5).Value
        vEachUnit = dgItems.CurrentRow.Cells(6).Value

        Dim Insert As String

        Insert = "INSERT INTO OTM_ORDERS(CustomerID,ItemNo,BulkQty,BaseUnit,EachQty,StockUnit) " _
        & "VALUES ('" & Trim(vCustomer) & "','" & Trim(vItem) & "','" & Trim(vBulkQty) & "','" _
        & Trim(vBaseUnit) & "','" & Trim(vEachQty) & "','" & Trim(vEachUnit) & "')"

        Dim sqlCom As New SqlCommand(Insert, conn)
        sqlCom.ExecuteNonQuery()

The problem is that although there doesn't seem to be anything wrong with the code I get an unhandled SQLException on the sqlCom.ExecuteNonQuery() statement that says "Invalid object name 'OTM_ORDERS'."

I've already created this table using SQL, so why am I not able to insert data into it?

Last edited by bajanpoet; Feb 10th, 2009 at 4:01 pm. Reason: these damn code tags.... argh

Similar Threads

Simple ASP.Net Login Page using C# in C#
Updated : Simple ASP.Net Login Page in ASP.NET
explorer.exe using major memory and is misfunctioned in Viruses, Spyware and other Nasties
How in save data from a text box into table at vb 2005 in VB.NET
my log... scaned with dss.exe and hijackthis in Viruses, Spyware and other Nasties

bajanpoet

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

96 posts
since Sep 2006

Permalink

Feb 13th, 2009

Re: Invalid Object error, yet Table already created.

Hello.
Can you show which do you use connection string with your database? Please ensure your connection string is correct.

Cheers

Rogachev

Reputation Points: 11

Solved Threads: 9

Light Poster

Offline

44 posts
since Nov 2008

Permalink

Feb 13th, 2009

Re: Invalid Object error, yet Table already created.

The connection string is correct. I can pull information from the same database and display it - I am trying to save the information taken from one table into a newly created table.

bajanpoet

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

96 posts
since Sep 2006

Permalink

Feb 13th, 2009

Re: Invalid Object error, yet Table already created.

Just to let you know, everyone, that the code was correct. When I ran the code to create the table, it was created on the wrong server... so when I ran it, the application was looking for the created table on the wrong server. It's working as expected now.

Sorry for any inconvenience...

bajanpoet

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

96 posts
since Sep 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Barcode basics

Next Thread in VB.NET Forum Timeline: VB Array values

DaniWeb Message

Cancel Changes

User Name
Password