retrieve image datatype and store it as a file

  • Thread starter Thread starter kabin selvam
  • Start date Start date
K

kabin selvam

Hi,

my scenario is like this, I have my document (word.or
excel or pdf) stored a s a binary value(image datatype) in
database, I need it to convert back into thedocument and
save it as the file in my local system,

Is there any way of retrieving the image datatype and
store it as a file in our local system in c#

regards,
Kabin
 
Hi,

I'd introduce an additional column in the data table describing the type of
the binary data stored.
The values in this column would most likely serve as foreign keys into a
dedicated dictionary containing all possible image types.
 
Hi,

I do have a column named mime type which has the types like
html/word,text/plain etc.

my code is like this

string connstr="server=knowsys-server2;database=Argos;uid=sa";
string sql="SELECT AttachFilename,Attachment, MimeType FROM
EmailAttachments WHERE AttachmentID = 7";
SqlConnection connection = new SqlConnection(connstr);
SqlCommand command = new SqlCommand(sql, connection);
connection.Open();
SqlDataReader dr = command.ExecuteReader();
System.Byte[] bytPassword = null;
string imgPassward = "";

while(dr.Read())
{
bytPassword =
(System.Byte[])dr.GetValue(dr.GetOrdinal(("Attachment")));
}

dr.Close();

imgPassward =
Encoding.ASCII.GetString(bytPassword).ToString().Trim();
//string imgPasswa = Convert.ToBase64String(bytPassword);
//imgPasswar = (Encoding.UTF8.GetDecoder());
Response.Write("atlast the string value is " + imgPassward);


but this works for only html\text types , for other types it returns me
an error.

it would be much helpfull if you could help me to solve this retrieving
problem

thanks,
kabin.
 
Back
Top