can someone help me? i need a procedure that can quick short data in a datagrid by clicking on a column?Please advice

i also have another problem! when i want to create a database application i usually use Data Form Wizard because its faster... when i tried to do this by hardcoding i did the following

i created a connection(jet 4.0 access 2000) and a recordset (SELECT * FROM SOMETHING).then i created a datagrid..when i tried to do this
: Set DataGrid.DataSource=MyADOconnection

i recieved a type mismatch error. i saw the code in the data form wizard and it was exactly the same.... WHAT WRONG?
PLEASE HELP