Student Academic blog

DECLARE @FilePath VARCHAR(100)
DECLARE @xml XML
SELECT @FilePath = 'C:\a.xml'
 
--Stuff xml from flat file into a form that sql can work with
SELECT @xml = BulkColumn FROM OPENROWSET
(BULK 'C:\a.xml', SINGLE_BLOB) AS CustomerXML
 
--Insert xml data into worker table
--INSERT INTO #ImportCustomers
SELECT
x.value('to[1]', 'VARCHAR(100)'),
x.value('from[1]', 'VARCHAR(100)')
FROM @xml.nodes('/notes/note') notes(x)

DECLARE @xml xml
SET @xml = N'<polist>
               <po ponumber="100" podate="2008-09-10" />
               <po ponumber="101" podate="2008-09-11" />
             </polist>'
SELECT
 doc.col.value('@ponumber', 'nvarchar(10)') ponumber
,doc.col.value('@podate', 'datetime') podate
FROM @xml.nodes('/polist/po') doc(col)

DECLARE @DocHandle int
DECLARE @XmlDocument nvarchar(1000)

SET @XmlDocument = N'<polist>
<po><ponumber>100</ponumber><podate>2008-09-10</podate></po>
<po><ponumber>101</ponumber><podate>2008-09-11</podate></po>
</polist>'

EXEC sp_xml_preparedocument @DocHandle OUTPUT, @XmlDocument

SELECT * FROM OPENXML (@DocHandle, '/polist/po',2)
WITH (ponumber nvarchar(10),
podate datetime)

EXEC sp_xml_removedocument @DocHandle

posted by Aamir Hasan

Student Acdemic Blog

ALL, SQL 2005 & 2008

int intImageSize = default(int);
        string strImageType = null;
        Stream ImageStream = default(Stream);

        FileUpload fileUpload=null;
        for (int index = 0; index < 10; index++)
        {
            fileUpload=Page.Form.FindControl("UploadFile" + index.ToString()) as FileUpload;
            // Gets the Size of the Image  
            intImageSize = fileUpload.PostedFile.ContentLength;

            // Gets the Image Type  
            strImageType = fileUpload.PostedFile.ContentType;

            // Reads the Image  
            ImageStream = fileUpload.PostedFile.InputStream;

            byte[] ImageContent = new byte[intImageSize + 1];
            int intStatus = 0;
            intStatus = ImageStream.Read(ImageContent, 0, intImageSize);

            comm = new SqlCommand("INSERT INTO Images (image, image_type, eventID) VALUES (@image, @image_type, @eventID)", conn);
            comm.Parameters.AddWithValue("@image", ImageContent);
            comm.Parameters.AddWithValue("@image_type", strImageType);
            comm.Parameters.AddWithValue("@eventID", Convert.ToInt32(eventIDLabel.Text).ToString());
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
        }

ALL, asp.net, SQL 2005 & 2008 asp.net, csharp, sql,