ID); This results in a Null reference exception (it hasnt been found) Please any ideas? runat="server" Allow Paging="True" Allow Sorting="True" Data Source ID="Sql Data Source1" Cell Padding="4" Fore Color="#333333" Grid Lines="None" Auto Generate Columns="False" Font-Size="X-Small" Height="356px" Width="2696px" Is it generating the edit button in the first column (default)? Edit: never mind, this is in the row editing event - the cell hasn't generated the edit template yet I don't think. I'm giving examples, not typing up your whole app for you. Replace("'", "''") & "'" End If End If Also if i use that, then upon loading of the page, it executes the SELECT command w/c gets all the data from the sql db. user either input strings or upload a text file with strings to parse. page would read the strings from either text box or text file then do a SELECT FROM from the sql db what i would like is upon loading, it wouldn't query the sql db.the datagrid wouldn't show up since it doesn't have any data in it.I have a gridview with template field on column 2 and 4. i've also used msgbox to output all column four's control ID and it's returning nothing.I need to get the control (dropdownlist and textbox) on these columns so that I could get their values to update SQL DB. Whois FROM tb_entity INNER JOIN tb_comments ON tb_= tb_comments. I think you're referring to Item template here.Entry, (SELECT avg(rating) FROM tb_comments WHERE " _ & "tb_comments.entry=tb_entity.id) as Rating, tb_kind. Info " _ & "FROM tb_entity INNER JOIN tb_hijack ON tb_= tb_hijack. Kind = tb_" _ & "WHERE tb_entity.entry='" & strline.
If this post contains any code, I may or may not have tested it.
when i use smart tag, upon loadng of the page, it queries all data in the db and show it to the page i don't want that to happen.
i mean i could hide the gridview upon loading but still, it would query the sql db and i don't want the server to have that burden.
i've already used find control and it's not finding it.
the reason behind why i can't use the smart tag is because upon loading of the page, it would accept strings or text file to parse then from there, it would query the sql db.