Hi, i just want to ask why this error mean?

InvalidOperationException was unhandled by user code

The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value

hope to have some sharing if u all had experienced this n how to handle?

This means that a SQL Command was executed outside of a try catch structure and got an error.

it would be easier to verify what gone wrong if you post some snippet of your codes

what do you mean regarding " executed outside of a try catch structure"

This means that a SQL Command was executed outside of a try catch structure and got an error.

... so you created a row, didnt set a default value for the columns, and a consumer pulled the row from the database?

i dont really know what you mean

but if im right, you could possible do these two things:

set your default values in your database, ex. string is '' double is 0.0 int is 0 etc.

in your .net code add .tostring to the end of your column retrieve.

rs.fields(x).value.tostring

i dont know

add option strict on , youll fix alot of problems

If you could post a snippet of your code, that would be helpful :)

Also, if you're using SQL Server 2005, try running a trace on the database to see what its actually trying to execute (if anything at all).

It's very useful for correcting syntax problems etc.

this is my code

SELECT Referential.StockCode AS [Stock Code], Referential.StockLongName AS [PLC Name], Referential.StockShortName AS [PLC Short Name], Referential.Sector, Referential.SubSector AS [Sub Sector], Referential.Board, MI2006.[Movement in Inventory] AS 2006, MI2007.[Movement in Inventory] AS 2007, MI2008.[Movement in Inventory] AS 2008, MI2009.[Movement in Inventory] AS 2009, MI2010.[Movement in Inventory] AS 2010
FROM MI2010 INNER JOIN (MI2009 INNER JOIN (MI2008 INNER JOIN (MI2007 INNER JOIN (MI2006 INNER JOIN Referential ON MI2006.[Stock Code]=Referential.StockCode) ON MI2007.[Stock Code]=Referential.StockCode) ON MI2008.[Stock Code]=Referential.StockCode) ON MI2009.[Stock Code]=Referential.StockCode) ON MI2010.[Stock Code]=Referential.StockCode;

it would be easier to verify what gone wrong if you post some snippet of your codes

What is the VB.Net code relating to that query?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.