Convert VB to C# for saving/reading an image from Access DB

[dale zhang]

Hi,

I am trying to save and read an image from MS Access DB based on the
following article:

http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

Right now, I saved images without any errors. After reading the ole object
from db, I saved it to C: as file1.bmp and displayed on the web. But it can
not be displayed. After I manually sent the file to wordpad, it shows

System.Byte [ ]

Now I suspect my saving an image might be wrong. The table has 2 columns:
username and userfile. Userfile column shows

..ong binary data

I can not find a way to verify if data was saved ok? But saving does not
report any errors. I am attached my saving and reading codes here to see if
anyone can help?

THanks. –dale
private void btnSaveToDB_Cli ck(object sender, System.EventArg s e)
{
if (dListUsers.Sel ectedValue == "")
{
lblFileAccess.T ext = "You need to select an user first!";
return;
}
curFileName = myFile.PostedFi le.FileName;
// only the attched file name not its path
string c = System.IO.Path. GetFileName(cur FileName);
// Read a bitmap contents in a stream
FileStream fs = new FileStream(curF ileName, FileMode.OpenOr Create,
FileAccess.Read );
byte[] rawData = new byte[fs.Length];
fs.Read(rawData , 0, System.Convert. ToInt32(fs.Leng th));
fs.Close();
// Construct a SQL string and a connection object
OleDbConnection dbConn;
OleDbCommand dbCmd;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
string sSQL;

sSQL = ("INSERT INTO UserFiles (UserName,UserF ile) "
+ ("VALUES ("
+ (dbClass.DelimS tring(dListUser s.SelectedValue ) + (","
+ ("\'"+rawDat a + "\')")))));
try
{
// write the visit log entry
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sS QL, dbConn);
dbCmd.ExecuteNo nQuery();
dbConn.Close();
lblFileAccess.T ext = "The file has been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
lblFileAccess.T ext = "The file has not been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
}

private void btnReadFmDB_Cli ck(object sender, System.EventArg s e)
{
OleDbConnection dbConn;
OleDbCommand dbCmd;
OleDbDataReader dbDR;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
// Construct a SQL string and a connection object
string sql = "SELECT UserFile FROM UserFiles WHERE Username =\'"
+ dListUsers.Sele ctedValue + "\'";
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
//byte[] outbyte;
byte[] outbyte = new byte[300000 - 1];

long retval;
//long startIndex = 0;
//string pub_id = "";

try
{
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sq l, dbConn);
dbDR = dbCmd.ExecuteRe ader(CommandBeh avior.CloseConn ection);
while (dbDR.Read())
{
fs = new FileStream(save dImageName, FileMode.OpenOr Create,
FileAccess.Writ e);
bw = new BinaryWriter(fs );
//startIndex = 0;
retval = dbDR.GetBytes(0 , 0, outbyte, 0, bufferSize);

bw.Write(outbyt e);
bw.Flush();
// Close the output file.
bw.Close();
fs.Close();
}
// get the end
dbConn.Close();
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
return;
}
// Display image
//curImage = System.Web.UI.W ebControls.Imag e.FromFile(save dImageName);
imgBox.ImageUrl = savedImageName;

}

