Retrieving attachments from SP List

Question

I want to retrieve attachments from a sharepoint list. But don't really know how to, any suggestions?

SOLVED: Check code under picture.

    public void MyData(string prod)
    {
        SPWeb web = SPContext.Current.Web;
        SPList myList = web.Lists.TryGetList("Extern Products");

        if (myList!=null)
        {
            SPQuery query = new SPQuery();
            query.Query = string.Format(
                "<Where><BeginsWith><FieldRef Name='ProductNumber' />" +
                "<Value Type='Text'>{0}</Value></BeginsWith></Where>", prod);
            query.RowLimit = 10;

            SPListItemCollection items = myList.GetItems(query);


            foreach (SPListItem listItem in items)
            {
                TextBox_NameList.Text = listItem["Title"] != null ? listItem["Title"].ToString() : string.Empty;
                TextBox_ListPriceList.Text = listItem["ListPrice"] != null ? listItem["ListPrice"].ToString() : string.Empty;
                TextBox_ProdNumList.Text = listItem["ProductNumber"] != null ? listItem["ProductNumber"].ToString() : string.Empty;
                TextBox_ColorList.Text = listItem["Color"] != null ? listItem["Color"].ToString() : string.Empty;
                TextBox_MoreInformationList.Text = listItem["MoreInformation"] != null ? listItem["MoreInformation"].ToString() : string.Empty;
                //FileUpload_PicList.PostedFile.ContentType = listItem["Attachments"] != null ? listItem["Attachment"].ToString() : string.Empty;
                HiddenField_ID.Value = listItem["ID"].ToString();
            }
        }
    }

    protected void Button_Edit_Click(object sender, EventArgs e)
    {
        if(TextBox_Search.Text == string.Empty)
        {
            Label_ExtensionList.Text = "Who haven't selected anything!";
        }
        else if (ListBox_List.SelectedItem != null)
        {
            MyData = ListBox_List.SelectedItem.Value;
        }
    }

            foreach (SPListItem listItem in items)
            {
                HiddenField_ID.Value = listItem["ID"].ToString(); 
                TextBox_NameList.Text = listItem["Title"] != null ? listItem["Title"].ToString() : string.Empty;
                TextBox_ListPriceList.Text = listItem["ListPrice"] != null ? listItem["ListPrice"].ToString() : string.Empty;
                TextBox_ProdNumList.Text = listItem["ProductNumber"] != null ? listItem["ProductNumber"].ToString() : string.Empty;
                TextBox_ColorList.Text = listItem["Color"] != null ? listItem["Color"].ToString() : string.Empty;
                TextBox_MoreInformationList.Text = listItem["MoreInformation"] != null ? listItem["MoreInformation"].ToString() : string.Empty;

                **foreach (string fileName in listItem.Attachments)
                {
                    SPFile file = listItem.ParentList.ParentWeb.GetFile(
                    listItem.Attachments.Count + fileName);
                    ListBox_Attachment.Items.Add(file.ToString());
                }**
            }

Answer 1

Kristian,

Instead of showing it on Upload control, take a ListBox or GridView with Delete Button(X).. You will need to bind the Listbox/GridView with Attachments for the List Item... You can access the attachments from SPListItem.Attachments property! You will see that ListItem.Attachments will give you a string collection, if you want to get the URL of the attachment, you can do following:

First you need to get the url for the list itself. The url for the list is simply:

string listUrl = web.Url + "/" + list.RootFolder.Url;

Then, you use the list url, the item id and the attachment name to construct the whole attachment url. The completed url is:

string attachmentUrl;
if (listItem.Attachments.Count > 0)
{
    string filename = listItem.Attachments[0];
    attachmentUrl = listUrl + "/attachments/" + item.ID + "/" + filename;
}

For deleting a specific Attachment you can use SPListItem.Attachments.Delete() method... You can do something like:

listItem.Attachments.Delete(fileName);

Let me know if you stuck!

Answer 2

We are using an listbox and an button like u told us

       SPWeb web = SPContext.Current.Web;
        SPList myList = web.Lists["MyList"];

        SPListItem item = myList.GetItemById(Convert.ToInt32(HiddenField1.Value));
        string listUrl = web.Url + myList.RootFolder.Url;

        string attachmentUrl;
        if (item.Attachments.Count > 0)
            //items are red
        {

            string filename = item.Attachments[0];
            attachmentUrl = listUrl + "/attachments/" + item.ID + "/" + filename;
            //attachmenturl is never used , listurl are red 
        }

EDIT: Updated the code