GridView Wont load.

[kralco626]

I have a gridview on my "second" page with a SqlDataSource. The data source is configured to take the qurry string "arg" from the url and run a stored procedure with it.

On the "first" page i have a gridview and one collumn is links. Click on this link and it sends you to the "second" page with the qurry string in the url.

This is the buttonlink event code

if (e.CommandName == "AssetName")
        {
            Response.Write("<script type='text/javascript'>window.open('UsageInformation.aspx?arg=" + e.CommandArgument + "','_blank');</script>");
        }

So when i click on the buttonlink on the "first" page I get a new window with the correct url:

http://localhost:4513/WebSite2/UsageInformation.aspx?arg=XFM_UG:#306:100099462

but the gridview does not load. I can in fact open a new browser and put this url into it and the same thing happens. Everything else on the page loads but the gridview! It's like the sql data source is not passing any information or it is using a null qurry string. But the qurry string is not null.

Thanks in advance for any help!

[kralco626]

If you think the asp sqldatasource code might help here it is. Need anything else please let me know.

<asp:SqlDataSource ID="SqlFPDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" 
            CancelSelectOnNullParameter="false"
            SelectCommand="MyStoredProc" 
            SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="" Name="deviceAlias" 
                    QueryStringField="arg" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>

[kralco626]

Alright!
Good news is that i found the problem!
Bad news is that I have no idea how to fix it!

So in the page_load method I put the following code

string test = Server.HtmlEncode(Request.QueryString["arg"]);

and test was only equal to: XFM_UG:
When I changed my code to do a response.redirect rather than a response.write I get this as my value: XFM_UG:#306:100099462

So the question is... why is my query string different with exactly the same url?!?!?

Thanks so much for any help!

[kralco626]

SOLVED:

All I had to do was replace the "#" with "%23" just did a

newString = oldString.replace("#","%23");

And that took care of it. Very odd though, it did not need to be excaped when i did the response.redirect only the response.write...? well anyways it works.
The ":" character gets excaped automatically, which is the wierdest thing.

Well anyways. Thats the solution.

[dsweb1017]

Is the query string your second grid is expecting correct? i.e. RowID

Have you tried entering the query string manually using a known RecordID in the database and see if that works.