H
Hrvoje Voda
I wrote this code to save a blob data into database.
What is wrong?
public ArrayList SetProfile(byte [] Profile)
{
ArrayList arrayProfile = new ArrayList ();
int bufferSize = 100; .
byte[] outbyte = new byte[bufferSize];
SqlConnection conn = null;
SqlDataReader rdr = null;
if (_UserName !=null)
{
try
{
conn = new
SqlConnection(sConnString);
conn.Open() ;
SqlCommand cmd = new SqlCommand("SetProfile", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add ("@UserName",_UserName);
cmd.Parameters.Add("@Profile", SqlDbType.Image, Profile.Length).Value =
Profile;
rdr = cmd.ExecuteReader ();
}
finally
{
if (conn != null)
{
conn.Close();
}
if (rdr != null)
{
rdr.Close();
}
}
}
return arrayProfile;
}
Hrcko
What is wrong?
public ArrayList SetProfile(byte [] Profile)
{
ArrayList arrayProfile = new ArrayList ();
int bufferSize = 100; .
byte[] outbyte = new byte[bufferSize];
SqlConnection conn = null;
SqlDataReader rdr = null;
if (_UserName !=null)
{
try
{
conn = new
SqlConnection(sConnString);
conn.Open() ;
SqlCommand cmd = new SqlCommand("SetProfile", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add ("@UserName",_UserName);
cmd.Parameters.Add("@Profile", SqlDbType.Image, Profile.Length).Value =
Profile;
rdr = cmd.ExecuteReader ();
}
finally
{
if (conn != null)
{
conn.Close();
}
if (rdr != null)
{
rdr.Close();
}
}
}
return arrayProfile;
}
Hrcko