send xml file to database

Question

El salaam alekom

I have XML file, i want send it to database of my web site to use it again on site
How can i make application by C# to send xml file to my sql server of web site ?

Answer 1

Use blob cloumn..

Answer 2

thank you,
but there are more details !

Answer 3

What do you mean with "There are more details?"

---

Ewald - Please remember to mark the replies as answers if they help.

Answer 4

 

Ewald Hofman said:

What do you mean with "There are more details?"

---

Ewald - Please remember to mark the replies as answers if they help.

i don't know how work withe blob column in my code

Answer 5

Just create a column in the database with the TEXT datatype.

---

Ewald - Please remember to mark the replies as answers if they help.

Answer 6

There are multiple ways of doing this. It depends on the SQL Server version you are using and if it supports the type.

example, if you are going to be storing just pure XML, just store it in the XML field, which is a datatype in SQL Server 2005 and higher.

otherwise, if you just want to store that but the datatype isnt supported, or you want to store any file, then create a Binary column, and then get the bytes[] of the assembly/file and then insert that into the database.


// example:

private byte[] GetFileBytes(string fileNameAndPath)
{

   FileStream fs = System.IO.File.Open(fileNameAndPath, FileMode.Open);

   byte[] fileInfo = new byte[fs.Length];

   int read = fs.Read(fileInfo, 0, (int)fs.Length);

   fs.Close();

   return fileInfo;
}



Then after that, simply call the method, get the bytes of the file, and insert into the database.

Does this help?

---

Need 2 be back @ MS - MS All the way! Follower since 1995 MS Super Evangelist| MSDN Forums Moderator