jquery populate text input from table based on select value

[Csharper]

I have a form which contains a select named Client_ID as well as some other text inputs. What I need is that when a user selects a Client_ID, my fields Address1, Address 2 etc should be populated with the result of a database query along the lines of \[code\]SELECT Address1, Address2 from Client where Client_ID = Client_ID\[/code\]I'm aware this is somewhat of a noob question, but would really appreciate some help on the simplest and best way to do this.