It depends on the version of Excel format the file is saved in. If it's in 2003 and below, it's a multiple stream binary file that will be just about impossible to decipher. If it's 2007 and above, it'll be a .ZIP format file with multiple XML files inside of it. Again, a royal pain to decipher without the SDK. Seriously, save yourself MONTHS of work and use the Visual Studio Tools for Office to do this. A guide to posting questions on CodeProject[^] Dave Kreskowiak

Hi, try this: public ViewResult Index(int userID, string userName) { Person person = new Person(userID); //this assigns person.Id to the user Id //person.Id = userID; //i want to assign name of person to the string userName userName = person.name; } and you should define the class Person with id: public Person(int id) { //get the person from DB or ... _name = "data from DB"; } Comm100 - Leading Live Chat Software Provider

forgot to mention Its just the automatic login that comes with mvc3 razor

What was the issue? Was the list not getting the correct values or did a "SingleOrDefault()" call take care of it? djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.

You try to get sessiondata in data format which you have stored like if userid is integer then try to get data in integer only use type casting

No doubt each employee has a username/name so you can use use compare the username/name of the logged in user to the username/name of the person for whom the holiday booking id for.

This is still not the ASP.NET forum. One of these days I'm going to think of a really clever signature.

ok thanks

Yeah that worked thanks for the help frazzle

//but doesnt chage the value of startdates = 'startdates' I'm confused about what you mean here. Are you expecting one DateTime value to change because of a change to a different DateTime value? If so, that won't happen because DateTime is a struct, meaning DateTime foo = day1; DateTime bar = foo; // bar == day1, foo == day1 foo = day2; // bar == day1, foo == day2 I think I'm missing your question tho.

thank you for the reply, i had to delete all the data in both tables to get it to work

No problem. Sorry I couldn't be more help here. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Not a problem. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier