UPDATE. I think I got it although in both C# and in SQL Server I don't really see the rest of the string after the GRAPHIC1 part.
I also made an assumption that we only have up to 9 graphic files. I think I may also need to restrict that number on the File Upload as well.
Hi everybody,
I have SQL Server varbinary(max) column which I read in C# code as byte[] array. If I run the following query in SQL Server:
select *, cast(graphics as varchar(max)) as pic from dbo.Layouts I can see the following format (showing just beginning of the string)
<GRNAME1>"gcaplogo2015.jpg"</GRNAME1><GRAPHIC1>ÿØÿà
So, the varbinary column saves picture files and it saves it in the format of
<grName1>fileName1</grName1><Graphic1>actual graphic</Graphic1>...
I'm going to worry about saving the files in this format a bit later, but for now I need to figure out how to get all the file names.
Do you have some suggestions for me?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog