That needs a little work: you don't need to use a DataAdapter, and you don't need to return the dress name - you already know that!
Instead, consider returning a COUNT, and use the ExecuteScalar method on the command to return a number directly.
But ... you also need to think about your conditions rather more carefully: just checking and existing "take date" isn't between the start or end of teh required hire period isn't going to work:
Existing hire: 1st to 10th March.
Required hire: 5th to 15th March.
Will immediately return no rows and you will say that that is ok, despite the dress needing to be in two places at the same time...
I'd suggest that you sit down with a pen and paper, and work out all the possible permutations and see if you can come up with conditions which fit all of them before you rush into code.