How to generate XML from a dataset and vice versa?
Answers were Sorted based on User's Feedback
Answer / vijay
DS.ReadXML reads XML document and writes to Dataset
DS.WriteXML writes XML document from Dataset
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / spvarma
dataset has read xml and write xml methods.
if datset ds then
ds.readxml(option,filepath)
ds.writexml(option,filepath)
Is This Answer Correct ? | 1 Yes | 2 No |
WHAT Are the major major compnents of a data provider in ADO.net.
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
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is the namespace in which .NET has the data functionality classes?
When we are running the Application, if any errors occur in the Stored Procedure then how will the server identify the errors?
Which object needs to be closed?
What is data adapter in ado.net with example?
How to retrieve the third table value from the data set?
How does ado.net work?
What is the use of sqldatareader class?
What is the difference between OLEDB Provider and SqlClient?
What are the several execute methods of ado.net?