[Peter Bromberg [C# MVP]]

bitmaps stored in MS Access normally have a 78 byte OLE Header that you need
to strip off before saving the remaining bytes.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dale zhang" wrote:

Hi,

I am trying to save and read an image from MS Access DB based on the
following article:

http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

Right now, I saved images without any errors. After reading the ole object
from db, I saved it to C: as file1.bmp and displayed on the web. But it can
not be displayed. After I manually sent the file to wordpad, it shows

System.Byte [ ]

Now I suspect my saving an image might be wrong. The table has 2 columns:
username and userfile. Userfile column shows

.ong binary data

I can not find a way to verify if data was saved ok? But saving does not
report any errors. I am attached my saving and reading codes here to see if
anyone can help?

THanks. –dale
private void btnSaveToDB_Cli ck(object sender, System.EventArg s e)
{
if (dListUsers.Sel ectedValue == "")
{
lblFileAccess.T ext = "You need to select an user first!";
return;
}
curFileName = myFile.PostedFi le.FileName;
// only the attched file name not its path
string c = System.IO.Path. GetFileName(cur FileName);
// Read a bitmap contents in a stream
FileStream fs = new FileStream(curF ileName, FileMode.OpenOr Create,
FileAccess.Read );
byte[] rawData = new byte[fs.Length];
fs.Read(rawData , 0, System.Convert. ToInt32(fs.Leng th));
fs.Close();
// Construct a SQL string and a connection object
OleDbConnection dbConn;
OleDbCommand dbCmd;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
string sSQL;

sSQL = ("INSERT INTO UserFiles (UserName,UserF ile) "
+ ("VALUES ("
+ (dbClass.DelimS tring(dListUser s.SelectedValue ) + (","
+ ("\'"+rawDat a + "\')")))));
try
{
// write the visit log entry
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sS QL, dbConn);
dbCmd.ExecuteNo nQuery();
dbConn.Close();
lblFileAccess.T ext = "The file has been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
lblFileAccess.T ext = "The file has not been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
}

private void btnReadFmDB_Cli ck(object sender, System.EventArg s e)
{
OleDbConnection dbConn;
OleDbCommand dbCmd;
OleDbDataReader dbDR;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
// Construct a SQL string and a connection object
string sql = "SELECT UserFile FROM UserFiles WHERE Username =\'"
+ dListUsers.Sele ctedValue + "\'";
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
//byte[] outbyte;
byte[] outbyte = new byte[300000 - 1];

long retval;
//long startIndex = 0;
//string pub_id = "";

try
{
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sq l, dbConn);
dbDR = dbCmd.ExecuteRe ader(CommandBeh avior.CloseConn ection);
while (dbDR.Read())
{
fs = new FileStream(save dImageName, FileMode.OpenOr Create,
FileAccess.Writ e);
bw = new BinaryWriter(fs );
//startIndex = 0;
retval = dbDR.GetBytes(0 , 0, outbyte, 0, bufferSize);

bw.Write(outbyt e);
bw.Flush();
// Close the output file.
bw.Close();
fs.Close();
}
// get the end
dbConn.Close();
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
return;
}
// Display image
//curImage = System.Web.UI.W ebControls.Imag e.FromFile(save dImageName);
imgBox.ImageUrl = savedImageName;

}

[dale zhang]

Hi Peter,

Thank you providing this important info.

I changed my reading as below:

retval = dbDR.GetBytes(0 , 78, outbyte, 0, bufferSize);

still can not display. When I opened the saved file in wordpad, I saw
nothing. Before I can see:

System.Byte [ ]

Did I do it wrongly?

-Dale
"Peter Bromberg [C# MVP]" wrote:

bitmaps stored in MS Access normally have a 78 byte OLE Header that you need
to strip off before saving the remaining bytes.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dale zhang" wrote:

Hi,

I am trying to save and read an image from MS Access DB based on the
following article:

http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

Right now, I saved images without any errors. After reading the ole object
from db, I saved it to C: as file1.bmp and displayed on the web. But it can
not be displayed. After I manually sent the file to wordpad, it shows

System.Byte [ ]

Now I suspect my saving an image might be wrong. The table has 2 columns:
username and userfile. Userfile column shows

.ong binary data

I can not find a way to verify if data was saved ok? But saving does not
report any errors. I am attached my saving and reading codes here to see if
anyone can help?

THanks. –dale
private void btnSaveToDB_Cli ck(object sender, System.EventArg s e)
{
if (dListUsers.Sel ectedValue == "")
{
lblFileAccess.T ext = "You need to select an user first!";
return;
}
curFileName = myFile.PostedFi le.FileName;
// only the attched file name not its path
string c = System.IO.Path. GetFileName(cur FileName);
// Read a bitmap contents in a stream
FileStream fs = new FileStream(curF ileName, FileMode.OpenOr Create,
FileAccess.Read );
byte[] rawData = new byte[fs.Length];
fs.Read(rawData , 0, System.Convert. ToInt32(fs.Leng th));
fs.Close();
// Construct a SQL string and a connection object
OleDbConnection dbConn;
OleDbCommand dbCmd;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
string sSQL;

sSQL = ("INSERT INTO UserFiles (UserName,UserF ile) "
+ ("VALUES ("
+ (dbClass.DelimS tring(dListUser s.SelectedValue ) + (","
+ ("\'"+rawDat a + "\')")))));
try
{
// write the visit log entry
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sS QL, dbConn);
dbCmd.ExecuteNo nQuery();
dbConn.Close();
lblFileAccess.T ext = "The file has been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
lblFileAccess.T ext = "The file has not been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
}

private void btnReadFmDB_Cli ck(object sender, System.EventArg s e)
{
OleDbConnection dbConn;
OleDbCommand dbCmd;
OleDbDataReader dbDR;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
// Construct a SQL string and a connection object
string sql = "SELECT UserFile FROM UserFiles WHERE Username =\'"
+ dListUsers.Sele ctedValue + "\'";
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
//byte[] outbyte;
byte[] outbyte = new byte[300000 - 1];

long retval;
//long startIndex = 0;
//string pub_id = "";

try
{
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sq l, dbConn);
dbDR = dbCmd.ExecuteRe ader(CommandBeh avior.CloseConn ection);
while (dbDR.Read())
{
fs = new FileStream(save dImageName, FileMode.OpenOr Create,
FileAccess.Writ e);
bw = new BinaryWriter(fs );
//startIndex = 0;
retval = dbDR.GetBytes(0 , 0, outbyte, 0, bufferSize);

bw.Write(outbyt e);
bw.Flush();
// Close the output file.
bw.Close();
fs.Close();
}
// get the end
dbConn.Close();
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
return;
}
// Display image
//curImage = System.Web.UI.W ebControls.Imag e.FromFile(save dImageName);
imgBox.ImageUrl = savedImageName;

}

