Convert varbinary back to .txt file

Question

I have a database (SQL 2008) where I store file's in. These are saved as a varbinary(max) type.

Now I need to get the .txt file again so I can loop through the contents of the file like i used to do with StreamReader.

while ((line = file.ReadLine()) != null)
{
string code = line.Substring(line.Length - 12);
}

But how can I convert the varbinary byte[] back to the normal .txt file so I'm able to go through the contents line by line.

I found some ideas with memorystream or filestream but can't get them to work.

Thanks in advance!

See the answers to this question to know how to convert it back to string: http://stackoverflow.com/questions/4959253/converting-sql-server-varbinary-data-into-string-c-sharp — Shadow The GPT Wizard, Oct 18 '11 at 07:13

score 5 · Accepted Answer · answered Oct 18 '11 at 07:15

5

MemoryStream m = new MemoryStream(byteArrayFromDB);
StreamReader file = new StreamReader(m);
while ((line = file.ReadLine()) != null)
{
string code = line.Substring(line.Length - 12);
}

answered Oct 18 '11 at 07:15

Ovidiu Pacurar

8,173
2
30
36

well, that was easier than I thought, had to make it way to complicated for me Although I noticed that there are inserted white spaces at the end of the lines and another white space between every line. But that's easy fixed. Thanks! – Robin Oct 18 '11 at 08:34

score 4 · Answer 2 · answered Sep 17 '14 at 04:49

cv is a varbinary(max) field

SqlCommand sqlCmd = new SqlCommand("SELECT cv FROM [job].[UserInfo] Where ID = 39 ", conn); 
SqlDataReader reader = sqlCmd.ExecuteReader(); 

if (reader.Read() != null)
{
    byte[] buffer = (byte[])reader["cv"];
    File.WriteAllBytes("c:\\cv1.txt", buffer);
}

score 4 · Answer 3 · answered Oct 18 '11 at 07:15

4

try this:

System.IO.File.WriteAllBytes("path to save your file", bytes);

answered Oct 18 '11 at 07:15

ojlovecd

4,812
1
20
22

score 0 · Answer 4 · answered Dec 06 '15 at 14:53

    static void Main(string[] args)
    {
        GetData();
    }
    public static void GetData()
    {
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["main"].ConnectionString);
        conn.Open();
        string query = "SELECT FileStream FROM [EventOne] Where  ID=2";
        SqlCommand cmd = new SqlCommand(query, conn);

        DataTable dt = new DataTable();
        dt.Load(cmd.ExecuteReader());
        byte[] buffer = dt.AsEnumerable().Select(c => c.Field<byte[]>("FileStream")).SingleOrDefault();
        File.WriteAllBytes("c:\\FileStream.txt", buffer);
    }

Convert varbinary back to .txt file

4 Answers4