You can use the DataSource Control

or you can code it using the SqlDataAdapter objects
shabbir like this