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

[dale zhang]

Hi,

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

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

The article author is using PictureBox for windows application, while I am
doing for web. I can only find Image from web forms control and HTML control.
This may be the root cause of my problem. For read button, I converted his VB
to the C#. But the compiler complains:

1. For Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(421): 'Image'
is an ambiguous reference

2. For imgBox.Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(422):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for 'Image'

3. For imgBox.Invalida te(),
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(423):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for
'Invalidate'

The related codes are attached below. Any suggestion? Thanks. -Dale

VB:
Private Sub UseReaderBtn_Cl ick(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles UseReaderBtn.Cl ick

' Construct a SQL string and a connection object
Dim sql As String = "SELECT UserPhoto FROM Users"
Dim conn As OleDbConnection = New OleDbConnection ()
conn.Connection String = connectionStrin g
' Open connection
If conn.State <> ConnectionState .Open Then
conn.Open()
End If

Dim cmd As OleDbCommand = New OleDbCommand(sq l, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Dim pub_id As String = ""
Dim reader As OleDbDataReader = _
cmd.ExecuteRead er(CommandBehav ior.SequentialA ccess)
' Read first record
reader.Read()
fs = New FileStream(save dImageName, _
FileMode.OpenOr Create, FileAccess.Writ e)
bw = New BinaryWriter(fs )
startIndex = 0
retval = reader.GetBytes (0, 0, outbyte, 0, bufferSize)
bw.Write(outbyt e)
bw.Flush()
' Close the output file.
bw.Close()
fs.Close()
reader.Close()
' Display image
curImage = Image.FromFile( savedImageName)
PictureBox1.Ima ge = curImage
PictureBox1.Inv alidate()
' Clean up connection
If conn.State = ConnectionState .Open Then
conn.Close()
' Dispose connection
conn.Dispose()
End If
End Sub

C#:
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 * FROM UserFiles WHERE Username =\'" +
(dbClass.DelimS tring(dListUser s.SelectedValue ) + "\'"));
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
byte[] outbyte;
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 = Image.FromFile( savedImageName) ;
imgBox.Image = curImage;
imgBox.Invalida te();
}

[Ivan Wong]

For the 1st error, I reckon you could use a full namespace
"System.Web.UI. WebControls.Ima ge" instead of "Image"
However, in this case you don't need to load the image from a path, what you
need is to set the ImageUrl.

For the 2nd error, you need to set the image to the Image class by setting
the ImageUrl property of Image class

For the 3rd error, there is no method called "Invalidate " for
System.Web.UI.W ebControls.Imag e class, in your case you don't need to call
any method to render the image, it will be display when the ImageUrl property
is set
and the webpage has been refreshed.

The modified code is shown below:

"dale zhang" wrote:

Hi,

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

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

The article author is using PictureBox for windows application, while I am
doing for web. I can only find Image from web forms control and HTML control.
This may be the root cause of my problem. For read button, I converted his VB
to the C#. But the compiler complains:

1. For Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(421): 'Image'
is an ambiguous reference

2. For imgBox.Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(422):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for 'Image'

3. For imgBox.Invalida te(),
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(423):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for
'Invalidate'

The related codes are attached below. Any suggestion? Thanks. -Dale

VB:
Private Sub UseReaderBtn_Cl ick(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles UseReaderBtn.Cl ick

' Construct a SQL string and a connection object
Dim sql As String = "SELECT UserPhoto FROM Users"
Dim conn As OleDbConnection = New OleDbConnection ()
conn.Connection String = connectionStrin g
' Open connection
If conn.State <> ConnectionState .Open Then
conn.Open()
End If

Dim cmd As OleDbCommand = New OleDbCommand(sq l, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Dim pub_id As String = ""
Dim reader As OleDbDataReader = _
cmd.ExecuteRead er(CommandBehav ior.SequentialA ccess)
' Read first record
reader.Read()
fs = New FileStream(save dImageName, _
FileMode.OpenOr Create, FileAccess.Writ e)
bw = New BinaryWriter(fs )
startIndex = 0
retval = reader.GetBytes (0, 0, outbyte, 0, bufferSize)
bw.Write(outbyt e)
bw.Flush()
' Close the output file.
bw.Close()
fs.Close()
reader.Close()
' Display image
curImage = Image.FromFile( savedImageName)
PictureBox1.Ima ge = curImage
PictureBox1.Inv alidate()
' Clean up connection
If conn.State = ConnectionState .Open Then
conn.Close()
' Dispose connection
conn.Dispose()
End If
End Sub

C#:
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 * FROM UserFiles WHERE Username =\'" +
(dbClass.DelimS tring(dListUser s.SelectedValue ) + "\'"));
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
byte[] outbyte;
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 imgBox.ImageUrl = savedImageName; }

[Ollie Riches]

have you tried using any of the free converters:

http://www.developerfusion.co.uk/uti...btocsharp.aspx

HTH

Ollie Riches

