Comments by Abdul Imran (Top 7 by date)

This is my code here:

var brand_qry = (from pd in SvarkWindow.prodlist
join pu in SvarkWindow.produnitslist on pd.Product_id equals pu.Product_id
where pu.position > 0
select pd.Product_name + " " + pd.Manufacturer).Distinct().ToList();


foreach (string item in brand_qry)
{
if (!string.IsNullOrEmpty(Search_txt1.Text))
{
if (item.StartsWith(typedString, StringComparison.CurrentCultureIgnoreCase))
{
autoList.Add(item);
}
}
}


And then i am filling the listBox

if (autoList.Count > 0)
{
lbSuggestion.ItemsSource = autoList;
lbSuggestion.Visibility = Visibility.Visible;
}
else if (Search_txt.Text.Equals(""))
{
lbSuggestion.Visibility = Visibility.Collapsed;
lbSuggestion.ItemsSource = null;
}
else
{
lbSuggestion.Visibility = Visibility.Collapsed;
lbSuggestion.ItemsSource = null;
}
}

But later i am unable to access the first field that is "pd.Product_name" and i am getting both field values .
so help me out of it.

Yes i want

Actually when i created service on that time it has taken all the tables and it added to the wcf service but now i have one more table which i want to add now but it is not adding in the wcf service.

Yes its working fine Thank you Mr.Shekher god bless you .you saved my day.