How to search custom table from custom Web Part

Hi All,

Trying to replicate the way our Find A Reseller" feature works on our old site.

Basically you type in your postcode or suburb and it will return a list of resellers near you.

I have created a custom table to hold all our resellers details and I have created a custom web part to mimic this UI.

Can someone point me in the direction of a tutorial or article on how i go about searching the custom table in Kentico from a webpart code behind?

I have looked on DEVNET docs and it covers the basic Hello World. Cant seem to find anything on other methods or examples.