PeterKellner.net

I just signed up to give a session at the SoCal Code Camp at CALSTATE Fullerton.  I’ve been to this event before and it’s totally awesome.  Those SoCal guys really know how to throw a camp.  If you’re from around there, please stop by and see me.  It’s going to be a lot of fun.

My Session which covers some basics of ExtJS (a rich JavaScript library) is:

http://www.meetup.com/The-San-Francisco-ExtJS-Meetup-Group/

As many of you know, I’m learning the JavaScript library ExtJS.  It’s basically a very rich development api that allows you to make totally awesome client side control 100% in JavaScript.  It has control that include Grid, Dropdown, Calendar, Image, Drag and Drop, Toolbars, etc.  With ExtJS, you can in a very straight forward way, make interfaces that look like the following:

So, the problem is you have a list that you want to retrieve from that contains multiple values.  Say for example, you have a list of 5 cities and you want to retrieve a list of people in some combination of those cities.  If you use the class SelectValue method with GridView you run out of steam because it’s only one value.  What you’d really like to do is pass the CheckBoxList into the GridView as a selection parameter, but unfortunately, when you do that, you just get the one selected value from the CheckBoxList, not all the values.

I’m sure you can make a custom ControlParameter in ObjectDataSource to solve this, but I really don’t have time for that.  I just wanted something quick (which I now have and thought I’d share).

So, you want to do an update but are wondering what the hec LINQ is doing.  Turns out it is really easy.  All you have to do is run in the debugger and add the Log option to your data context.

Here is an example:

DataClassesGeneralDataContext db3pLogicContext;

db3pLogicContext.Log = Console.Out;

var companyQuery = from tbl in db3pLogicContext.Companies

                   where tbl.ParentId != 0

                   select tbl;

int totalCntParents = companyQuery.Count();

foreach (DBAccess.Company co in companyQuery)

{

    co.CreateDate = DateTime.Now;

    break;

}

db3pLogicContext.SubmitChanges();