populate text box from sql

when my page opens how i can i auto-populate a text box from a value that is passed from a stored proc?On your Form_Load, grab the data from the stored proc, set your textbox equal to the value it returns.