Can anyone help of this problem in vb.net 2008! The Problem is error message when i used insert in dataset!?

Question

Executed Sql Statement: Insert into e.ngas(staus, agency) values (@status, @agency)

Error Source: Sql Server Compact ADO.NET Data Provider

Error Message:The table name is not valid.[ token line number (if known) = 1, Token line offset(if known = 15, Table name = NGAS ]

Answer 1

Try this:



Insert into [e.ngas](staus, agency) values (@status, @agency)

Answer 2

Hi,Rafael O



There are 3 step to repair vb.net 2008 error



My friend had the same problem with you. I am sure your computer has registry problems.It is very easy to repair vb.net 2008 error. you just need 3 steps:



1: Download a registry cleaner and install it.

2: Open the registry cleaner and scan you computer for free.

3: Click fix button and you done.



Download the top vb.net 2008 error repair tool here:http://www.fixerrorquick.com/ttfix-vb.net_2008_error-zz0001

Answer 3

you may desire to examine my e book. the finest thank you to debug an sq. string is to confirm it. this is, unload the string to a Messagebox or to debug.print and look to confirm what's being generated. on the grounds which you have shortened the string that is annoying to inform what's incorrect. I propose utilizing a Parameterized Command somewhat of an advert hoc sq. (as you have executed). subsequently you create a separate Parameter merchandise for each parameter in the INSERT fact and (whilst it comes to OLE DB) positioned a "?" somewhat of the textBox fee. each Parameter.fee is desperate to the TextBox.text textile basically in the past executing the Command. See ADO and ADO.internet Examples and ultimate Practices. there's a VB.internet and a C# version (besides as a VB6 version "ADO Examples and ultimate Practices". hth