Uploading an Image from a web page

[Paul Gorman]

I am using the control type = file to perform a file
upload. When I click on the browse button to go select
the image I want to upload it places in the text box a
local path (C:\images\imag e.jpg for example). This is
where the image resides that I want to upload. Then I
proceed to click on upload so that I can run through my
code to do the upload process:

string strConnection = "some connection string";
SqlConnection oCon = new SqlConnection(s trConnection);
SqlCommand oCom = new SqlCommand();

oCom.CommandTex t = "usp_msa_image_ save_binary";
oCom.CommandTyp e = CommandType.Sto redProcedure;
oCom.Connection = oCon;

oCon.Open();

FileStream fs;
string strFileName = this.loFile.Pos tedFile.FileNam e;
fs = File.OpenRead(s trFileName);

int intCount = (int)fs.Length;
int intSize;

byte[] buffer = new byte[intCount];
fs.Read(buffer, 0,intCount);

oCom.Parameters .Add("@Image", SqlDbType.Image ).Value =
buffer;

oCom.Parameters .Add("@itemID", SqlDbType.VarCh ar,
30).Value = "CEH03BA401 "; //Request.QuerySt ring.Get
("name");

if ( this.chkSmallIm age.Checked )
{
oCom.Parameters .Add("@size", SqlDbType.Int). Value = 1;
intSize = 1;
}
else
{
oCom.Parameters .Add("@size", SqlDbType.Int). Value = 2;
intSize = 2;
}

oCom.ExecuteNon Query();
string strItemNumber = Request.QuerySt ring.Get("name" );

string strUrl = "image_binary_g et.aspx?itemnum ber=" +
strItemNumber + "&size=" + intSize;

this.imgView.Im ageUrl = strUrl;
It continues to fail at
fs = File.OpenRead(s trFileName);
with the error message:
"Could not find part of the path "C:\images\imag e.jpg".

The one thing that I can be sure of is this. When i
attempt this process on the IIS Server where all this
resides then it works great. As soon as I try to upload
a file from some other computer on the network i get that
error. Any help would be greatly appreciated. Thanks in
advance.

Paul Gorman ><>

[Bülent Keskin]

this.loFile.Pos tedFile.FileNam e just returns the client side name of the
uploaded file.
Because your client & server is the same machine, your code is running
succesfully.

You should firstly save the uploaded file and then insert it into database.
As below:

this.loFile.Pos tedFile.SaveAs( Server.MapPath( "/images/uploads/image.gif"));
....
....
fs = File.OpenRead(S erver.MapPath("/images/uploads/image.gif"));

"Paul Gorman" <pg*****@satx.r r.com> wrote in message
news:0b******** *************** *****@phx.gbl.. .

I am using the control type = file to perform a file
upload. When I click on the browse button to go select
the image I want to upload it places in the text box a
local path (C:\images\imag e.jpg for example). This is
where the image resides that I want to upload. Then I
proceed to click on upload so that I can run through my
code to do the upload process:

string strConnection = "some connection string";
SqlConnection oCon = new SqlConnection(s trConnection);
SqlCommand oCom = new SqlCommand();

oCom.CommandTex t = "usp_msa_image_ save_binary";
oCom.CommandTyp e = CommandType.Sto redProcedure;
oCom.Connection = oCon;

oCon.Open();

FileStream fs;
string strFileName = this.loFile.Pos tedFile.FileNam e;
fs = File.OpenRead(s trFileName);

int intCount = (int)fs.Length;
int intSize;

byte[] buffer = new byte[intCount];
fs.Read(buffer, 0,intCount);

oCom.Parameters .Add("@Image", SqlDbType.Image ).Value =
buffer;

oCom.Parameters .Add("@itemID", SqlDbType.VarCh ar,
30).Value = "CEH03BA401 "; //Request.QuerySt ring.Get
("name");

if ( this.chkSmallIm age.Checked )
{
oCom.Parameters .Add("@size", SqlDbType.Int). Value = 1;
intSize = 1;
}
else
{
oCom.Parameters .Add("@size", SqlDbType.Int). Value = 2;
intSize = 2;
}

oCom.ExecuteNon Query();
string strItemNumber = Request.QuerySt ring.Get("name" );

string strUrl = "image_binary_g et.aspx?itemnum ber=" +
strItemNumber + "&size=" + intSize;

this.imgView.Im ageUrl = strUrl;
It continues to fail at
fs = File.OpenRead(s trFileName);
with the error message:
"Could not find part of the path "C:\images\imag e.jpg".

The one thing that I can be sure of is this. When i
attempt this process on the IIS Server where all this
resides then it works great. As soon as I try to upload
a file from some other computer on the network i get that
error. Any help would be greatly appreciated. Thanks in
advance.

Paul Gorman ><>

[Naveen K Kohli]

When you want to upload the image from a network drive, then path
"C:\Foo\Bla h blah" is not local to the web server. So it will try to look
for it and then give you the error message that you are getting. You will
have to follow the netrwork drive access procudre to do it. Like
"\\MyRemoteServ er\C$\Foo\Blah" assuming that you have a share created on
your network drive and your web server has permissions to access the files
there. This could be a big security problem for you.

--
Naveen K Kohli
http://www.netomatix.com
"Paul Gorman" <pg*****@satx.r r.com> wrote in message
news:0b******** *************** *****@phx.gbl.. .

I am using the control type = file to perform a file
upload. When I click on the browse button to go select
the image I want to upload it places in the text box a
local path (C:\images\imag e.jpg for example). This is
where the image resides that I want to upload. Then I
proceed to click on upload so that I can run through my
code to do the upload process:

string strConnection = "some connection string";
SqlConnection oCon = new SqlConnection(s trConnection);
SqlCommand oCom = new SqlCommand();

oCom.CommandTex t = "usp_msa_image_ save_binary";
oCom.CommandTyp e = CommandType.Sto redProcedure;
oCom.Connection = oCon;

oCon.Open();

FileStream fs;
string strFileName = this.loFile.Pos tedFile.FileNam e;
fs = File.OpenRead(s trFileName);

int intCount = (int)fs.Length;
int intSize;

byte[] buffer = new byte[intCount];
fs.Read(buffer, 0,intCount);

oCom.Parameters .Add("@Image", SqlDbType.Image ).Value =
buffer;

oCom.Parameters .Add("@itemID", SqlDbType.VarCh ar,
30).Value = "CEH03BA401 "; //Request.QuerySt ring.Get
("name");

if ( this.chkSmallIm age.Checked )
{
oCom.Parameters .Add("@size", SqlDbType.Int). Value = 1;
intSize = 1;
}
else
{
oCom.Parameters .Add("@size", SqlDbType.Int). Value = 2;
intSize = 2;
}

oCom.ExecuteNon Query();
string strItemNumber = Request.QuerySt ring.Get("name" );

string strUrl = "image_binary_g et.aspx?itemnum ber=" +
strItemNumber + "&size=" + intSize;

this.imgView.Im ageUrl = strUrl;
It continues to fail at
fs = File.OpenRead(s trFileName);
with the error message:
"Could not find part of the path "C:\images\imag e.jpg".

The one thing that I can be sure of is this. When i
attempt this process on the IIS Server where all this
resides then it works great. As soon as I try to upload
a file from some other computer on the network i get that
error. Any help would be greatly appreciated. Thanks in
advance.

Paul Gorman ><>