[Peter Bromberg [C# MVP]]

Dale,
You need to post a "short but complete" (a la MVP Jon Skeet) block of code
that will give people enough information to be able to tell what is not
right. That single line of DataReader code isn't sufficient.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dale zhang" wrote:

Hi Peter,

Thank you providing this important info.

I changed my reading as below:

retval = dbDR.GetBytes(0 , 78, outbyte, 0, bufferSize);

still can not display. When I opened the saved file in wordpad, I saw
nothing. Before I can see:

System.Byte [ ]

Did I do it wrongly?

-Dale
"Peter Bromberg [C# MVP]" wrote:

bitmaps stored in MS Access normally have a 78 byte OLE Header that you need
to strip off before saving the remaining bytes.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dale zhang" wrote:

Hi,

I am trying to save and read an image from MS Access DB based on the
following article:

http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp

Right now, I saved images without any errors. After reading the ole object
from db, I saved it to C: as file1.bmp and displayed on the web. But it can
not be displayed. After I manually sent the file to wordpad, it shows

System.Byte [ ]

Now I suspect my saving an image might be wrong. The table has 2 columns:
username and userfile. Userfile column shows

.ong binary data

I can not find a way to verify if data was saved ok? But saving does not
report any errors. I am attached my saving and reading codes here to see if
anyone can help?

THanks. –dale
private void btnSaveToDB_Cli ck(object sender, System.EventArg s e)
{
if (dListUsers.Sel ectedValue == "")
{
lblFileAccess.T ext = "You need to select an user first!";
return;
}
curFileName = myFile.PostedFi le.FileName;
// only the attched file name not its path
string c = System.IO.Path. GetFileName(cur FileName);
// Read a bitmap contents in a stream
FileStream fs = new FileStream(curF ileName, FileMode.OpenOr Create,
FileAccess.Read );
byte[] rawData = new byte[fs.Length];
fs.Read(rawData , 0, System.Convert. ToInt32(fs.Leng th));
fs.Close();
// Construct a SQL string and a connection object
OleDbConnection dbConn;
OleDbCommand dbCmd;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
string sSQL;

sSQL = ("INSERT INTO UserFiles (UserName,UserF ile) "
+ ("VALUES ("
+ (dbClass.DelimS tring(dListUser s.SelectedValue ) + (","
+ ("\'"+rawDat a + "\')")))));
try
{
// write the visit log entry
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sS QL, dbConn);
dbCmd.ExecuteNo nQuery();
dbConn.Close();
lblFileAccess.T ext = "The file has been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
lblFileAccess.T ext = "The file has not been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
}

private void btnReadFmDB_Cli ck(object sender, System.EventArg s e)
{
OleDbConnection dbConn;
OleDbCommand dbCmd;
OleDbDataReader dbDR;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
// Construct a SQL string and a connection object
string sql = "SELECT UserFile FROM UserFiles WHERE Username =\'"
+ dListUsers.Sele ctedValue + "\'";
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
//byte[] outbyte;
byte[] outbyte = new byte[300000 - 1];

long retval;
//long startIndex = 0;
//string pub_id = "";

try
{
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sq l, dbConn);
dbDR = dbCmd.ExecuteRe ader(CommandBeh avior.CloseConn ection);
while (dbDR.Read())
{
fs = new FileStream(save dImageName, FileMode.OpenOr Create,
FileAccess.Writ e);
bw = new BinaryWriter(fs );
//startIndex = 0;
retval = dbDR.GetBytes(0 , 0, outbyte, 0, bufferSize);

bw.Write(outbyt e);
bw.Flush();
// Close the output file.
bw.Close();
fs.Close();
}
// get the end
dbConn.Close();
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
return;
}
// Display image
//curImage = System.Web.UI.W ebControls.Imag e.FromFile(save dImageName);
imgBox.ImageUrl = savedImageName;

}

[dale zhang]

Peter,

Sorry. Enclosed is the related codes based on your advice. I appreciate your
help. -Dale

string curFileName = null;
string savedImageName = "C:\\imageFromD b.BMP";

private void btnSaveToDB_Cli ck(object sender, System.EventArg s e)
{
if (dListUsers.Sel ectedValue == "")
{
lblFileAccess.T ext = "You need to select an user first!";
return;
}
curFileName = myFile.PostedFi le.FileName;
// only the attched file name not its path
string c = System.IO.Path. GetFileName(cur FileName);
// Read a bitmap contents in a stream
FileStream fs = new FileStream(curF ileName, FileMode.OpenOr Create,
FileAccess.Read );
byte[] rawData = new byte[fs.Length];
fs.Read(rawData , 0, System.Convert. ToInt32(fs.Leng th));
fs.Close();
// Construct a SQL string and a connection object
OleDbConnection dbConn;
OleDbCommand dbCmd;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
string sSQL;

sSQL = ("INSERT INTO UserFiles (UserName,UserF ile) "
+ ("VALUES ("
+ (dbClass.DelimS tring(dListUser s.SelectedValue ) + (","
+ ("\'"+rawDat a + "\')")))));
try
{
// write the visit log entry
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sS QL, dbConn);
dbCmd.ExecuteNo nQuery();
dbConn.Close();
lblFileAccess.T ext = "The file has been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
lblFileAccess.T ext = "The file has not been saved successfully for "
+ dListUsers.Sele ctedValue + ".";
return;
}
}

