c# - taking more than one cells into one cell -


I have to get your total amount of money to get a list of customers for each monetary unit in its database linq I am using the query (that's right.) when my query's results are displayed with Microsoft report Viewer results of table 1, but I want to do table 2, only the customer name "a" and All monetary unit records The cell; 0.

Is there any suggestions?

Log It produces table 1 is my code: in 

  var query dB kurToplamlist Krbibig in = kur. Bielpi select 1 equals Kurkkriaigetset on Siaarai cariBilg.ID new {cariBilg.ID, // clientid EUROBAKIYE = cariBilg.HESAPADI, cariBilg.K_FIRMAADI, // other column names cariBilg.K_YETKILIADI, // other column names cariBilg K_FIRMATELEFON, // Other column name cariBilg.K_YETKILITELEFON, // Other column name AUDBAKIYE = cariBilg.B_CEPTELEFON, // Other column name MonetaryUnit = String.Concat (kur.CurToplamMiktarGetSet.ToString (), Kur.dovizTuruGetSet.ToString ()), // "100" and "TL / USA etc." };   
 What I should table image to get 2 thank you in advance.  
 
 
 
  var query = in the Kurtapplat list in Kur where Kur Crop Metal Laminate GateSet & gt; Join cariBilg in db.TBLP1CARIs on 0 kur.CariIdGetSet cariBilg.ID selection equals new {cariBilg.ID, EUROBAKIYE = cariBilg.HESAPADI, cariBilg.K_FIRMAADI, cariBilg.K_YETKILIADI, cariBilg.K_FIRMATELEFON, cariBilg.K_YETKILITELEFON, AUDBAKIYE = cariBilg. B_CEPTELEFON, TLBAKIYE = String.ConCat (Kur.CuroptalmimeterGetsetset.tostring), KUR.DovisTourSetset.Toastring ()),}; Select qre.TLBAKIYE query the Var dfg = qre; Var aq = (qw.ID, EUROBAKIYE = qw.EUROBAKIYE, qw.K_FIRMAADI, qw.K_FIRMATELEFON, qw.K_YETKILITELEFON, AUDBAKIYE = qw.AUDBAKIYE, TLBAKIYE = string.join (new) from qw in the query ",", (In the query in the query where qre.id == qw.ID select qre.TLBAKIYE). Undoubtedly ())}).) (); Return AAC;   
 This is my answer.

Comments

Post a Comment