Updating SQL db (SqlDbType.Image)

  • Thread starter Thread starter Bjørn Nornes
  • Start date Start date
B

Bjørn Nornes

Reading file from disk (jpg)

Dim fi As New FileInfo(workFolder + CStr(mmgcid) + ".jpg")
Dim fs As FileStream = fi.OpenRead()
Dim nBytes As Integer = fi.Length
Dim ByteArray(nBytes) As Byte
Dim nBytesRead As Integer = fs.Read(ByteArray, 0, nBytes)
Dim WebServices As mediaService.Service1 = New mediaService.Service1
Dim retstatus As String

Using WEB service to update SQL database

retstatus = WebServices.UpdateThumbFileBlob(mmgcid, ByteArray)


public string UpdateThumbFileBlob(int MediaID, byte[] mmfbBlobThumb)
{
SqlConnection Connection = new
SqlConnection("SERVER=localhost;DATABASE=db1;UID=user;PWD=pwd");
String updateCmd = "UPDATE MultiMediaFileBlobs SET mmfbBlobThumb
=@mmfbBlobThumb where mmfbId=" + MediaID;
SqlCommand myCommand = new SqlCommand(updateCmd, Connection);
SqlParameter StatusParameter = new SqlParameter("@mmfbBlobThumb",
SqlDbType.Image);
StatusParameter.Value = mmfbBlobThumb;
myCommand.Parameters.Add(StatusParameter);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
}

However record is not updated ?

Anyone who sees any problems with my code here ?

regards
BN
 
Can you check whether there are any records getting affected ?

The MediaID concatenation may be creating a problem. Can check your return
value given by myCommand.ExecuteNonQuery() and see if it is more than zero ?
you might inturn return it from the webservice method to keep a permanent
check on the updation

Manasvin
 
Hi Bjorn,

I did look and see not direct something strange.

But there is one problem in your code, in your vb.function you ask for a
return but you do not give it in your webservice.

Why do you not set the execute.nonquery(or everything) in a try catch block
and return the exception if there is one and a blank if there is no
exception?


Cor
 
return value is 0.

However the same procedure (webService) works grets on other data, eg.
string, int etc.

..... and I found the problem, which you mentioned was the MediaID value sent
to
the WebService function.....


thanks for your help....

regards
BN


[email protected] said:
Can you check whether there are any records getting affected ?

The MediaID concatenation may be creating a problem. Can check your return
value given by myCommand.ExecuteNonQuery() and see if it is more than zero ?
you might inturn return it from the webservice method to keep a permanent
check on the updation

Manasvin

Bjørn Nornes said:
Reading file from disk (jpg)

Dim fi As New FileInfo(workFolder + CStr(mmgcid) + ".jpg")
Dim fs As FileStream = fi.OpenRead()
Dim nBytes As Integer = fi.Length
Dim ByteArray(nBytes) As Byte
Dim nBytesRead As Integer = fs.Read(ByteArray, 0, nBytes)
Dim WebServices As mediaService.Service1 = New mediaService.Service1
Dim retstatus As String

Using WEB service to update SQL database

retstatus = WebServices.UpdateThumbFileBlob(mmgcid, ByteArray)


public string UpdateThumbFileBlob(int MediaID, byte[] mmfbBlobThumb)
{
SqlConnection Connection = new
SqlConnection("SERVER=localhost;DATABASE=db1;UID=user;PWD=pwd");
String updateCmd = "UPDATE MultiMediaFileBlobs SET mmfbBlobThumb
=@mmfbBlobThumb where mmfbId=" + MediaID;
SqlCommand myCommand = new SqlCommand(updateCmd, Connection);
SqlParameter StatusParameter = new SqlParameter("@mmfbBlobThumb",
SqlDbType.Image);
StatusParameter.Value = mmfbBlobThumb;
myCommand.Parameters.Add(StatusParameter);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
}

However record is not updated ?

Anyone who sees any problems with my code here ?

regards
BN
Click to expand...
Click to expand...
 
Back
Top