private void btnReadFmDB_Cli ck(object sender, System.EventArg s e)
{
OleDbConnection dbConn;
OleDbCommand dbCmd;
OleDbDataReader dbDR;
string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
string sConn = dbClass.Connect (applicationSta te);
// Construct a SQL string and a connection object
string sql = "SELECT UserFile FROM UserFiles WHERE Username =\'"
+ dListUsers.Sele ctedValue + "\'";
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
//byte[] outbyte;
byte[] outbyte = new byte[300000 - 1];

long retval;
//long startIndex = 0;
//string pub_id = "";

try
{
dbConn = new OleDbConnection (sConn);
dbConn.Open();
dbCmd = new OleDbCommand(sq l, dbConn);
dbDR = dbCmd.ExecuteRe ader(CommandBeh avior.CloseConn ection);
while (dbDR.Read())
{
fs = new FileStream(save dImageName, FileMode.OpenOr Create,
FileAccess.Writ e);
bw = new BinaryWriter(fs );
//startIndex = 0;
retval = dbDR.GetBytes(0 , 78, outbyte, 0, bufferSize);

bw.Write(outbyt e);
bw.Flush();
// Close the output file.
bw.Close();
fs.Close();
}
// get the end
dbConn.Close();
}
catch (Exception excep)
{
Debug.WriteLine (excep.Message) ;
return;
}
// Display image
//curImage = System.Web.UI.W ebControls.Imag e.FromFile(save dImageName);
imgBox.ImageUrl = savedImageName;

}

"Peter Bromberg [C# MVP]" wrote:

Dale,
You need to post a "short but complete" (a la MVP Jon Skeet) block of code
that will give people enough information to be able to tell what is not
right. That single line of DataReader code isn't sufficient.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dale zhang" wrote:

Hi Peter,

Thank you providing this important info.

I changed my reading as below:

retval = dbDR.GetBytes(0 , 78, outbyte, 0, bufferSize);

still can not display. When I opened the saved file in wordpad, I saw
nothing. Before I can see:

System.Byte [ ]

Did I do it wrongly?

-Dale
"Peter Bromberg [C# MVP]" wrote:

