rule of DataAdapter

[messages]

Hi everyone I have a question,is it correct connected data objects consist of connection,command,reader and dataadapter(why we need to DataAdapter in a connected model?),transaction,.... disconnected data objects consist of dataset,dataTable,datarow,dataadapter so we have two main models connected and disconnected. what is the rule of DataAdapter in connected model? why do we need to use of a dataadpter to fill a dataset like this in a connected model?

.....
sqlDataAdapter = new SqlDataAdapter(cmdString, sqlConnection);
sqlDataAdapter.SelectCommand = sqlCommand;
SqlDataAdapter sqlDataAdapter;
sqlDataSet = new DataSet();
sqlDataSet.Clear();
int intValue = sqlDataAdapter.Fill(sqlDataSet);

is it right we are shifting of connected model to disconnected model,if yes why?

[PIEBALDconsult]

I would not include DataAdapter in the "connected" category. The "connected" paradigm is still appropriate for many applications, but less so with distributed applications. DataAdapters cause me nothing but trouble; I don't use them. X|

[messages]

Is it correct we can fill a dataset with connected objects(connection,command,dataadapter) and without them(with data source window)? if yes so we are using of the connected objects to fill a disconnected object(dataset),right?

[PIEBALDconsult]

DataAdapters enable the disconnected paradigm.

[messages]

And we can use of it form programming (dataset dt=new,....) and from toolbox in the visual studio,right?