To install the Ajax Control Toolkit

on Thursday, May 14, 2009
Labels: , / Comments: (0)

To install the Ajax Control Toolkit, first download the zip file from http://www.asp.net/ajax/3.5 SP1 Release is here.
Unzip the files into any directory. Give it a name like "AjaxControlToolkit."



Open your Visual Web Developer and right click in the Toolbox area. Select "Add Tab."



Name the tab with something like "Ajax Tookit."



Right click the new tab area, and select "Choose Items..."



This will bring up a dialog box to "Choose Toolbox Items." Select the "Browse" button.



Browse to the directory where you unzipped the Ajax Toolkit files. There is a "SampleWebSite" directory within your "AjaxControlToolkit" directory. Browse to the "Bin" directory within the "SampleWebSite" directory.



Find and select to open the "AjaxControlToolkit.dll" file.



The Choose Toolbox Items dialog will appear, this time with the Ajax Tookit controls selected. Select the "OK" button.


Open or create a web form within your project. Now when you open your toolbox, you will see all of the Ajax Control Toolkit controls, ready for use within your applications.

May your dreams be in ASP.net! More Refernce Click Here

How to Write An SPQuery Using Multiple AND OR Operators

on Friday, May 8, 2009
Labels: / Comments: (1)

Ok, if you’re like me, writing CAML queries can sometimes make your head hurt. Not because it’s terribly complicated, but because there’s not much useful information out there that demonstrates, with REAL examples, how these should be written. So let’s see if we can clarify this:

Scenario 1

Get me all items in a list WHERE fullName equals the currently logged in user.

1
2
3
4
5
6
7
8
9
10
11
SPWeb web = SPControl.GetContextWeb(Context);

string fullName = web.CurrentUser.Name;

SPQuery oQuery = new SPQuery();

oQuery.Query =
    "<Where>" +
    "<Eq><FieldRef Name='FullName'/><Value Type='Text'>'" + fullName + "'</Value></Eq>" +
    "</Where>" +
    "<OrderBy><FieldRef Name='StartTime' Ascending='FALSE'></FieldRef></OrderBy>";

Scenario 2

Get me all items in a list WHERE fullName equals the currently logged in user AND status equals ‘Complete’.

1
2
3
4
5
6
7
8
9
10
11
12
13
SPWeb web = SPControl.GetContextWeb(Context);

string fullName = web.CurrentUser.Name;

SPQuery oQuery = new SPQuery();
oQuery.Query =
    "<Where>" +
    "<And>" +
        "<Eq><FieldRef Name='FullName'/><Value Type='Text'>'" + fullName + "'</Value></Eq>" +
        "<Eq><FieldRef Name='Status'/><Value Type='Text'>Complete</Value></Eq>" +
    "</And>" +
    "</Where>" +
    "<OrderBy><FieldRef Name='StartTime' Ascending='FALSE'></FieldRef></OrderBy>";

Scenario 3

Get me all items in a list WHERE fullName equals the currently logged in user AND status equals ‘Complete’ AND manager is James Lane.

This is where it gets a bit tricky. The following example is INCORRECT and will produce an error when run:

This is the correct way to do it:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SPWeb web = SPControl.GetContextWeb(Context);

string fullName = web.CurrentUser.Name;

SPQuery oQuery = new SPQuery();
oQuery.Query =
    "<Where>" +
    "<And>" +
        "<And>" +
            "<Eq><FieldRef Name='FullName'/><Value Type='Text'>'" + fullName + "'</Value></Eq>" +
            "<Eq><FieldRef Name='Status'/><Value Type='Text'>Complete</Value></Eq>" +
        "</And>" +
        "<Eq><FieldRef Name='Manager'/><Value Type='Text'>James Lane</Value></Eq>" +
    "</And>" +
    "</Where>" +
    "<OrderBy><FieldRef Name='StartTime' Ascending='FALSE'></FieldRef></OrderBy>";

Scenario 4

Get me all items WHERE fullName equals the currently logged in user AND status equals ‘Complete’ OR status equals ‘On Hold’.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SPWeb web = SPControl.GetContextWeb(Context);

string fullName = web.CurrentUser.Name;

SPQuery oQuery = new SPQuery();
oQuery.Query =
    "<Where>" +
    "<And>" +
        "<Eq><FieldRef Name='FullName'/><Value Type='Text'>'" + fullName + "'</Value></Eq>" +
        "<Or>" +
            "<Eq><FieldRef Name='Status'/><Value Type='Text'>Complete</Value></Eq>" +
            "<Eq><FieldRef Name='Status'/><Value Type='Text'>On Hold</Value></Eq>" +
        "</Or>" +
    "</And>" +
    "</Where>" +
    "<OrderBy><FieldRef Name='StartTime' Ascending='FALSE'></FieldRef></OrderBy>";

I really do recommend if you’re doing any work with CAML queries that you download the U2U CAML Query Builder 2007. It doesn’t come without it’s issues, for example, doing a query on a list with a column of type Lookup does not always yield the results I would expect, but it’s still quite helpful. I also often find myself changing the Value Type from Lookup to Text but other than that it’s a huge resource when trying to determine if the data is actually in the list or if there is a problem with the query i’ve written.

Any feedback or questions, please drop me a line.

If you have better solution, just tell me !