rtay
asked on
How to allow null in image upload
C# Visual Studio WinForm. Upload Image. I have 4 possible images able to upload. Sometimes only one image needs to be uploaded. Currently, my code works if I upload all 4 images. If i leave one blank, it errors out with "Empty path name is not legal." How do I code to allow null path if no image.
Thanks.
[code]try
{
if (frtBillTextBox.Text.Lengt h>0 && maltIDTextBox.Text.Length> 0)
{
string FileName = fBImageContentTextBox.Text ;
byte[] ImageData;
fs = new FileStream(FileName, FileMode.Open, FileAccess.Read);
br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Lengt h);
br.Close();
fs.Close();
string FileName2 = sHImageContentTextBox.Text ;
byte[] ImageData2;
fs2 = new FileStream(FileName2, FileMode.Open, FileAccess.Read);
br2 = new BinaryReader(fs2);
ImageData2 = br2.ReadBytes((int)fs2.Len gth);
br2.Close();
fs2.Close();
string FileName3 = wCImageContentTextBox.Text ;
byte[] ImageData3;
fs3 = new FileStream(FileName3, FileMode.Open, FileAccess.Read);
br3 = new BinaryReader(fs3);
ImageData3 = br3.ReadBytes((int)fs3.Len gth);
fs3.Close();
br3.Close();
string FileName4 = frImageContentTextBox.Text ;
byte[] ImageData4;
fs4 = new FileStream(FileName4, FileMode.Open, FileAccess.Read);
br4 = new BinaryReader(fs4);
ImageData4 = br4.ReadBytes((int)fs4.Len gth);
fs4.Close();
br4.Close();
string CmdString = "Update Malt SET FrtBill=@FrtBill,FBImageCo ntent=@FBI mageConten t,SHImageC ontent=@SH ImageConte nt,WCImage Content=@W CImageCont ent,Frimag eContent=@ FrimageCon tent Where MaltID = @MaltID";
cmd = new SqlCommand(CmdString, conn);
cmd.Parameters.Add("@FrtBi ll", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@FBIma geContent" , SqlDbType.Image);
cmd.Parameters.Add("@SHIma geContent" , SqlDbType.Image);
cmd.Parameters.Add("@MaltI D", SqlDbType.Int);
cmd.Parameters.Add("@WCIma geContent" , SqlDbType.Image);
cmd.Parameters.Add("@Frima geContent" , SqlDbType.Image);
cmd.Parameters.Add("@WTag" , SqlDbType.NVarChar, 50);
//cmd.Parameters.Add("@Net Wt", SqlDbType.Int);
cmd.Parameters.Add("@Compl ete", SqlDbType.NVarChar, 50);
cmd.Parameters["@FrtBill"] .Value = frtBillTextBox.Text;
cmd.Parameters["@FBImageCo ntent"].Va lue = ImageData;
cmd.Parameters["@SHImageCo ntent"].Va lue = ImageData2;
cmd.Parameters["@MaltID"]. Value = maltIDTextBox.Text;
cmd.Parameters["@WCImageCo ntent"].Va lue = ImageData3;
cmd.Parameters["@FrimageCo ntent"].Va lue = ImageData4;
cmd.Parameters["@WTag"].Va lue = wTagTextBox.Text;
//cmd.Parameters["@NetWt"] .Value = netWtTextBox.Text;
cmd.Parameters["@Complete" ].Value = completeTextBox.Text;
conn.Open();
int RowsAffected = cmd.ExecuteNonQuery();
if (RowsAffected > 0)
{
MessageBox.Show("Image Saved Sucessfully!");
}
conn.Close();
pictureBox1.Image = null;
pictureBox2.Image = null;
pictureBox3.Image = null;
pictureBox4.Image = null;
}
else
{
MessageBox.Show("Incomplet e Data", "", MessageBoxButtons.OK);
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message );
}
finally
{
if(conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
Thanks.
[code]try
{
if (frtBillTextBox.Text.Lengt
{
string FileName = fBImageContentTextBox.Text
byte[] ImageData;
fs = new FileStream(FileName, FileMode.Open, FileAccess.Read);
br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Lengt
br.Close();
fs.Close();
string FileName2 = sHImageContentTextBox.Text
byte[] ImageData2;
fs2 = new FileStream(FileName2, FileMode.Open, FileAccess.Read);
br2 = new BinaryReader(fs2);
ImageData2 = br2.ReadBytes((int)fs2.Len
br2.Close();
fs2.Close();
string FileName3 = wCImageContentTextBox.Text
byte[] ImageData3;
fs3 = new FileStream(FileName3, FileMode.Open, FileAccess.Read);
br3 = new BinaryReader(fs3);
ImageData3 = br3.ReadBytes((int)fs3.Len
fs3.Close();
br3.Close();
string FileName4 = frImageContentTextBox.Text
byte[] ImageData4;
fs4 = new FileStream(FileName4, FileMode.Open, FileAccess.Read);
br4 = new BinaryReader(fs4);
ImageData4 = br4.ReadBytes((int)fs4.Len
fs4.Close();
br4.Close();
string CmdString = "Update Malt SET FrtBill=@FrtBill,FBImageCo
cmd = new SqlCommand(CmdString, conn);
cmd.Parameters.Add("@FrtBi
cmd.Parameters.Add("@FBIma
cmd.Parameters.Add("@SHIma
cmd.Parameters.Add("@MaltI
cmd.Parameters.Add("@WCIma
cmd.Parameters.Add("@Frima
cmd.Parameters.Add("@WTag"
//cmd.Parameters.Add("@Net
cmd.Parameters.Add("@Compl
cmd.Parameters["@FrtBill"]
cmd.Parameters["@FBImageCo
cmd.Parameters["@SHImageCo
cmd.Parameters["@MaltID"].
cmd.Parameters["@WCImageCo
cmd.Parameters["@FrimageCo
cmd.Parameters["@WTag"].Va
//cmd.Parameters["@NetWt"]
cmd.Parameters["@Complete"
conn.Open();
int RowsAffected = cmd.ExecuteNonQuery();
if (RowsAffected > 0)
{
MessageBox.Show("Image Saved Sucessfully!");
}
conn.Close();
pictureBox1.Image = null;
pictureBox2.Image = null;
pictureBox3.Image = null;
pictureBox4.Image = null;
}
else
{
MessageBox.Show("Incomplet
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message
}
finally
{
if(conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For example,
Open in new window