AbleCommerce Shopping Cart Software

In EditProduct.aspx.cs 'Manufacturer' is a dropdown list, and we can select the type.
Now I need to write a data feed script. I got the ManufacturerId the table 'products', and the Manufacturer data store in table 'Manufacturer'.
So how do i use ManufacturerId to find out the Manufacturer 'Name'.
Here is my the code, but didn't work.


using System;
using System.IO;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CommerceBuilder.Web.UI;
using CommerceBuilder.DataFeeds;
using CommerceBuilder.Common;
using System.Collections.Generic;
using CommerceBuilder.Products;
using CommerceBuilder.Stores;
using CommerceBuilder.Utility;

public partial class Admin_Marketing_Feeds_GetPrice : AbleCommerceAdminPage
{

protected void Page_Init(object sender, EventArgs e)
{

bool success = true;
String temp;
String filePath = "..\\..\\..\\feed\\getprice.txt";

dataFeedLink.Text = "<a href='" + filePath + "'>Download</a>";

String fieldBreak = "\t";

TextWriter tw = new StreamWriter(Server.MapPath(filePath));
ProductCollection products = ProductDataSource.LoadForCriteria("");

tw.WriteLine("MPN "+fieldBreak+
"Product name"+fieldBreak+
"Product ID"+fieldBreak+
"Description"+fieldBreak+
"Price"+fieldBreak+
"Category"+fieldBreak+
"ProductURL"+fieldBreak+
"Image Link"+fieldBreak+
"Model"+fieldBreak+
"Manufacturer"+fieldBreak+
"SalesPrice"+fieldBreak+
"AVAILABILITY");

foreach (Product product in products){
temp = ManufacturerDataSource.LoadForStore("Name").ToString();
tw.WriteLine(product.ModelNumber+fieldBreak+
product.Name+fieldBreak+
product.ProductId+fieldBreak+
product.Description+fieldBreak+
product.Price+fieldBreak+
temp+fieldBreak+
product.DisplayPage+fieldBreak+
product.ImageUrl+fieldBreak+
product.ModelNumber+fieldBreak+
"Manufacturer"+fieldBreak+
product.Price+fieldBreak+
"Y");
}
tw.Close();
SuccessMessageHeader.Visible = success;
dataFeedLink.Visible = success;
FailureMessageHeader.Visible = !success;

}
}

Please tell me the solution. Thank you

Use this