bitmaps stored in MS Access normally have a 78 byte OLE Header that you need
to strip off before saving the remaining bytes.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"dale zhang" wrote:

> Hi,
>
> I am trying to save and read an image from MS Access DB based on the
> following article:
>
> http://www.vbdotnetheaven.com/Code/Sept2003/2175.asp
>
> Right now, I saved images without any errors. After reading the ole object
> from db, I saved it to C: as file1.bmp and displayed on the web. But it can
> not be displayed. After I manually sent the file to wordpad, it shows
>
> System.Byte [ ]
>
> Now I suspect my saving an image might be wrong. The table has 2 columns:
> username and userfile. Userfile column shows
>
> .ong binary data
>
> I can not find a way to verify if data was saved ok? But saving does not
> report any errors. I am attached my saving and reading codes here to see if
> anyone can help?
>
> THanks. –dale
> private void btnSaveToDB_Cli ck(object sender, System.EventArg s e)
> {
> if (dListUsers.Sel ectedValue == "")
> {
> lblFileAccess.T ext = "You need to select an user first!";
> return;
> }
> curFileName = myFile.PostedFi le.FileName;
> // only the attched file name not its path
> string c = System.IO.Path. GetFileName(cur FileName);
> // Read a bitmap contents in a stream
> FileStream fs = new FileStream(curF ileName, FileMode.OpenOr Create,
> FileAccess.Read );
> byte[] rawData = new byte[fs.Length];
> fs.Read(rawData , 0, System.Convert. ToInt32(fs.Leng th));
> fs.Close();
> // Construct a SQL string and a connection object
> OleDbConnection dbConn;
> OleDbCommand dbCmd;
> string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
> string sConn = dbClass.Connect (applicationSta te);
> string sSQL;
>
> sSQL = ("INSERT INTO UserFiles (UserName,UserF ile) "
> + ("VALUES ("
> + (dbClass.DelimS tring(dListUser s.SelectedValue ) + (","
> + ("\'"+rawDat a + "\')")))));
> try
> {
> // write the visit log entry
> dbConn = new OleDbConnection (sConn);
> dbConn.Open();
> dbCmd = new OleDbCommand(sS QL, dbConn);
> dbCmd.ExecuteNo nQuery();
> dbConn.Close();
> lblFileAccess.T ext = "The file has been saved successfully for "
> + dListUsers.Sele ctedValue + ".";
> return;
> }
> catch (Exception excep)
> {
> Debug.WriteLine (excep.Message) ;
> lblFileAccess.T ext = "The file has not been saved successfully for "
> + dListUsers.Sele ctedValue + ".";
> return;
> }
> }
>
> private void btnReadFmDB_Cli ck(object sender, System.EventArg s e)
> {
> OleDbConnection dbConn;
> OleDbCommand dbCmd;
> OleDbDataReader dbDR;
> string applicationStat e = ((string)(Appli cation["DBType"])).ToLower();
> string sConn = dbClass.Connect (applicationSta te);
> // Construct a SQL string and a connection object
> string sql = "SELECT UserFile FROM UserFiles WHERE Username =\'"
> + dListUsers.Sele ctedValue + "\'";
> FileStream fs;
> BinaryWriter bw;
> int bufferSize = 300000;
> //byte[] outbyte;
> byte[] outbyte = new byte[300000 - 1];
>
> long retval;
> //long startIndex = 0;
> //string pub_id = "";
>
> try
> {
> dbConn = new OleDbConnection (sConn);
> dbConn.Open();
> dbCmd = new OleDbCommand(sq l, dbConn);
> dbDR = dbCmd.ExecuteRe ader(CommandBeh avior.CloseConn ection);
> while (dbDR.Read())
> {
> fs = new FileStream(save dImageName, FileMode.OpenOr Create,
> FileAccess.Writ e);
> bw = new BinaryWriter(fs );
> //startIndex = 0;
> retval = dbDR.GetBytes(0 , 0, outbyte, 0, bufferSize);
>
> bw.Write(outbyt e);
> bw.Flush();
> // Close the output file.
> bw.Close();
> fs.Close();
> }
> // get the end
> dbConn.Close();
> }
> catch (Exception excep)
> {
> Debug.WriteLine (excep.Message) ;
> return;
> }
> // Display image
> //curImage = System.Web.UI.W ebControls.Imag e.FromFile(save dImageName);
> imgBox.ImageUrl = savedImageName;
>
> }
>
>
>