There are quite a few possible problems, like:
- The condition of the query causes no rows to be returned
- The table is empty
- The ComboBox1 isn't actually the correct object and so on
Also you seem to call the data table's Load method twice. Never tested, what happens if the load is called the second time with the same reader....
Anyhow You should us the debugger to see what actually happens. Place a breakpoint on the first line and go through the code step-by-step. Using the debugger, investigate what is the content of different variables, does the query return rows and so on.
But actually before doing even that, I would suggest the following modifications:
- Instead of using the reader and loading the data table, I'd use SqlDataAdapter, define the SelectCommand[^] and use the SqlDataAdapter.Fill[^] to populate the data table.
- I suggest renaming the objects to something meaningful instead of the default names like ComboBox1. This helps to understand the code and also to spot errors.