Hi,

I'm not sure what the C# equivalent of this is, but it's probably not too much different (drop the dim, set the string setting in front):


Dim strX as STring
strX =...

EDIT TO THE FOLLOWING:

Sorry, I thought by the thread name you were having trouble accessing the value of a hidden column. The code string you are looking for is:


e.Columns[7].Visible =...

Hi,

Thanks all. The problem ended up being the EXEC method. Admittedly, using dynamic SQL is not the most efficient method, the only reason I ended up going with this route is i needed a query...

No, it didn't even get blank columns back. I tried running it without using any page variables, only preset variables, but it still couldn't bring in anything. I'll have to find out if it's even...

Hi,

I wrote a query statement in SQL server to take paramaters, and generate then run a sql statement based on which criteria were provided. The tables got pretty massive so I need the query...