How to convert session to int, when using sql

Question

I am using C# and have a login session.

The site will only view the news (nyhet) that the journalist have written. (It's a site where the journalist can edit the news)

protected void FyllNyhetDropDownList() 
{
    using (NyhetAdminDataContext dbKobling = new NyhetAdminDataContext())
    {            
        Journalist brukernavn = (from journalist in dbKobling.Journalists
                                 where journalist.JournalistId = Convert.ToInt16(Session["bruker"].ToString())
                                 select journalist).SingleOrDefault();

        List<Nyhet> nyhetliste = (from nyhet in dbKobling.Nyhets
                                  select nyhet).ToList();

        if (nyhetliste.Count() > 0)
        {
            NyhetDropDowwnList.DataTextField = "Tittel";
            NyhetDropDowwnList.DataValueField = "NyhetId";
            NyhetDropDowwnList.DataSource = nyhetliste;
            NyhetDropDowwnList.DataBind();
        }
    }
}

It's here all go wrong. Can anyone help?

where journalist.JournalistId = Convert.ToInt16(Session["bruker"].ToString())

I get the error message

Cannot implicitly convert type 'int' to 'bool'

Thanks for any help!

The where clause requires a conditional statement. You're using the = assignment operator and not the == comparison operator. I would also caution you against the use of Int16 if you need values beyond 2^16 for the JournalistId. — Justin Skiles
– Justin Skiles, Commented Jan 30, 2014 at 18:03

Code Maverick · Accepted Answer · 2014-01-30 18:09:17Z

2

Shouldn't you be using ==?

where journalist.JournalistId == Convert.ToInt16(Session["bruker"].ToString())

answered Jan 30, 2014 at 18:09

Code Maverick

20.5k12 gold badges65 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Damith · Accepted Answer · 2014-01-30 18:08:36Z

0

try below

Journalist brukernavn = dbKobling.Journalists.SingleOrDefault(x => x.JournalistId ==                                                 
                     Convert.Int16(Session["bruker"].ToString()));

answered Jan 30, 2014 at 18:08

Damith

63.2k13 gold badges106 silver badges154 bronze badges

Collectives™ on Stack Overflow

How to convert session to int, when using sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related