How to get filebytes from dt.row["FileName"].ToString()

Sandeep kumar

5y898.NET

File.WriteAllBytes(Path.Combine(

ConfigurationManager.AppSettings.Get("DocumentPath").ToString(), randString + FileExtension), array[]);

i have a datatable which consist file name, from file name i want to know file bytes ,so that i pass a parameter into

below function.

File.WriteAllBytes(Path.Combine(

ConfigurationManager.AppSettings.Get("DocumentPath").ToString(), randString + FileExtension), ?);

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta5y ago
Hey Sandeep

When you had saved in the db as a bytes (varbinary) format then, it doesn't required .ToString() to convert to string and then convert it to bytes[], you can directly convert it implicitly like below
var data =  dt.row["FileName"];
if(data!= DBNull.Value)
{
      var FileData = (bytes[])data;
      // do your stuff with FileData
}
Do let us know, if any thing else we can help you out
Jose Hernandez5y ago
var FilePath = Path.Combine(
ConfigurationManager.AppSettings.Get("DocumentPath").ToString(), randString + FileExtension) //get file path

var Filebytes = (byte[])row["FileName"]; //get bytes from datarow

File.WriteAllBytes(FilePath , Filebytes ); //pass parameters into function
Sachin Singh5y ago
Okk so you are writing a file then follow this
byte[] data = Encoding.ASCII.GetBytes(dt.row["FileName"].ToString());
File.WriteAllBytes(Path.Combine(ConfigurationManager.AppSettings.Get("DocumentPath").ToString(), data);
Sandeep kumar5y ago
public static void WriteAllBytes (string path, byte[] bytes);
I want to pass in this method
Sandeep kumar5y ago
then how can we pass parameter in File.WriteAllBytes().
please in details
File.WriteAllBytes(Path.Combine(
ConfigurationManager.AppSettings.Get("DocumentPath").ToString(), randString + FileExtension), ?);
Sachin Singh5y ago
you can use Length property which gives file size in bytes.
string fileName = dt.row["FileName"].ToString()
//FileInfo Class to get file details
FileInfo fi = new FileInfo(fileName);
long size = fi.Length;