Answer / shobana

RAW

The RAW mode takes the query result and transforms each row
in the result set into an XML element with a generic
identifier row as the element tag and the columns in the
SELECT as attributes.

AUTO

The AUTO mode returns query results in a simple, nested XML
tree. Each table in the FROM clause for which at least one
column is listed in the SELECT clause is represented as an
XML element. The columns listed in the SELECT clause are
mapped to the appropriate element's attributes. The columns
can be optionally mapped to subelements. The nesting of the
elements or hierarchy in the result set is based on the
order of tables identified by the columns specified in the
SELECT clause. The leftmost table will be the top element.
The second leftmost table (identified by columns in the
SELECT statement) will be nested within the top element, and
so on.

EXPLICIT

In EXPLICIT mode, you can explicitly define the shape of the
resulting XML tree. Using this mode requires that the
queries be written in a specific way, so that additional
information about the desired nesting is specified
explicitly as part of the query.

How to identify the controls which can be used for binding data?

0 Answers  

---

Explain the difference between an ado.net dataset and an ado recordset?

0 Answers  

---

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

---

What is a database provider?

2 Answers   BioSys,

---

Which is faster datareader or dataadapter?

0 Answers  

---

What is Serialization in .NET? what are the types of Serialization?

0 Answers   Arigo Infotech,

---

Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  

---

What is ado asp?

0 Answers  

---

What is the use of sqldatareader class?

0 Answers  

---

How to load multiple tables into a dataset?

0 Answers  

---

How would you connect to a database by using .NET?

0 Answers  

---

Explain the namespaces in which .net has the data functionality class.

0 Answers  

---