howto access html sqldatasource info from code
Is there any way of accessing the information selected by a sqldatasource control in the html area from the codebehind area?
so for example i have an sqldatasource setup as so:
<asp:SqlDataSource ID="SqlLocations" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [id], [companyname], [address], [city], [province], [postalcode], [contact], [phonenumber], [faxnumber], [contactemail] FROM [locations] WHERE [id] = 1">
and from the code area i want to access what information was selected for [companyname] or [address]
anybody know of how to accomplish this?