C#

this represents some code in PRE tags
that gets formatted, syntax colored, and
hence is readable, yielding more and better replies.

private void pictureBox3_DoubleClick(object sender, EventArgs e)
    {
        intASUserListSelectedIndex = lbxAssistSuiteUserList.SelectedIndex;
        bool FoundUser = false;
        FileDialog fldlg = new OpenFileDialog();
        //specify your own initial directory

        if (lbxAssistSuiteUserList.SelectedIndex > -1)
        {
            try
            {
                fldlg.InitialDirectory = @":C\";
                //this will allow only those\ file extensions to be added
                fldlg.Filter = "Image File (*.jpg;*.bmp;*.gif)|*.jpg;*.bmp;*.gif|(*.gif)|*.gif|(*.jpg)|*.jpg|(*.jpeg)|*.jpeg|(*.bmp)|*.bmp|(*.wmf)|*.wmf|(*.png)|*.png";
                //fldlg.ShowDialog();
                if (fldlg.ShowDialog() == DialogResult.OK)
                {
                    imagename  = fldlg.FileName;
                    Bitmap newimg = new Bitmap(imagename);
                    pictureBox3.SizeMode = PictureBoxSizeMode.Zoom;
                    pictureBox3.Image =(Image)newimg;
                    //pictureBox3.Image = System.Drawing.Image.FromFile(openFileDialog1.FileName);
                    pictureBox3.Refresh();

                    //Update the SQL Tables.
                    lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
                    btnUpdateAssistUsers_Click(sender, e);
                    lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
                    updatedata();
                }


                fldlg = null;
                lbxAssistSuiteUserList.SelectedIndex = intASUserListSelectedIndex;
            }
            catch (System.ArgumentException ae)
            {
                imagename = " ";
                MessageBox.Show(ae.Message.ToString());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
    }

private void updatedata()
{
    SqlCommand cmd;
    bool FoundMe = false;
    int UserIndex = -1;
//use filestream object to read the image.
//read to the full length of image to a byte array.
//add this byte as an oracle parameter and insert it into database.


    try
    {
        if (imagename != "")
        {
            SqlConnection cn = new SqlConnection(WhatIsMyConnectionString);
                            for (i = 0; i < ApplicationUsersArray.Count; i++)
        {
            if (((DomainUsersClass)ApplicationUsersArray[i]).WindowsLogonName == lbxAssistSuiteUserList.Items[lbxAssistSuiteUserList.SelectedIndex].ToString())
            {
                FoundMe = true;
                break;
            }
        }
        if (FoundMe = true)
        {
            if (((DomainUsersClass)ApplicationUsersArray[i]).PicIndex == "")
            {
                UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);
                //SqlCommand cmd =  new SqlCommand("INSERT INTO tblApplicationUsersPic (id_image,BLOBData) VALUES ('" + UserIndex.ToString() + "'," + " @BLOBData)", cn);
                cmd =  new SqlCommand("INSERT INTO tblApplicationUsersPic (id_image,BLOBData) VALUES ('" + UserIndex.ToString() + "'," + " @BLOBData)", cn);
                //query = "insert into tblApplicationUsersPic(id_image,pic) values(" + UserIndex.ToString() + "," + " @pic)";
                //query = "insert into tblApplicationUsersPic(id_image,pic) values(@i, @p)";

            }
            else
            {
                UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);
                //SqlCommand cmd =  new SqlCommand("update tblApplicationUsersPic set pic = @BLOBData where id_image = '" + UserIndex.ToString() + "' ", cn);
                cmd =  new SqlCommand("update tblApplicationUsersPic set pic = @BLOBData where id_image = '" + UserIndex.ToString() + "' ", cn);
                //query = "update tblApplicationUsersPic set pic = @pic where id_image = '" + UserIndex.ToString() + "' ";
                //query = "update tblApplicationUsersPic set pic = @p where id_image = @i";
            }
        }
        else
        {
            MessageBox.Show("We have a serious problem. This should Never Happen. \n The Array did not find the correct users to grab their index for the Picture. \n The Application will now quit.");
            return;
        }
            //SqlCommand cmd =  new SqlCommand("INSERT INTO BLOBTest (BLOBData) VALUES (@BLOBData)", cn);
            String strBLOBFilePath = @imagename;//Modify this path as needed.

            //Read jpg into file stream, and from there into Byte array.
            FileStream fsBLOBFile =  new FileStream(strBLOBFilePath,FileMode.Open, FileAccess.Read);
            Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
            fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
            fsBLOBFile.Close();

            //Create parameter for insert command and add to SqlCommand object.
            SqlParameter prm = new  SqlParameter("@BLOBData", SqlDbType.VarBinary, bytBLOBData.Length, ParameterDirection.Input, false,
                        0, 0, null, DataRowVersion.Current, bytBLOBData);
            cmd.Parameters.Add(prm);

            //Open connection, execute query, and close connection.
            cn.Open();
            cmd.ExecuteNonQuery();
            cn.Close();

            if (FoundMe = true)
            {
                SQLUpdate(WhatIsMyConnectionString, "tblApplicationUsers", "tblApplicationUsersPic_idx = (Select idx_tblApplicationUserPic from tblApplicationUsersPic where id_image = '" + UserIndex.ToString() + "') ","delflag = 0 and idx_tblApplicationUsers = '" + UserIndex.ToString() + "' ");
                //UserIndex = Convert.ToInt32(((DomainUsersClass)ApplicationUsersArray[i]).Index);

            }
        }
    }
            catch (System.ArgumentException ae)
            {
                imagename = " ";
                MessageBox.Show(ae.Message.ToString());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
    }

Luc Pattyn wrote:

I think you have to expand on the specifications.

public static string MakeRelativePath(string refPath, string targetPath) {
    string[] parts1=Path.GetFullPath(refPath).Split('\\');
    string[] parts2=Path.GetFullPath(targetPath).Split('\\');

    int i=0;
    for (; i<parts1.Length && i<parts2.Length; i++) {
        if (string.Compare(parts1[i], parts2[i])!=0) break;
    }
    string result="";
    for (int j=i; j<parts1.Length; j++) result+="..\\";
    result+=string.Join('\\', i, parts2.Length-i);
    return result;
}

public const int MAX_PATH = 260;
public const uint FILE_ATTRIBUTE_DIRECTORY = 0x10;
internal const string SHLWAPI = "shlwapi.dll";
 
[DllImport(SHLWAPI, CharSet = CharSet.Unicode)]
[return: MarshalAsAttribute(UnmanagedType.Bool)]
[ResourceExposure(ResourceScope.None)]
internal static extern bool PathRelativePathTo([MarshalAsAttribute(UnmanagedType.LPWStr)] StringBuilder pszPath, [MarshalAsAttribute(UnmanagedType.LPWStr), In] string pszFrom, uint dwAttrFrom, [MarshalAsAttribute(UnmanagedType.LPWStr), In] string pszTo, uint dwAttrTo);
 
[DllImport(SHLWAPI, CharSet = CharSet.Unicode)]
[return: MarshalAsAttribute(UnmanagedType.Bool)]
[ResourceExposure(ResourceScope.None)]
internal static extern bool PathIsDirectoryEmpty([MarshalAsAttribute(UnmanagedType.LPWStr), In] string pszPath);
 
/// <summary>
/// Creates a relative path from one file or folder to another.
/// </summary>
/// <param name="from">Contains the directory that defines the start of 
/// the relative path.</param>
/// <param name="to">Contains the path that defines the endpoint of the 
/// relative path.</param>
/// <returns>The relative path from the start directory to the end 
/// path.</returns>
public static string PathRelativePathTo(string from, string to)
{
    string result = String.Empty;
    StringBuilder path = new StringBuilder(MAX_PATH);
    uint fromAttributes = IsDirectory(from) ? FILE_ATTRIBUTE_DIRECTORY : 0;
    uint toAttributes = IsDirectory(to) ? FILE_ATTRIBUTE_DIRECTORY : 0;
 
    if (PathRelativePathTo(path, from, fromAttributes, to, toAttributes))
    {
	result = path.ToString();
    }
 
    return result;
}
 
/// <summary>
/// Verifies that a path is a valid directory.
/// </summary>
/// <param name="path">The path to verify.</param>
/// <returns><see langword="true"/> if the path is a valid directory; 
/// otherwise, <see langword="false"/>.</returns>
public static bool IsDirectory(string path)
{
    return PathIsDirectory(path);
}