"dale zhang" <da*******@disc ussions.microso ft.com> wrote in message
news:07******** *************** ***********@mic rosoft.com...

Hi,

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

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

The article author is using PictureBox for windows application, while I am
doing for web. I can only find Image from web forms control and HTML
control.
This may be the root cause of my problem. For read button, I converted his
VB
to the C#. But the compiler complains:

1. For Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(421):
'Image'
is an ambiguous reference

2. For imgBox.Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(422):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for
'Image'

3. For imgBox.Invalida te(),
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(423):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for
'Invalidate'

The related codes are attached below. Any suggestion? Thanks. -Dale

VB:
Private Sub UseReaderBtn_Cl ick(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles UseReaderBtn.Cl ick

' Construct a SQL string and a connection object
Dim sql As String = "SELECT UserPhoto FROM Users"
Dim conn As OleDbConnection = New OleDbConnection ()
conn.Connection String = connectionStrin g
' Open connection
If conn.State <> ConnectionState .Open Then
conn.Open()
End If

Dim cmd As OleDbCommand = New OleDbCommand(sq l, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Dim pub_id As String = ""
Dim reader As OleDbDataReader = _
cmd.ExecuteRead er(CommandBehav ior.SequentialA ccess)
' Read first record
reader.Read()
fs = New FileStream(save dImageName, _
FileMode.OpenOr Create, FileAccess.Writ e)
bw = New BinaryWriter(fs )
startIndex = 0
retval = reader.GetBytes (0, 0, outbyte, 0, bufferSize)
bw.Write(outbyt e)
bw.Flush()
' Close the output file.
bw.Close()
fs.Close()
reader.Close()
' Display image
curImage = Image.FromFile( savedImageName)
PictureBox1.Ima ge = curImage
PictureBox1.Inv alidate()
' Clean up connection
If conn.State = ConnectionState .Open Then
conn.Close()
' Dispose connection
conn.Dispose()
End If
End Sub

C#:
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 * FROM UserFiles WHERE Username =\'" +
(dbClass.DelimS tring(dListUser s.SelectedValue ) + "\'"));
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
byte[] outbyte;
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 = Image.FromFile( savedImageName) ;
imgBox.Image = curImage;
imgBox.Invalida te();
}

[dale zhang]

Thank you for the link. This one seems better than I used.

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;

}

"Ollie Riches" wrote:

have you tried using any of the free converters:

http://www.developerfusion.co.uk/uti...btocsharp.aspx

HTH

Ollie Riches

"dale zhang" <da*******@disc ussions.microso ft.com> wrote in message
news:07******** *************** ***********@mic rosoft.com...

Hi,

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

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

The article author is using PictureBox for windows application, while I am
doing for web. I can only find Image from web forms control and HTML
control.
This may be the root cause of my problem. For read button, I converted his
VB
to the C#. But the compiler complains:

1. For Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(421):
'Image'
is an ambiguous reference

2. For imgBox.Image,
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(422):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for
'Image'

3. For imgBox.Invalida te(),
C:\Inetpub\wwwr oot\passwordPro tectCSharp\admi nUserFile.aspx. cs(423):
'System.Web.UI. WebControls.Ima ge' does not contain a definition for
'Invalidate'

The related codes are attached below. Any suggestion? Thanks. -Dale

VB:
Private Sub UseReaderBtn_Cl ick(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles UseReaderBtn.Cl ick

' Construct a SQL string and a connection object
Dim sql As String = "SELECT UserPhoto FROM Users"
Dim conn As OleDbConnection = New OleDbConnection ()
conn.Connection String = connectionStrin g
' Open connection
If conn.State <> ConnectionState .Open Then
conn.Open()
End If

Dim cmd As OleDbCommand = New OleDbCommand(sq l, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Dim pub_id As String = ""
Dim reader As OleDbDataReader = _
cmd.ExecuteRead er(CommandBehav ior.SequentialA ccess)
' Read first record
reader.Read()
fs = New FileStream(save dImageName, _
FileMode.OpenOr Create, FileAccess.Writ e)
bw = New BinaryWriter(fs )
startIndex = 0
retval = reader.GetBytes (0, 0, outbyte, 0, bufferSize)
bw.Write(outbyt e)
bw.Flush()
' Close the output file.
bw.Close()
fs.Close()
reader.Close()
' Display image
curImage = Image.FromFile( savedImageName)
PictureBox1.Ima ge = curImage
PictureBox1.Inv alidate()
' Clean up connection
If conn.State = ConnectionState .Open Then
conn.Close()
' Dispose connection
conn.Dispose()
End If
End Sub

C#:
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 * FROM UserFiles WHERE Username =\'" +
(dbClass.DelimS tring(dListUser s.SelectedValue ) + "\'"));
FileStream fs;
BinaryWriter bw;
int bufferSize = 300000;
byte[] outbyte;
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 = Image.FromFile( savedImageName) ;
imgBox.Image = curImage;
imgBox.Invalida te();
}