difference oraclecommand oracledataadapter

whats is difference between oraclecommand oracledataadapter

can both be used at once
please give an example
DOT_NETAsked:
Who is Participating?
 
tomasX2Commented:
a commands main purpose is to execute sql statements or stored procedures.
a dataadapters main purpose is to work with datasets

oracledataadapter needs oraclecommands to do it´s stuff and is nearly useless without one...
it has 4 command objects, selectcommand, deletecommand, insertcommand and updatecommand

you can and need to use both at once whenever you use a dataadapter.

  public DataSet SelectOracleSrvRows(DataSet dataset,string connection,string query)
{
    OracleConnection conn = new OracleConnection(connection);
    OracleDataAdapter adapter = new OracleDataAdapter();
    adapter.SelectCommand = new OracleCommand(query, conn);
    adapter.Fill(dataset);
    return dataset;
}

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclientoraclecommandclasstopic.asp

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.