Hi there, sorry if this is the wrong forum to post it in. i do apologise


i need some help using asp.net and vb.net....

basically im trying to get a set of results back from SQL.

i know i have to use the data adapter/dataconnection but for some reason it says that i need to initialize the connection/fill/dataset? command?

i cant remember exactly since its at another computer which is out of reach from me.

1) how would u go about retrieving data from SQL using the SelectCommand? and then displaying them of course on the asp.net page in a nice formatted way?

2) once that is done, how would u place a button (like edit or delete) next to each record that is being displayed?

3) when the items are displayed under each column heading (like ID, name,manufacturer etc...) how can i make a link or something that sorts them? so when the click on the link once, it sorts the results that are retrieved in ASC/DESC order (depending if they clicked the first time or not, if they did, sorts them in ASC otherwise in DESC)

i am new to this technology so please forgive me with the stupid Q

thanks