I use a Panel Control to add a image or even stream video, but you can save the image on SQL Server as Image or MySQL as largeblob. This code works for me a lot. Check it out.Here you save the image MemoryStream ms = new MemoryStream;Bitmap bmp = new Bitmap(panel1.Width, panel1.Height);panel1.DrawToBitmap(bmp, panel1.Bounds);bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); // here you can change the Image formatbyte Picarr = new bytems.Length;ms.Position = 0;ms.Read(Picarr, 0, Picarr.Length);ms.Close;And here you can load, but I used a PictureBox Control.
MemoryStream ms = new MemoryStream(picarr);ms.Seek(0, SeekOrigin.Begin);fotos.pictureBox1.Image = System.Drawing.Image.FromStream(ms);Hope helps.
In this article, you will see how to read and write XML documents in Microsoft.NET using C# language.First, I will discuss XML.NET Framework Library namespace and classes. Then, you will see how to read and write XML documents. In the end of this article, I will show you how to take advantage of ADO.NET and XML.NET model to read and write XML documents from relational databases and vice versa.Introduction to Microsoft.NET XML Namespaces and ClassesBefore start working with XML document in.NET Framework, It is important to know about.NET namespace and classes provided by.NET Runtime Library.NET provides five namespace - System.Xml, System.Xml.Schema, System.Xml.Serialization, System.Xml.XPath, and System.Xml.Xsl to support XML classes.The System.Xml namespace contains major XML classes. This namespace contains many classes to read and write XML documents. In this article, we are going to concentrate on reader and write class.
These reader and writer classes are used to read and write XMl documents. These classes are - XmlReader, XmlTextReader, XmlValidatingReader, XmlNodeReader, XmlWriter, and XmlTextWriter.
As you can see there are four reader and two writer classes.The XmlReader class is an abstract bases classes and contains methods and properties to read a document. The Read method reads a node in the stream.
Besides reading functionality, this class also contains methods to navigate through a document nodes. Some of these methods are MoveToAttribute, MoveToFirstAttribute, MoveToContent, MoveToFirstContent, MoveToElement and MoveToNextAttribute. ReadString, ReadInnerXml, ReadOuterXml, and ReadStartElement are more read methods. This class also has a method Skip to skip current node and move to next one. We'll see these methods in our sample example.The XmlTextReader, XmlNodeReader and XmlValidatingReader classes are derived from XmlReader class.
Save Data To Xml File C#
As their name explains, they are used to read text, node, and schemas.The XmlWrite class contains functionality to write data to XML documents. This class provides many write method to write XML document items. This class is base class for XmlTextWriter class, which we'll be using in our sample example.The XmlNode class plays an important role. Although, this class represents a single node of XML but that could be the root node of an XML document and could represent the entire file. This class is an abstract base class for many useful classes for inserting, removing, and replacing nodes, navigating through the document.
It also contains properties to get a parent or child, name, last child, node type and more. Three major classes derived from XmlNode are XmlDocument, XmlDataDocument and XmlDocumentFragment. XmlDocument class represents an XML document and provides methods and properties to load and save a document. It also provides functionality to add XML items such as attributes, comments, spaces, elements, and new nodes.
The Load and LoadXml methods can be used to load XML documents and Save method to save a document respectively. XmlDocumentFragment class represents a document fragment, which can be used to add to a document. The XmlDataDocument class provides methods and properties to work with ADO.NET data set objects.In spite of above discussed classes, System.Xml namespace contains more classes. Few of them are XmlConvert, XmlLinkedNode, and XmlNodeList.Next namespace in Xml series is System.Xml.Schema. It classes to work with XML schemas such XmlSchema, XmlSchemaAll, XmlSchemaXPath, XmlSchemaType.The System.Xml.Serialization namespace contains classes that are used to serialize objects into XML format documents or streams.The System.Xml.XPath Namespce contains XPath related classes to use XPath specifications.
This namespace has following classes -XPathDocument, XPathExression, XPathNavigator, and XPathNodeIterator. With the help of XpathDocument, XpathNavigator provides a fast navigation though XML documents.
This class contains many Move methods to move through a document.The System.Xml.Xsl namespace contains classes to work with XSL/T transformations.Reading XML DocumentsIn my sample application, I'm using books.xml to read and display its data through XmlTextReader. This file comes with VS.NET samples. You can search this on your machine and change the path of the file in the following line:XmlTextReader textReader = new XmlTextReader('C:books.xml');Or you can use any XML file.The XmlTextReader, XmlNodeReader and XmlValidatingReader classes are derived from XmlReader class.
Besides XmlReader methods and properties, these classes also contain members to read text, node, and schemas respectively. I am using XmlTextReader class to read an XML file. You read a file by passing file name as a parameter in constructor.XmlTextReader textReader = new XmlTextReader('C:books.xml');After creating an instance of XmlTextReader, you call Read method to start reading the document. After read method is called, you can read all information and data stored in a document.
XmlReader class has properties such as Name, BaseURI, Depth, LineNumber an so on.List 1 reads a document and displays a node information using these properties.About Sample Example 1In this sample example, I read an XML file using XmlTextReader and call Read method to read its node one by one until end of file and display the contents to the console output.Sample Example 1. textWriter.WriteStartDocument;. textWriter.WriteEndDocument;. textWriter.Close;The WriteStartDocument and WriteEndDocument methods open and close a document for writing.
Save Xml Document To File System Download
You must have to open a document before start writing to it. WriteComment method writes comment to a document. It takes only one string type of argument. WriteString method writes a string to a document. With the help of WriteString, WriteStartElement and WriteEndElement methods pair can be used to write an element to a document.
The WriteStartAttribute and WriteEndAttribute pair writes an attribute.WriteNode is more write method, which writes an XmlReader to a document as a node of the document. For example, you can use WriteProcessingInstruction and WriteDocType methods to write a ProcessingInstruction and DocType items of a document. //Write the ProcessingInstruction node. string PI= 'type='text/xsl' href='book.xsl'. textWriter.WriteProcessingInstruction( 'xml-stylesheet', PI);. //'Write the DocumentType node. textWriter.WriteDocType( 'book', Nothing, Nothing, '
See Listing 5-14. In this sample example, we create a new xml file c:xmlWriterText.xml.
In this sample example, We create a new xml file c:xmlWriterTest.xml using XmlTextWriter:After that, we add comments and elements to the document using Writexxx methods. After that we read our books.xml xml file using XmlTextReader and add its elements to xmlWriterTest.xml using XmlTextWriter.About Sample Example 3In this sample example, I create a new file myxmlFile.xml using XmlTextWriter and use its various write methods to write XML items.Sample Example 3. //Create the XmlDocument. XmlDocument doc = new XmlDocument;.
doc.LoadXml(('Tommy. ex'));. //Save the document to a file. doc.Save( 'C:std.xml' );You can also use Save method to display contents on console if you pass Console.Out as aarameter. For example:doc.Save(Console.Out);About Sample Example 5Here is one example of how to load an XML document using XmlTextReader. In this sample example, we read books.xml file using XmlTextReader and call its Read method.
After that we call XmlDocumetn's Load method to load XmlTextReader contents to XmlDocument and call Save method to save the document. Passing Console.Out as a Save method argument displays data on the consoleSample Example 5.
XmlDocument doc = new XmlDocument;. //Load the the document with the last book node. XmlTextReader reader = new XmlTextReader( 'c:books.xml' );.
reader.Read;. // load reader. doc.Load(reader);. // Display contents on the console.
doc.Save(Console.Out);Writing Data from a database to an XML DocumentUsing XML and ADO.NET mode, reading a database and writing to an XML document and vice versa is not a big deal. In this section of this article, you will see how to read a database table's data and write the contents to an XML document.The DataSet class provides method to read a relational database table and write this table to an XML file. You use WriteXml method to write a dataset data to an XML file.In this sample example, I have used commonly used Northwind database comes with Office 2000 and later versions.
You can use any database you want. Only thing you need to do is just chapter the connection string and SELECT SQ L query.About Sample Example 6In this sample, I reate a data adapter object and selects all records of Customers table.
After that I can fill method to fill a dataset from the data adapter.In this sample example, I have used OldDb data provides. You need to add reference to the Syste.Data.OldDb namespace to use OldDb data adapters in your program.
As you can see from Sample Example 6, first I create a connection with northwind database using OldDbConnection. After that I create a data adapter object by passing a SELECT SQL query and connection. Once you have a data adapter, you can fill a dataset object using Fill method of the data adapter. Then you can WriteXml method of DataSet, which creates an XML document and write its contents to the XML document. In our sample, we read Customers table records and write DataSet contents to OutputXml.Xml file in C: dir.Sample Example 6.