Access SQL in code behind
-
I normally just use code behind to create a SQL statement and assign it to a SqlDataSource SelectCommand then to a Repeater, GridView, etc. So far it's all worked great. Now I need to access the data ans manipulate it in the code behind (so far I use VB.NET but any language will work). I'm at a loss for how to do this. I've done what I want to back in the day of ASP, but I don't want to use old code (or the aspcompat=true statement). Anyone have a good page I could read or a quick example.
-
I normally just use code behind to create a SQL statement and assign it to a SqlDataSource SelectCommand then to a Repeater, GridView, etc. So far it's all worked great. Now I need to access the data ans manipulate it in the code behind (so far I use VB.NET but any language will work). I'm at a loss for how to do this. I've done what I want to back in the day of ASP, but I don't want to use old code (or the aspcompat=true statement). Anyone have a good page I could read or a quick example.
-
It will be a static SQL Select statement but I want to run it, assign it to an array and manipulate it all in code behind. Then assign the array to a GridView, Repeater, etc. to display.
-
It will be a static SQL Select statement but I want to run it, assign it to an array and manipulate it all in code behind. Then assign the array to a GridView, Repeater, etc. to display.