C# with Linq not working

Marc Moineau

Good day All,

I'm new here I just started programming in C# not to long ago.

I'm building a little project connected to an SQL database and I'm not able to get the Result that I want I always get the length in the DataGrid.

I have a ComboBox with a listing. When selecting from the drop-down I take the Value and get the Partner_tb.PartnerKey from it. then I try to get a listing from the Document_tb based on the PartnerKey.

I always get 1 column with the length if I show the partnerKey.toString(). but the value should look like "MarcCyn"

Here's the code I have :

public void partnerBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var partnerKey = from pn in dataContext.Partner_tbs
where pn.PartnerName == PartnerBox.SelectedValue.ToString()
select pn.PartnerKEY;
var documentName = from Document_tb in dataContext.Document_tbs
join Partner_tb in dataContext.Partner_tbs
on Document_tb.PartnerKEY equals Partner_tb.PartnerKEY
where Partner_tb.PartnerKEY == partnerKey.ToString()
select new { Document_tb.PartnerKEY, Document_tb.DocumentName, Document_tb.TransactionSetID, Document_tb.ControlNumber } ;
list997.ItemsSource = documentName;
}

I would really appreciate any help on this.

Thanks in advance.

Marc

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Marc Moineau5y ago
Hi,

thanks for your answer but it's not working I have 2 table to work with
Partner_tb and Document_tb. I have to use the ParnerKey from Partner_tb based on the PartnerName selected in the partnerBox to get the value from Document_tb that has the same PartnerKey and list the value in list997 (DataGrid)

thanks

Marc
Mageshwaran R5y ago
Hi Marc,
Try this code,
public void partnerBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{

        DataContext db = new DataContext("Your Connectionstring");
        Table documents = db.GetTable();
        var partnerKey =
            from pn in documents
            select new { Name = pn.DocumentName, ID = pn.TransactionSetID };

        partnerBox.ItemsSource = companyQuery.ToList();
        partnerBox.DisplayMemberPath = "Name";
       partnerBox.SelectedValuePath = "ID";
}