public List<Voznik> voznik(string username, string password, int IdPodjetja)
{
Voznik result = new Voznik();
// if (Membership.ValidateUser(username, password) && IdPodjetja != null)
// {
//voznik
var result = (from c in db.tbl_zaposlenis
where c.Idkreiranopodjetje == IdPodjetja
orderby c.Priimek
select new
{
ID = c.ID,
ImeVoznik = c.Priimek + " " + c.Ime
});
//foreach (var item in result)
//{
//}
// }
return result;
}
public class Voznik
{
public int ID { get; set; }
public string Priimek { get; set; }
public string Ime { get; set; }
public string Naslov { get; set; }
public int PostnaStevilka { get; set; }
public string Kraj { get; set; }
public string DavcnaStevilka { get; set; }
public string DelovnoMesto { get; set; }
public bool chkOdredilPotovanje { get; set; }
public bool chkRezident { get; set; }
public string ImeVoznik { get; set; }
}
if (Membership.ValidateUser(username, password) && IdPodjetja != null)
{
var result = from t1 in db.tbl_zaposlenis
where t1.Idkreiranopodjetje==IdPodjetja
select new PrikazVoznik { Priimek=t1.Priimek };
};
return result.ToList();
but after add if membership.validate return result.ToList() as not exists..
I tried like this:
List<PrikazVoznik> result = new <List<PrikazVoznik>;
if (Membership.ValidateUser(username, password) && IdPodjetja != null)
{
Member
65 Points
194 Posts
How to display data from db in list
Jan 15, 2020 07:25 AM|progy85|LINK
Hi,
My code:
I need to display all from db in list.
How to do this?
Member
65 Points
194 Posts
Re: How to display data from db in list
Jan 15, 2020 09:26 AM|progy85|LINK
I resolved with my code:
but after add if membership.validate return result.ToList() as not exists..
I tried like this:
Not works...
Member
65 Points
194 Posts
Re: How to display data from db in list
Jan 15, 2020 11:16 AM|progy85|LINK
public class PrikazVoznik {
public string priimek { get; set; }
public string ime { get; set; }
};
[WebMethod]
public List<PrikazVoznik> voznik(int IdPodjetja, string username, string password)
{
List<PrikazVoznik> result = null;
if (Membership.ValidateUser(username, password) && IdPodjetja != null)
{
result =(from t1 in db.tbl_zaposlenis
where t1.Idkreiranopodjetje == IdPodjetja
select new PrikazVoznik { priimek=t1.Priimek, ime=t1.Ime }).ToList();
};
return result;
}