public static string GetProductNames()
{
ProductBLL product = new ProductBLL();
try
{
DataTable dt = product.GetProductNames();
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
string volume = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
volume = dt.Rows[i]["ProductName"].ToString().Trim();
sb.Append(volume).Append(Environment.NewLine);
}
return sb.ToString();
}
else
{
return "No Product saved yet!";
}
}
catch (Exception ex)
{
return ex.Message;
}
finally
{
product = null;
}
}
