What exactly is the select statement supposed to be doing?
"Select * from [ApplicationLogging] where AppName = AppTest"
This looks like it trying to select all fields from a table named "ApplicationLogging" where the data in a column named "AppName" is equal to the data in a column named "AppTest".
If you were trying to setup AppTest as a parm...look at what your insert statement is doing. It uses four question marks to establish what the parms are, and then you had to set them in code. You would do something similar to that with your select statement. It would look like this:
"Select * from [ApplicationLogging] where AppName=?"
Then before calling the fill you would do this:
SelectQuery.Parameters.AddWithValue("AppTest", AppTest)
Also...I'm not sure why you have an execute reader statment in there for the select query....I don't think you need it. Just set up your DataAdapter and do the .Fill.
If you want more examples, try
google.[
^].
Here[
^] is one example I found.
Here[
^] is another.
Hope this helps.