I couldn't quite tell what language you are using, but regardless, you'll need to create a connection, command and execute the command. Once you can do this, we can add to the process to get what you want. It will be something similar to this: Dimension and set the propertites of your conn object Dimension and set the properties of your command object Get a reference to the datatable returned Do your stuff There should be plenty of examples of getting a datatable/dataset and looping to do your stuff. Post your code and we can go from there!
|