-
vb.net and asp.net
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 :)