how to read data from a datatable using query consisting parameters in ADO.net connected mode

I am new to ADO.net. I have learned programming in Connected mode. Now i am learning ADO.net disconnected mode. I am facing a problem now:- I have a datatable name "Info". It has four fields :- "ID","Name","Address". Now i want that when user write a ID number and click on button then other two textboxes will show corresponding Name and address. I think SQL statement should be like

SqlCommand cmd = new SqlCommand();
    Cmd.CommandText = "Select Name, Address from Info where ID = @id";
    cmd.Parameters.AddWithValue("id", TextBox1.Text);

I am writing above code using my connected mode ADO.net Experience. We used a Datareader in Connected mode. But we cannot use DATAREADER in Disconnected mode so how can it be done. Please help me..

Also told me a good link where i can learn INSERT, UPDATE and Delete operation using (i)SQLDataAdapter (ii) SqlCommandBuilder

I have googled alot for good tutorial but everyone has own style of coding and logic therefore i am really confused...

Tags: SQL, ADO.NET