Dynamic Datagrid not showing up

[NeoPa]

When you've done that I'll see what I can find that might explain the strange goings on. I must admit that I'm still only using MS-SQL 2K though, so there may be differences. Let's see what we have when we have it.

PS. Obviously don't lose what you have already. Do the debugging in a copy. It's often a single, simple change that's required after the problem is found and understood.

[nickvans]

Well, I did what NeoPa suggested and created a dummy stored procedure that was far simpler. I discovered two things.

1) For some reason, setting acceptable default values on the SQLServer side caused Visual Studio get angry and not display the gridview. As I said in my first post, the default values were acceptable and running the stored procedure with those default values caused the procedure to run correctly, so I'm at a bit of a loss.

2) If the stored procedure expects an argument that isn't specified when running a funky procedure like mine (that is, creating a string then executing it) it seems Visual Studio will ignore it completely. I discovered that if I don't specify a certain value (assigned_to_BE MSID) then the gridview just doesn't show up.

I have a bit of debugging to do yet. If I change values on my front end and say click my run button, the gridview doesn't refresh. If however I save those changed values as defaults (which runs a stored procedure to save them to a table on the SQL Server side) then run using default values, it does update.

EDIT: Turns out I'm tired and didn't have a control set for that variable in the SqlDataSource. I'm going to go home now.

In any case, thank you both very much for your help! I really appreciate the time you took trying to help a newb web designer.

Cheers!

[NeoPa]

Sleeping on it, is another very handy technique to help solve various problems. This is often associated with arcane magic, as the power to fix even the most convoluted problems is quite surprising ;)

Good luck and see what a fresh brain brings you tomorrow.