Francisco Tapia
fhtapia at gmail.com
Wed Jul 29 23:38:45 CDT 2009
Hi, I've not been active on this list at all, but I do have a quick question someone here may have already ran into. I am working on an ASP.NET (visual studio 2008) and I created a few pages that all work fairly similarly, where there is a GridView on the main Entity page, and Add pages along with Edit pages created with Details View controls. In the GridView page, I add an edit button and the link points the ~/language/EditLanguage.aspx?intLanguage={0}. On the receiving page I edited the SELECT command with the proper WHERE clause as WHERE intLanguage= @intLanguage. The QueryStringParameter is as follows: <SelectParameters> <asp:QueryStringParameter Name="intLanguage" QueryStringField="intLanguage" /> </SelectParameters> so this is the same for my other pages such as my Release page and my Category page and both work fine, but the language page is different... the PKID is the intLanguage field, but it's not an autoincremented number (since this project is still in it's infancy, I've thought about adding a true surrogate PKID and see if that is the problem... note, If i edit the select command w/o the where, the page loads fine (well w/o the parameter being passed so my DetailsView control only displays the first record in the recordset, I'm new to ASP.NET and don't really know how to troubleshoot this.... any ideas? -Francisco http://sqlthis.blogspot.com | Tsql and More...