Hello friends.
I have Sql Data like below. I have 2 record ILID = 3. When I click checkbox only get one record.
Returning single record.
I need to bring the exact matching records.
So if you have two ILID == 3 you need to bring 2 records. The same applies to other tables.
ID TalepNo GidisTarihi DonusTarihi TalepTarihi KisiSayisi Klas Butce KonaklamaID TeklifID ILID ILCEID SirketID KlasID Ok
1 T-01-10-17 2017-10-12 16:33:11.980 2017-10-12 16:33:11.980 2017-10-12 16:33:11.980 1 1 500 1 NULL 3 101 1 1 1
2 T-02-10-17 2017-12-12 22:11:58.420 2017-10-15 22:11:58.420 2017-11-12 22:11:58.420 2 3 500 2 NULL 3 102 1 2 1
Code.
var ids = new List<int>();
IQueryable<T_Talepler> rows = null;
if (!string.IsNullOrEmpty(klasId))
{
for (int i = 0; i < klasId.Split(',').Length; i++)
{
ids.Add(Convert.ToInt32(klasId.Split(',')[i]));
}
rows = (from v in shy.T_Talepler
join c in shy.T_Klas on v.KlasID equals c.ID
join b in shy.T_Konaklama on v.KonaklamaID equals b.ID
join p in shy.T_IL on v.ILID equals p.ID
where ids.Contains(v.ID)
select v).AsQueryable();
}
