Hi,

(Using SQL Server, Visual Web Developer Express, VB, .NET 2.0)

I have a form that sends 3 parameters to a Stored Procedure and returns it to a DataGrid, the Grid is bound to the Stored Procedure.

One of the values returned can be -9999, when the Grid is rendered I want any occurence of -9999 to come up as blank.

My VB is not great! The Grid is "GridView1".

Thanks!

I think you just need an if statement in your code behind for the data grid.

If @parameter = -9999 Then
       @parameter = ""
End If

Something like that I think.

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.