Imam dvije tabele:
Tabela gost:
IDgosta
Ime
Prezime
Spol
Tabela soba:
IDsobe
Broj
Cijena
IDgosta
Pokušavam da se u combobox-u prikažu sobe, odnosno broj sobe i na osnovu izbora sobe iz combobox-a u datagridu prikažu gosti koji su boravili u toj sobi.
U prilogu je code:
Code:
private void Izvjestaj_Load(object sender, EventArgs e)
{
cbSobe.DataSource = Sobe.getSobe();
cbSobe.DisplayMember = "Broj";
cbSobe.ValueMember = "IdGosta";
}
private void cbSobe_SelectedIndexChanged(object sender, EventArgs e)
{
Soba s = (Soba) cbSobe.SelectedItem;
List<Gost> ls =new List<Gost>();
var upit = (from g in DMClass.dm.Gost
where g.IdGost == s
select new {g.Ime, g.Prezime }).ToList();
dgGosti.DataSource = upit;
private void Izvjestaj_Load(object sender, EventArgs e)
{
cbSobe.DataSource = Sobe.getSobe();
cbSobe.DisplayMember = "Broj";
cbSobe.ValueMember = "IdGosta";
}
private void cbSobe_SelectedIndexChanged(object sender, EventArgs e)
{
Soba s = (Soba) cbSobe.SelectedItem;
List<Gost> ls =new List<Gost>();
var upit = (from g in DMClass.dm.Gost
where g.IdGost == s
select new {g.Ime, g.Prezime }).ToList();
dgGosti.DataSource = upit;
Code:
public class Sobe
{
public static List<Soba> getSobe()
{
var upit = (from s in DMClass.dm.Soba
select s).ToList();
return upit;
}
public static List<Gost> getGost()
{
var upit = (from g in DMClass.dm.Gost
select g).ToList();
return upit;
}
}
public class Sobe
{
public static List<Soba> getSobe()
{
var upit = (from s in DMClass.dm.Soba
select s).ToList();
return upit;
}
public static List<Gost> getGost()
{
var upit = (from g in DMClass.dm.Gost
select g).ToList();
return upit;
}
}
U klauzuli where mi pokazuje grešku:
Delegate 'System.Func<Model.Gost,int,bool>' does not take 1 arguments
Operator '==' cannot be applied to operands of type 'int' and 'Model.Soba'
Gdje griješim?
ali