1
2
3
4
5
6
7
8
9

enum class Colors
{
   public enum SetType {
   	Red = 1,
   	Green = 2,
   	Blue = 4,
   	Yellow = 8
   }
};

We can get value from this enum:

1

Console.WriteLine(Colors.Green.ToString());

We can takes an enum type and returns a generic list populated with each enum item.
first,we write a class name

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

namespace wind-flowers.Core {
    [Serializable]
    public class SetCollections {
        public SetCollections() { }
        public SetCollections(string id) {
            this._id = id;
        }
        public SetCollections(string id, string title) {
            this._id = id;
            this._title = title;
        }
 
        private string _id;
        public string Id {
            get { return _id; }
            set { _id = value; }
        }
        private string _title;
        public string Title {
            get { return _title; }
            set { _title = value; }
        }
    }
}

then , we can get a List from enum Colors:

1
2
3
4
5
6
7
8
9
10
11
12
13

	public  List<SetCollections> SetList() {
            List<SetCollections> List = new List<SetCollections>();
            String[] EnumTypes = Enum.GetNames(typeof(Colors.SetType));
            foreach (int i in Enum.GetValues(typeof(Colors.SetType))) {
                SetCollections collecte = new SetCollections(
                        i.ToString(), 
                        Enum.GetName(typeof(Colors.SetType), i),
                        getItems(i.ToString())
                    );
                List.Add(collecte);
            }
            return List;
        }

Demo: A Cool jQuery Gallery

Download: down

1
2
3
4
5

<link rel="stylesheet" type="text/css" href="lightbox/css/jquery.lightbox-0.5.css" /> 
<link rel="stylesheet" type="text/css" href="demo.css" /> 
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> 
<script type="text/javascript" src="lightbox/js/jquery.lightbox-0.5.pack.js"></script> 
<script type="text/javascript" src="script.js"></script>

The demo.css is:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

 .clear{
	clear:both;
}
 
a, a:visited {
	color:#00BBFF;
	text-decoration:none;
	outline:none;
}
 
a:hover{
	text-decoration:underline;
}
 
#container{
	width:890px;
	margin:20px auto;
}
 
 
div.nomargin{
	margin-right:0px;
}
 
.pic{
	float:left;
	margin:0 15px 15px 0;
	border:5px solid white;
	width:200px;
	height:250px;
}
 
.pic a{
	width:200px;
	height:250px;
	text-indent:-99999px;
	display:block;
}
 
h1{
	font-size:28px;
	font-weight:bold;
	font-family:"Trebuchet MS",Arial, Helvetica, sans-serif;
}
 
h2{
	font-weight:normal;
	font-size:14px;
 
	color:white;
}

the html is:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

	<div id="gallery"> 
		<div class="pic " style="background:url(gallery/ladybug.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/ladybug.jpg" title="ladybug" target="_blank">ladybug</a> 
		</div> 
		<div class="pic " style="background:url(gallery/bw.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/bw.jpg" title="bw" target="_blank">bw</a> 
		</div> 
		<div class="pic " style="background:url(gallery/bw-lingere.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/bw-lingere.jpg" title="bw-lingere" target="_blank">bw-lingere</a> 
		</div> 
		<div class="pic nomargin" style="background:url(gallery/red-head.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/red-head.jpg" title="red-head" target="_blank">red-head</a> 
		</div> 
		<div class="pic " style="background:url(gallery/wedding_catwalk.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/wedding_catwalk.jpg" title="wedding_catwalk" target="_blank">wedding_catwalk</a> 
		</div> 
		<div class="pic " style="background:url(gallery/tiger.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/tiger.jpg" title="tiger" target="_blank">tiger</a> 
		</div> 
		<div class="pic " style="background:url(gallery/lonely-anguish.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/lonely-anguish.jpg" title="lonely-anguish" target="_blank">lonely-anguish</a> 
		</div> 
		<div class="pic nomargin" style="background:url(gallery/promotion.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/promotion.jpg" title="promotion" target="_blank">promotion</a> 
		</div> 
		<div class="pic " style="background:url(gallery/pristine-lake.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/pristine-lake.jpg" title="pristine-lake" target="_blank">pristine-lake</a> 
		</div> 
		<div class="pic " style="background:url(gallery/tattoo.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/tattoo.jpg" title="tattoo" target="_blank">tattoo</a> 
		</div> 
		<div class="pic " style="background:url(gallery/white-stallion.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/white-stallion.jpg" title="white-stallion" target="_blank">white-stallion</a> 
		</div> 
		<div class="pic nomargin" style="background:url(gallery/furry-feline.jpg) no-repeat 50% 50%;"> 
		<a href="gallery/furry-feline.jpg" title="furry-feline" target="_blank">furry-feline</a> 
		</div><div class="clear"></div> 
	</div>

the script.js is:

1
2
3
4
5
6
7
8
9
10
11
12

$(document).ready(function(){
 
	$('.pic a').lightBox({
 
		imageLoading: 'lightbox/images/loading.gif',
		imageBtnClose: 'lightbox/images/close.gif',
		imageBtnPrev: 'lightbox/images/prev.gif',
		imageBtnNext: 'lightbox/images/next.gif'
 
	});
 
});

Examples 1

1
2
3
4
5
6
7
8
9
10

        List<string> dinosaurs = new List<string>();
        dinosaurs.Add("one");
        dinosaurs.Add("two");
        dinosaurs.Add("three");
        dinosaurs.Add("four");
        dinosaurs.Add("five");
        foreach(string din in dinosaurs)
        {
            Console.WriteLine(dinosaur);
        }

Examples 2
This example shows how you can create a new List of unspecified size, and add object to it.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

public class Client
{
    public Client(string Name, int Age)
    {
        _Name = Name;
        _Age = Age;
    }
    private int _Age;
    public int Age
    {
        get { return _Age; }
        set { _Age = value; }
    }
    private string _Name;
    public string Name
    {
        get { return _Name; }
        set { _Name = value; }
    }
}

1
2
3
4
5
6
7
8
9
10

List<Client> lst = new List<Client>();
lst.Add(new Client("Mike", 20));
lst.Add(new Client("Tom", 22));
foreach(Client cit in lst)
{
     Console.WriteLine(cit.Name);
     Console.WriteLine("------------");
     Console.WriteLine(cit.Age);
     Console.WriteLine(cit.Name);
}

How to bind List<> to GridView?

1
2

GridView1.DataSource = lst;
GridView1.DataBind();

1.Web page request comes from browser.
2.IIS maps the ASP.NET file extensions to ASPNET_ISAPI.DLL, an ISAPI extension provided with ASP.NET.
3.ASPNET_ISAPI.DLL forwards the request to the ASP.NET worker process (ASPNET_WP.EXE or W3P.EXE).
4.ISAPI loads HTTPRuntime and passes the request to it. Thus, HTTP Pipelining has begun.
5.HTTPRuntime uses HttpApplicationFactory to either create or reuse the HTTPApplication object.
6.HTTPRuntime creates HTTPContext for the current request. HTTPContext internally maintains HTTPRequest and HTTPResponse.
7.HTTPRuntime also maps the HTTPContext to the HTTPApplication which handles the application level events.
8.HTTPApplication runs the HTTPModules for the page requests.
9.HTTPApplication creates HTTPHandler for the page request. This is the last stage of HTTPipelining.
10.HTTPHandlers are responsible to process request and generate corresponding response messages.
11.Once the request leaves the HTTPPipeline, page level events begin.
12.Page Events are as follows: PreInit, Init, InitComplete, PreLoad, Load, Control events (Postback events), Load Complete, PreRender, SaveStateComplete, Render and Unload.
13.HTTPHandler generates the response with the above events and sends back to the IIS which in turn sends the response to the client browser.

Download Log4net.

extract the downloaded folder and look for /bin/net/2.0/Log4net.dll

Right-Click the project name and Add a Reference to Log4net.dll

Copy paste the following log4net configuration settings to log4net.config file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

<?xml version="1.0" encoding="utf-8" ?>
<log4net>
	<root>
		<level value="DEBUG" />
		<appender-ref ref="RollingLogFileAppender"/>
	</root>
	<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
		<file value="logsapp.log" />
		<appendToFile value="true" />
		<rollingStyle value="Size" />
		<maxSizeRollBackups value="10" />
		<maximumFileSize value="100KB" />
		<staticLogFileName value="true" />
		<layout type="log4net.Layout.PatternLayout">
			<conversionPattern value="%d [%t]%-5p %c [%x] - %m%n" />
		</layout>
	</appender>
	<appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">
		<file value="logsapp.log" />
		<appendToFile value="false" />
		<datePattern value="-dddd" />
		<rollingStyle value="Date" />
		<layout type="log4net.Layout.PatternLayout">
			<conversionPattern value="%d [%t]%-5p %c [%x] - %m%n" />
		</layout>
	</appender>
</log4net>

Create a logs file in your project directory.

Add Global.asax to your project and then add the following function to it.

1
2
3
4
5
6
7
8
9
10
11
12
13

void Application_Start(object sender, EventArgs e)
{
	// Code that runs on application startup
	ConfigureLogging();
}
protected void ConfigureLogging()
{
	string logFile = HttpContext.Current.Request.PhysicalApplicationPath + "log4net.config";
	if (System.IO.File.Exists(logFile))
	{
		log4net.Config.XmlConfigurator.ConfigureAndWatch(new System.IO.FileInfo(logFile));
	}
}

Copy follow code in your Page_Load demonstrates how to log Debug Information and Errors.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

protected static readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
 
protected void Page_Load(object sender, EventArgs e)
{
	try
	{
		log.Debug("In Page Load Function");
		log.Debug("Going to generate divide by zero");
		int a = 0;
		int b = 10 / a;
	}
	catch (Exception ex)
	{
		log.Error(ex.Message, ex);
	}
}

Compile and run the application, and you’ll see output to the console.

1

<%# DataBinder.Eval(Container.DataItem, "customerId") %>

It’s important to understand that DataItem is actually an object, and that when you use the DataBinder.Eval function, it basically needs to figure out what type of object it is and how to get “customerId” from it. That’s because your data source can be different things, such as a DataSet or DataView, an ArrayList or HashTable, a custom collection, and more. Binding happens on a row-by-row basis, and DataItem actually represents the current row being bound. For a DataSet, DataTable, or DataView, DataItem is actually an instance of DataRowView.When you are binding to a collection, DataItem is an instance of the item within the collection. We can observe this more clearly with the following code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

<%@ Import namespace="System.Data" %>
<%@ Import namespace="BindingSample" %>
<asp:Repeater id="dataSetRepeater" Runat="server">
<ItemTemplate>
<%# ((DataRowView)Container.DataItem)["customerId"] %> -  
<%# ((DataRowView)Container.DataItem)["Name"] %> <br />
</ItemTemplate>   
<AlternatingItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "customerId") %> -  
<%# DataBinder.Eval(Container.DataItem, "Name") %> <br />
</AlternatingItemTemplate>                    
</asp:Repeater> 
<br><br>
<asp:Repeater id="collectionRepeater" Runat="server">
<ItemTemplate>
<%# ((Owner)Container.DataItem).OwnerId %> -  
<%# ((Owner)Container.DataItem).FirstName %> <br />
</ItemTemplate>    
<AlternatingItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "OwnerId") %> - 
<%# DataBinder.Eval(Container.DataItem, "FirstName") %> <br />
</AlternatingItemTemplate>        
</asp:Repeater>

In the first Repeater, we are binding to a DataSet, the ItemTemplate shows how to access values by casting DataItem to a DataRowView [5, 6], the AlternateItemTemplate will output the same information but through DataBinder.Eval [9, 10].

In the second Repeater, we bind to a custom collection. Again, the ItemTemplate shows how to cast DataItem to the right type and access the fields directly [18, 19] while the AlternateItemTemplate shows how the same is accomplished with DataBinder.Eval [22, 23].

In both cases, the ItemTemplate and AlternateItemTemplate will output the exact same information. The only difference is how the information is retrieved. DataBinder.Eval is far less performing, but has the benefit of being ignorant of the underlying structure, making it both quicker to develop and more likely to resist future changes. The goal here isn’t to discuss the merits of these approaches, but simply show what DataItem truly is in order to build a proper foundation of understanding.

Katrina has been roped in as the face of the Lux Purple Lotus & Cream, a soap infused with anti-ageing properties.

“I don’t think every actress in Bollywood has been associated with Lux. A select few actresses, who they felt suited the brand right (have been associated with it) and they all have been actresses of great stature with wonderful careers and some wonderful work,” Katrina told IANS on Sunday (Feb 28).

“I am very honoured to join the group of people who have been with Lux over the years,” she added.

The new commercial has been shot in Bangkok and directed by Marco. While Katrina has been styled by fashion designer Rocky S for the ad, the music has been composed by trio Shankar Ehsaan Loy.

Actor Abhishek Bachchan also endorses Lux with wife Aishwarya.

This version fixes a lot of bugs relating to json data, formating, xml manipulation and add following features.

* The user can now manipulate the number of requested pages. This is done with adding a input box in the pager.
* I have added 4 methods – add, update, delete get row data. With these method we can manipulate the data at client side and of course a possibility to add local array data. See documentation for more information.
* Added is a method to load data only once from the server – loadonce flag in settings. After loading data we do all the manipulation at client side – sorting, scrolling ant etc. Note that in this case pager is disabled.
* Added is a new data type – local (against with xml and json). When this flag is set the grid expect data to be loaded locally via array.
* Now we can multi select rows. This can be done with only one flag multiselect. This feature can be used with server and local array data.
* For first time I introduce a sub grid. This feature can work only with xml data for now. The code and style for sub grid must be optimized and should be used with json too. See example page for more details.
* It is possible now to export the grid data to xml and json format. This is done with two new methods.
* A few new methods are added according to the new features – see documentation page for this.
* New theme of course
jqGrid is an Ajax-enabled JavaScript control that provides solutions for representing and manipulating tabular data on the web. Since the grid is a client-side solution loading data dynamically through Ajax callbacks, it can be integrated with any server-side technology, including PHP, ASP, Java Servlets, JSP, ColdFusion, and Perl.

jqGrid uses a jQuery Java Script Library and is written as plugin for that package. For more information on jQuery, please refer to the jQuery web site.
Demo: http://trirand.com/jqgrid/jqgrid.html
Download: http://www.trirand.com/jqgrid/jqGrid-3.4.4.zip
Source: http://www.trirand.com/blog/?p=13

Step 1

First up create a new document – I’ve made sure that I have lots of room to work with so I chose 540 by 440 as my size.

Fill the background with a dark gradient or just a solid colour (Edit > Fill and use a colour like #262626) if you don’t know how.

Step 2

Create a new layer (Layer > New > Layer). Select the rounded rectangle tool and use the settings below.

Left click somewhere in the middle of your document.

Right click and left click “make selection”.

Now you should have a selection like this:

Step 3

Next up we are going to be filling our selection with a gradient. Select the gradient tool anduse these settings. You can get the green gradient by clicking that area and changing the left colour to #7ebe3e and the right to #a8da77 or by setting your foreground colour to #7ebe3e and your background colour to #a8da77 whatever suits you

Left click in the middle of the selection and drag to the bottom while holding the shift key (which keeps it straight) and release. Now you can deselect your selection (Ctrl + D).

Step 4

Now we are going to be adding an outside stroke to our button. The easiest way to do this is to go Layer > Layer Style > Stroke.

Step 5

On a new layer (Layer > New > Layer) make a selection of 3 by 40 pixels in the position shown below. The easiest way to do this is to select the rectangular marquee tool and use the fixed size setting with width set to 3 pixels and the height set to 40 pixels.

Fill (Edit > Fill) with white (#ffffff). And deselect (Ctrl + D if you’ve forgotten already). And with any luck your button should now be looking like this…

Step 6

Add a double arrow “»” (copy and paste it if you want) on a new text layer.

Step 7

Go Layer > Layer Style > Drop Shadow.

This should make it a little easier to read and stand out from the background a little bit – some depth.

Step 8

Add some text for your button like your website’s name or something like “Home” if it is going to be a link to the home page and you are complete.

Here is an orange version of the button. You can change the colour of the button by adding a different coloured gradient to the base layer (the first layer we created).

There is an example,here we have two form element,a textbox for user name and a password box for password.
<form action="myscript.aspx">
<input type="textbox" name="username">
<input type="password" name="password"><br/>
<input type="submit">
</form>

Then in the myscript.aspx.cs :
string sql = "SELECT * FROM Users WHERE UserName = ‘" +username.text +"’ AND Password = ‘" + password.text + "’";

In the previous code block it executes the built SQL script directly, if count is greater than one, then you know the values entered in for the user name and password were the ones matching the database.

Now with that code in the previous example, suppose someone entered the following string into your username text box:
‘ or 0=0 —
Then the sql like this:
string sql = "SELECT * FROM Users WHERE UserName = ‘nike’ or 0=0 –‘ AND Password = ‘12345678′";
The apostrophe will close the username value being sent to the SQL query, then pass another argument to the SQL query, after the last argument it then comments out the rest of the query using the "–". Since the second argument they entered into your texbox is an "or" statement, the first check on the user name doesn’t matter, and since 0 is always going to equal 0 the script will execute successfully and return a positive logon. Guess what? Your intruder now has access to your application.

Let’s take another example of SQL injection,lets do this:
‘; drop table users —
Definitely something that can ruin your day. Of course this type of an attack you’ll probably notice pretty quick.

How to preventing SQL Injection Attacks?
first: Parameterised Queries
secend:Using Stored Procedures

(to be continued)

I can barely keep my eyes open after what was an extremely busy and strenuous week. You’re welcome for all the juicy gossip I gave you. You know I had to reward my faithful readers with something for these past four loyal years. Hope I didn’t disappoint…

Graduation day was here and all our favorites were ready to pomp and circumstance and do whatever it was that graduating seniors do. It seemed like our kids were leaving Constance and St. Jude’s unlike how they arrived: quietly. That was until I decided to go out with a bang. Sorry. But I just had to do something to liven up graduation. So I came up with labels for my favorites. Don’t hate. Chuck Bass: coward. Blair Waldorf: weak. Nate Archibald: whore. Dan Humphrey: ultimate insider. Serena van der Woodsen: soon to be has been.

Serena was beyond pissed. She didn’t like the way I tagged everyone and ruined graduation. Well, sorry Miss Judgmental. She decided to take matters into her own hands and find out who was behind this amazing site. With the help of her friends, everyone came together to unmask my identity. Chuck believed I was at Serena’s post-graduation luncheon so he sent me a blast. And whose phone just happened to buzz at that exact moment? Why Jonathan’s, Eric’s beloved boyfriend. This meant Jonathan was Gossip Girl??

Nope. He wasn’t (you think I would go to Montreal for winter break? Yeah freaking right). The reason Jonathan’s phone went off was because he had hacked into my system and was receiving all my emails (not to self: change password ASAP!). Because of this, Jonathan had a whole lot of dirt on everyone. This was good for no one. Except Jenny Humphrey. The Mean Girls were set on finding a new Queen Bee to take over. If Jenny wanted the job then she had to bring them the most gossipworthy piece of unknown information. Jenny didn’t even want the gig but she also didn’t want to be the lowest on the Constance food chain. Plus, Emma Boardman (remember the girl who was like obsessed with losing her V-card last fall?) had recently moved to the city and was enrolling in Constance in September. That girl was like Penelope/Hazel/Isabel 2.0. Yuck. But thanks to Jonathan, Jenny had some really juicy info. Although, this gossip would totally destroy Blair/Chuck. What was Jenny to do?

Meanwhile, Blair was obsessed with the information Serena had given her re: Chuck saying he loved her. Was it an “I LOVE HER!” or an “I love her?” Blair was dying to know how Chuck enunciated it as well as see if she could make him say it again. Obviously, this was not easy. Chuck would just not do it. UGH! What the eff, Chuck? Man up!

However, it seemed like the idea of Chuck ever saying he loved Blair changed when I decided to do an air raid. Of gossip. I sent out tons of confidential info that no one had known about: Dan and Ms. Carr having sex in the costume closet. Jenny’s semi nude photoshoot. Chuck sleeping with Vanessa. Blair shoplifting. Nate turning his dad into the FBI. And most importantly, Blair and Jack Bass hooking up on New Year’s. You didn’t think I’d let you all leave for college without a huge scandal, now did you?

Everyone was livid at each other. This was not the way to find out about your BFF’s most inner and darkest secrets. Wah wah. Maybe if you all weren’t so wicked this wouldn’t have happened (but then our lives would be way boring so thank you for being so salacious!). Chuck was beyond angry at Blair. How could she do that to him? And with his uncle? Blair tried to explain. Chuck had skipped town. She was lonely. Jack was there. But anyway that was beside the point. Blair didn’t want to be weak anymore. She demanded to hear those three words from Chuck once and for all. She knew he meant it. All he had to do was repeat it. Just say it! And of course, Chuck just couldn’t do it. Maybe he was a coward. Blair was crushed. Guess she and Chuck were just destined to never be together. Worst. News. Ever.

Now that all the juicy gossip was out, Jenny didn’t have a one up on the Mean Girls. This meant she was going to have to live under the dictatorship of Emma next year. Sucks. But luckily, Blair came to her defense. In Blair’s eyes, Jenny was her queen. And this meant in the fall Jenny would rule the school. Eat it, Emma. You’re under Jenny’s reign now.

My attack only made everyone more interested in finding out my true identity. So Serena texted me to meet her at The Oak Room. Did I show my face? Of course not. But I did send out a blast to everyone to meet there. Come on, people. You all make me who I am. I couldn’t do it without you. In one way or another, you’re all Gossip Girl. But I am the Gossip Girl. Don’t ever forget that. You know you love me. And you’ll be happy to know I’m coming to college with you. See ya in fall, bitches!

One week later, Dan and Vanessa were hanging out downtown by their new school, NYU. This was how it was going to be next year (um, in a coffee shop in a less than stellar zip code? Seems like some things never change). Nate showed up in his intern clothes (sexy!). The mayor’s office was not exactly what he had in mind. He begged Vanessa to take him with her to Europe. Maybe they could still have that backpacking trip they had planned earlier in the year? And seriously, how could Vanessa say no? Nate and Vanessa’s European Adventures? So jealous! Oh, and guess who the crew bumped into at the coffee shop? A random kid named Scott who had just transferred to NYU from BU. He seemed kind of cool. And familiar. I have a feeling he might be…possibly…could be, um, Lily and Rufus’ lovechild?!? Not dead, living in NYC and going to NYU? All I can say is WOW.

Serena was getting ready to spend her summer in Europe too. Looked like she was going to have a nice summer traveling around and being free-spirited Serena. Or was she? Serena was greeted by Carter Baizen (um, yes, not a misprint). He told her he finally found what they had been looking for in Santorini a couple years ago: her father. And now it seemed that her dad was in Fiji. Whaaaat? Serena had been looking for daddy van der Woodsen? Who would have known? Serena went off to Fiji to find him. With Carter. Interesting. Very interesting.

Blair was still upset over the whole Chuck thing. And to make matters worse, it didn’t help when I reported Chuck being spotted all around Europe. Summer 2008 flashback, what? However, Blair was being strong and moving on. New school, new people, new life. But then Chuck came back to the city and found Blair walking on the street. He told her why he was really in Europe: he was in Paris to get her favorite macaroons, Berlin for her favorite stockings. And then Chuck finally said it: I love you. AHHHHHHHHHHHHHHHHHHH. What we have been waiting for all this time! TOOK YOU LONG ENOUGH, C! Blair was ecstatic. OMG Chuck loves Blair. Blair loves Chuck. We can all die happy now. Woo hoo!

But sorry to rain on your parade, Blair. What goes around comes around. You know how you were all mean and stuff to Georgina? Well, that girl doesn’t take it lying down. Stealing the wheel from Jesus, Georgina decided to take control of her life and enrolled at NYU. And guess who she requested to live with? Yep, Blair Waldorf. Meet your new roomie, B. Who’s gonna bring the mini-fridge?

Oh and BTW in old people news: Rufus and Lily made up. They are madly in love, blah blah blah and Rufus proposed! OMFG they’re getting married. Serena and Dan will finally be step-brother and sister and Jenny will soon be moving into the VDW/Bass apartment. This is a game changer, people. Can’t wait to see what happens.

What a way to end the school year. This year was bananas on bananas. I would recap it all but I am just so tired. Go back and read my old blogs to refresh your memory on what an eventful 2008-2009 it has been. Because I’ve had such a crazy year I am going to take some time off this summer to reflect. As well as get ready for next year. You know I’ll miss you. Xoxo Gossip Girl.

xo xo Gossip Girl | 171 Comments »

The End is Near

May 15th, 2009

OMG!  Can you believe we’re graduating?  After four long years it’s finally coming to an end.  No more pencils.  No more books.  No more teachers–Well, until college at least.  Goodbye, Constance.  Goodbye, St. Jude’s.  It’s been real…or rather, really drama filled.  And I know what you’re all thinking.  You’re welcome.  High school wouldn’t have been the same without yours truly.  I may not have been the nicest but I was definitely the most fun.  What would high school have been without me?  Oh wait.  I know: B-O-R-I-N-G.  But have no fear.  It ain’t over just yet.   We still have a few more days of HS left.   I can’t promise anything but I will say that I might have some salacious ammo up my sleeve.  Gotta go out with a bang, right?

xo xo Gossip Girl | 70 Comments »

Prom Dramz

May 12th, 2009

Oh prom. The night we’d been waiting for since we first stepped out of our limos and town cars and into our prestigious private schools. Some of us (ahem, Blair Waldorf) had been expecting the most perfect event of our entire academic career. So was prom 2009 perfect? Not even close. But it was monumental and oh so gossip worthy.While prom was only hours away, Serena was still locked up after getting arrested for the “stolen” bracelet. Thanks, Lily. After Lily realized Serena learned her lesson, she finally came to drop the charges and let her daughter flee the coop. Serena could not believe her mother would do this to her. What kind of mother was Lily? To not only have the police arrest her only daughter but then to have her actually locked up over night, what the hell, mom? Lily was just trying to teach her daughter some respect. Serena didn’t care. She wanted nothing to do with her mother. Serena wasn’t going anywhere. She was staying in jail and giving Lily a dose of her own medicine. Oh Serena. Looks like you were ditching a prom dress for an orange jumpsuit.

Meanwhile, Blair’s prom preparations weren’t going as planned. For a girl who had made a “prom scrapbook” before she could barely read, everything was turning disastrous. The florist lost Blair’s corsage, the limo had been already booked, the hotel room was canceled and Blair’s dress was ruined at the dry cleaners. The horror! Blair was panicking. She and Nate were supposed to have a perfect night celebrating their perfect relationship as well as the end of a perfect four years. Nate had his suspicions as to what was going on. Chuck was obviously sabotaging them! But when Nate confronted him, he denied it. How many times did Chuck have to tell him? Blair was all Nate’s. Hmm…

Over in Brooklyn, Dan was getting ready to not go to prom. He, his sister and Vanessa were going to watch scary movies (how depressing and cliché). Their prom night sounded like it was going to be just like every other sad night in their lives. But when Dan found out Serena was still in jail he knew what he had to do. He sprung her. Dan couldn’t let Serena miss her prom. I hate to say this but: Dan Humphrey, what you did was a pretty stand up thing and I half salute you (only half bc as far as I’m concerned you’re still a narc from DUMBO).

At the prom, Blair was dealing with the Mean Girls once again (btw, Blair received a dress from Paris, presumably from her father. And this new dress was AMAZING!). The Mean Girls were trying to ruin Blair’s chance of being prom queen. They were going to stuff the box with ballots that had Nelly Yuki’s name on it. Seriously, Nelly Yuki as prom queen? No thanks. As much as I love Nelly Yuki, this is prom queen not nerd queen. When Penelope went up to announce the winner she was surprised. Nelly Yuki was not the winner. It was Blair! Oh, and Nate was prom king, duh. And who was behind it all? Chuck Bass. Yep, seemed like he knew all about Blair’s prom scrapbook and was determined to make all her dreams come true. OHMYGOD!

Even though Blair got everything she wanted she was still feeling kind of bad about something. That’s when she realized that maybe this was the end of her and Nate. Nate was her high school boyfriend. And perhaps that was all he’d ever be. But it was possible that what the two of them had was something that could never go beyond the hallways of Constance and St. Jude’s. So Blair and Nate broke up. And you know what? I kind of respect them for their mature decision.

Serena and Blair met each other outside the prom. They regaled over how they had been though so much together. They were practically sisters. Aww. Like I’ve said before no one does Besties better than Serena and Blair! They make my heart melt. Of course, Serena had to fill in Blair about what Chuck had said to her that night at the Russian Tea Room. Ahhh. Blair was finally going to know how Chuck actually felt about her!!

All the while, Rufus was still upset with Lily over having Serena arrested. But he realized that it wasn’t Serena who needed to change. It was Lily. And even after twenty years, Rufus believed she was still trying to figure out she was. This hit Lily hard. Maybe Rufus was right. Lily realized the only way to make things right was to be on better terms with her own mother. She made mistakes just like Cece had made (even though she never in a million years thought she’d be that kind of mother). Now, Lily kind of understand Cece better and she was finally able to forgive her mother for all the things that had happened in the past (ie giving baby away for adoption, paying off Rufus, etc). Sweet. And luckily, Serena was wiling to forgive Lily too. Let’s give it up for mothers and daughters uniting (what? Even Gossip Girl has a mother :p ).

Okay so now that prom’s out of the way, we have graduation coming up next. The end of senior year is way tiring. Also, I have a feeling I am going to be very busy in the upcoming week. I might be dropping some explosive info. Gossip bombs away. Xoxo Gossip Girl

xo xo Gossip Girl | 53 Comments »

Save the Last Dance

May 8th, 2009

I feel like such a slacker.  Prom is only days away and yet I’ve done absolutely zero reporting on it.  I guess that’s what happens when there’s so much other drama going on (not that I’m complaining, obvi).  Is anyone else extremely excited for what should be a night we will never forget?  You know I am.  I hear this year Constance and St. Jude’s will announce a Prom Queen and King.  Hmm…Who do you think should win?  Who do you think will win?  I know who I’m voting for.  But I’m not gonna say.  Don’t want to sway any votes.  You know how persuasive I can be.  See ya at the dance!  I’ll be the one having a ball…

xo xo Gossip Girl | 59 Comments »

Shock. Total and utter shock.

May 5th, 2009

Shock. Total and utter shock. Serena van der Woodsen in jail? And because her own mother had her arrested? OMFG! Could it get any crazier than that? Of course it can. This is the Upper East Side, people! Okay, okay, let’s go back to how this all started so we can totally understand what exactly went down…

Gabriel had vanished with all the money Lily, her Coop and Rufus had given him to invest. Serena could not believe this was happening. She brought that loser into everyone’s lives and because of her people had just lost serious $$. Serena decided to take it into her own hands to get the money back from Gabriel. So she did what any girl would do in order to get a guy to talk to her ASAP: Serena told Gabriel she was pregnant. And it worked. Dude called back in literally seconds. Serena met Gabriel at The Palace and told him she wasn’t knocked up. Instead, she wanted all the money he was stealing back. Gabriel told her he didn’t have it. Poppy did. It was all her scheme. Turned out, Poppy was actually a faux-calite. She snuck her way into high society and was just lucky to make friends with rich people. This meant it was Poppy they were after. Bitch was going down.

By trying to clean up thw huge mess herself, Serena was hoping to not have to tell her mom about this unfortunate incident. Lily had been treating Serena so well lately. Seemed like she was truly proud of the woman Serena was becoming. Lily even gave her a diamond bracelet that was a family heirloom (it was like way, way nice). This made Serena even more uncomfortable about having to explain the money issue. She was set on working this out all on her own. If she could just get the money back and return to everyone then all would be good. Right? Unfortunately, Dan Humphrey ruined all that. Dan overheard Serena et al. talking about Gabriel taking the money and fleeing. He was stunned. Rufus had given Gabriel Dan’s college dough. Without that money there was no way Dan was gonna go to college. So he did what any dorky and neurotic kid would do: he went straight to Lily. Ugh (go back to Brooklyn). Lily wanted to keep this totally under wraps. If word got out about them being involved, Serena’s life could be ruined. Do you know what kind of bad press this would be? Lily decided to pay back all the investors herself (it’s good to be a Bass). For Rufus, though, she was making an exception. Lily was going to pay him $5,000 a month. Seemed not only a little preferential but also a bit like charity.

And while Lily was doing that, Rufus was preparing to pop the question. Yep, he wanted to be her fifth husband. Rufus went to Eric to ask for Lily’s hand in marriage (adorable!!). Eric, of course, gave his blessing but was a little apprehensive about the way Rufus was going to propose. Lily was used to elaborate proposals (like on top of pyramids or in blimps). This was not something Rufus could give to her. But he made due and decided to do it the Humphrey way. Rufus cooked up a dinner of Lily’s favorite foods and brought her lilies. Looked like the van der Woodsens (+Chuck) and the Humphreys were officially going to be united for good.

In order to get Poppy the crew needed to whip up the most badass plan they could think of. Luckily, Georgina was there. While she was still in love with Jesus, she was easily convinced to play the part of Sherilyn Phillips, a rich Canadian who was new to New York. The first person “Sherilyn” was to meet in the Big Apple? Why none other than Poppy Lifton (and obviously Poppy agreed to meet since she only associates with rich people). The group bugged Georgina and waited around the Russian Tea Room until Poppy started talking money. It was only a matter of time until they had Poppy right where they wanted her. And I can’t believe I’m about to say this, but: Thanks for your help, Georgina.

While everyone was waiting, some major drama went down. First off, Blair was still deciding if she wanted to move into Nate’s apartment with him. This was a huge step and one she couldn’t make properly until a major question was answered: what the hell was Chuck’s deal? If Chuck wanted her then he had to tell her that. If he didn’t then she could be free. But she couldn’t make up her mind until she knew exactly how Chuck felt. So she made him tell her. And sadly, he said it was all just a game. NOOOOO! Blair was heartbroken but at least now she could move on with her life. Serena heard the whole thing and could not believe Chuck did that. What the eff? And then he finally admitted it. The reason he told Blair that it was a game was because he actually did love her (and he really said “I LOVE HER!” AHH). Chuck just couldn’t give her what she needed. OMFG! Chuck Bass just admitted he loved Blair Waldorf! But he didn’t tell her that. GAH!

Blair informed Nate she wasn’t going to move in with him. Not because of Chuck but just because it wasn’t right. Nate agreed. They still had issues they had to work out. Blair told him maybe their next step should be prom. Omg! Prom. I almost totally forgot about it with all this crazy action happening. But yes, Nate and Blair going to prom together is like icing on the cake to four years of high school.

Georgina had Poppy right under her thumb. Or rather, “Sherilyn” did. She offered to give money for the investment and, of course, Poppy happily accepted. Yes! It was time for the bitch to get what she deserved. Unfortunately, when the cops got to the Russian Tea Room they weren’t there for Poppy. Rather, they were there for Serena! Turned out, in order to stop Serena from turning this mess into a big deal, Lily called in the police. She said her bracelet was stolen and Serena had taken it. OMG! So while Serena was being handcuffed, Poppy was able to get out scott free. With Georgina’s bible money. Yep, Georgina had given Poppy money for bibles for the church camp (with the thought she would get it right back). OMJC!

But we all know Georgina Sparks. And while she has changed a bit no one effing crosses her. With Jesus on her side or not, Georgina was now out for Poppy’s blood. It was going to be the war of the Upper East Side bitches. This was gonna get ugly.

Meanwhile, over at the van der Woodsens Rufus was about to get on his knee. However, he found the paperwork re: Lily paying him $5,000 a month. What the hell was that? When he confronted Lily she told him she had to take care of it herself. He was humiliated. Lily tried to explain but he didn’t care. When Serena got arrested it only made matters worse. How could Lily lock her daughter away like that? Lily argued it was for the best. She couldn’t let this scandal get out. It would totally embarrass her. Rufus was shocked. This didn’t sound like Lily. It sounded like Cece. Was Lily becoming her? Rufus wasn’t going to be proposing to Lily. Their families weren’t going to blend. Looked like it was over. Sadness.

ACK! This was insane. Serena’s in jail! Chuck admitted he loved Blair! Nate and Blair are going to prom together! Rufus and Lily are over?! Georgina is back to her old self! This is all amazing! Just what I like to see. And prom is only a week away. Save a dance for me? Xoxo Gossip Girl

• Users will often close the web browser when a PDF is opened, mistakenly believing the document has been opened in Adobe Reader
• The attribute historically used to open a new window, target, has been removed from the HTML 4.01 Strict specification (it’s now deprecated)
• Opening a new window is a behaviour and should be moved to the behavioural layer¹¹.

Using JavaScript can also be particularly useful when a website is content managed. Rather than having to rely on site editors to remember to open a link to a PDF in a new window the process is handled by a simple JavaScript function.

Registering an event

The first task is to create an event that occurs when the page has loaded. Rather than trying to execute a function call using <body onload="callfunction()"> within the HTML page we’re going to use Simon Willison’s addLoadEvent(func). This will allow us to add function calls once the page has loaded.

Type the following JavaScript into the .js file (all subsequent code should be entered before this function so the addLoadEvent is last):

function addLoadEvent(func)
{
    var oldonload = window.onload;
    if (typeof window.onload != 'function') { window.onload = func; }
    else { window.onload = function() { oldonload(); func(); } }
}
addLoadEvent(fNewPDFWindows);

The function fNewPDFWindows()

Create an empty function in your JavaScript file called fNewPDFWindows. To avoid any JavaScript errors with the script, check to see if the command getElementsByTagName is available:

function fNewPDFWindows ()
{
    if (!document.getElementsByTagName) return false;
}

The second task is to create an HTML object collection of any links within the page. The following line gets all links within the page:

var links = document.getElementsByTagName("a");

Insert this line after the check to see if getElementsByTagName object method exists as follows:

function fNewPDFWindows ()
{
    if (!document.getElementsByTagName) return false;
    var links = document.getElementsByTagName("a");
}

The next task is to loop through all of the links and check to see if we want to open any of the links in a new window. If the link is to a PDF document then we’ll open it in a new window.

Looping through the links

First create the loop that goes through all the links in the page, as follows:

function fNewPDFWindows ()
{
    if (!document.getElementsByTagName) return false;
    var links = document.getElementsByTagName("a");
    for (var eleLink=0; eleLink < links.length; eleLink ++)
    { }
}


The indexOf method

Next we need to determine as we loop through the links whether the link is to a PDF document or not. The indexOf method is ideal for this by returning the index of the search value (the position of the search value in the string). The indexOf method requires a search value but you can also specify where to start the search from within the string (in this example we don’t need to pass the method this parameter):

So pass the indexOf method the string “.pdf” to find out if the file being linked to is a PDF document. The indexOf method returns either -1 if the string isn’t found or the index of the matching text.

function fNewPDFWindows ()
{
  if (!document.getElementsByTagName) return false;
  var links = document.getElementsByTagName("a");
  for (var eleLink=0; eleLink < links.length; eleLink ++) {
    if (links[eleLink].href.indexOf('.pdf') !== -1) { }
  }
}


onclick function

Next we need to apply an onclick event to each of the links to PDF documents, so when they’re clicked the new window is opened:

links[eleLink].onclick = function() { }

First, let’s open the new window, and give the window some parameters. The parameters we’re going to pass are as follows.

• URL – the document we want to display in the new window
• Specs – a comma separated list of window properties such as scrollbars etc

For a comprehensive list of windows properties take a look W3C schools DOM open method page¹⁴.

The completed function in this example is as follows. This opens the link address in a new, re sizable window with scrollbars:

links[eleLink].onclick = function() { window.open(this.href,'resizable,scrollbars'); return false; }

Insert the onclick event within the if statement that detects whether a PDF document has been found:

function fNewPDFWindows ()
{
  if (!document.getElementsByTagName) return false;
  var links = document.getElementsByTagName("a");
  for (var eleLink=0; eleLink < links.length; eleLink ++) {
  if (links[eleLink].href.indexOf('.pdf') !== -1)
  { links[eleLink].onclick = function()
  { window.open(this.href,'resizable,scrollbars');
  return false;
  }
  }
  }
}


Warning users the document opens in a a new window

The final task is to ensure users are aware that the link will open in a new window. We need to be as clear as we can with this to minimise confusion.

We’re going to do this by firstly amending the title text of the link and secondly inserting an image with alternate text of “(opens in a new window)”. The link title can be set as follows:

links[eleLink].title += "\n(opens in a new window)";

Next we will create an image element and set it’s src and alt attributes. Finally we’ll append the image to the hyperlink using the appendChild method.

var img = document.createElement("img"); img.setAttribute("src", "i/new-win-icon.gif"); img.setAttribute("alt", "(opens in a new window)"); links[eleLink].appendChild(img);

The final function is as follows:

function fNewPDFWindows ()
{
  if (!document.getElementsByTagName) return false;
  var links = document.getElementsByTagName("a");
  for (var eleLink=0; eleLink < links.length; eleLink ++) {
  if (links[eleLink].href.indexOf('.pdf') !== -1)
  { links[eleLink].onclick = function()
  { window.open(this.href,'resizable,scrollbars');
  return false;
  }
  var img = document.createElement("img");
  img.setAttribute("src", "i/new-win-icon.gif");
  img.setAttribute("alt", "(opens in a new window)");
  links[eleLink].appendChild(img);
  }
  }
}

Conclusion

This very short function demonstrates how easy it is to open links in new windows automatically. This means your site will be more likely to validate, more likely to work correctly in future browsers and will be more usable for its users.

Resources for the new window tutorial

Download the required resources before beginning this tutorial.

Start by opening the file ‘pdf-new-window.htm’. This is the content we’re going to apply our JavaScript new window function to.

In this tutorial, we will learn how to create stored procedures for four of the most common SQL tasks that every ASP.NET and database developer has to go through. And that is creating, retrieving (displaying), updating and deleting records in a table in the database. For the purpose of demonstration, we’ll first create a table, and then add four stored procedures to the database, one for each of the SQL tasks we talked of above. Let us now proceed to the code.

Creating the Table
We’ll create a table with the name of ‘Names’ in our SQL Server database. Open SQL Server Query Analyzer and copy/paste following code in it. Then press F5 key to execute/create the table.

CREATE TABLE [dbo].[Names] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FirstName] [varchar] (50) NOT NULL ,
	[LastName] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO

Executing the above SQL code will create a table ‘Names’ with following structure in your SQL Server database:

Explanation

We basically create a very simple table with just 3 columns. The first column with the name of ‘ID’ is an identity column, meaning it will increment automatically. It is also our primary key. The second and third columns with the names of ‘FirstName’ and ‘LastName’ are for storing first and last names that we’ll add later on, using ASP.NET pages.

Creating the Stored Procedures

Let us now create the four stored procedures to create, retrieve, update and delete records in the ‘Names’ table.

i. Stored Procedure for Creating a New Name

This stored procedure encapsulates the INSERT SQL statement to add a new record to the ‘Names’ table. Copy following code and paste in it your SQL Server Query Analyzer window and then press the F5 key to execute/create this stored procedure:

CREATE PROC dbo.AddName
	@FirstName	varchar(50),
	@LastName	varchar(50),
	@ID		int	OUT
AS
	INSERT INTO Names(FirstName, LastName) VALUES (@FirstName, @LastName)

	SET @ID = @@IDENTITY
GO

Explanation

After the CREATE PROC statement, comes the name of our stored procedure. We append dbo. before it to tell SQL Server that this stored procedure belongs to ‘dbo’ user account. We then tell SQL Server that this stored procedure will be accepting three arguments of the type given above. The third argument has the keyword OUT appended to it, which tells SQL Server that we’ll be using this argument to send data back to the calling ASP.NET page. Finally, after the INSERT statement, we retrieve the primary key of the newly added record using SQL Server’s @@IDENTITY variable. We assign it’s value to the out-going ‘ID’ parameter and we are done.

Tip: Unless you really know what you are doing, always append ‘dbo.’ before the name of all the objects (tables, stored procedures) you create in SQL Server.

In a nutshell, this stored procedure will accept first and last names. It will insert them in the ‘Names’ table and return the newly generated identity back to the ASP.NET page.

ii. Stored Procedure for Retrieving All Names from the ‘Names’ Table

This stored procedure will return all the records from the ‘Names’ table. Copy following code and paste in it your SQL Server Query Analyzer window and then press the F5 key to execute/create this stored procedure:

CREATE PROC dbo.GetAllNames
AS
	SELECT [ID], FirstName, LastName FROM Names ORDER BY [ID] ASC

GO

Explanation

This stored procedure simply runs a SELECT statement to return the ID, first name and last name of all the names added to the ‘Names’ table. Executing this stored procedure, which does not accept any argument, will display a list of all names in the ‘Names’ table.

iii. Stored Procedure for Updating a Given Name

This stored procedure will update the first and last names of a name in the ‘Names’ table using its ‘ID’. Copy following code and paste in it your SQL Server Query Analyzer window and then press the F5 key to execute/create this stored procedure:

CREATE PROC dbo.UpdateName
	@ID	int,
	@FirstName	varchar(50),
	@LastName	varchar(50)
AS
	UPDATE Names SET FirstName = @FirstName,
	LastName = @LastName WHERE [ID] = @ID

GO

Explanation

It takes three arguments to update the record using an UPDATE SQL statement. The code is straightforward.

iv. Stored Procedure for Removing a Name From ‘Names’ Table

This stored procedure will remove a given name using its ‘ID’ from the ‘Names’ table. Copy following code and paste in it your SQL Server Query Analyzer window and then press the F5 key to execute/create this stored procedure:

CREATE PROC dbo.RemoveName
	@ID	int
AS
	DELETE Names WHERE [ID] = @ID
GO

Explanation

Another very simple stored procedure. Here we use a single-line DELETE SQL statement to remove a record from the ‘Names’ table using the argument.

Assuming that you were successful in creating the ‘Names’ table and four stored procedures in your SQL Server database, we’ll move forward to create 4 ASP.NET pages similar to the 4 stored procedures.

Creating the ASP.NET front-end

Guys, let us now create the ASP.NET front-end.

i. Web.config

Since our ASP.NET will be connecting to the database, add the following connection string in your web.config file between the <connectionStrings></connectionStrings> tags:

<add name="NamesDB" connectionString="server=.;database=;user id=;password="
		  providerName="System.Data.SqlClient"/>

Add the correct server, database, username and password to be able to connect to your SQL Server database.

ii. Create.aspx

Create a new ASP.NET page and copy/paste following code in it:

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat="server">
public void AddName(object obj, EventArgs args)
{
	string connStr = ConfigurationManager.ConnectionStrings["NamesDB"]
		.ConnectionString;

	using (SqlConnection con = new SqlConnection(connStr))
	using (SqlCommand cmd = new SqlCommand("AddName", con))
	{
		cmd.CommandType = CommandType.StoredProcedure;
		cmd.Parameters.Add("FirstName", SqlDbType.VarChar, 50).Value =
			FirstName.Text;
		cmd.Parameters.Add("LastName", SqlDbType.VarChar, 50).Value =
			LastName.Text;
		cmd.Parameters.Add("ID", SqlDbType.Int);

		cmd.Parameters["ID"].Direction = ParameterDirection.Output;

		con.Open();
		cmd.ExecuteNonQuery();

		Result.Text = "New record created. (" +
			cmd.Parameters["ID"].Value + ")";
		}
	}
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Add a New Name</title>
    <style>
		body { font-family: Verdana; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
	<span style="font-size: larger">Add a New Name</span><br /><br />

	First Name: <asp:TextBox ID="FirstName" runat="server" /><br />
	Last Name: <asp:TextBox ID="LastName" runat="server" /><br /><br />
	<asp:Button ID="SubmitButton" Text="Add Name"
		OnClick="AddName" runat="server" />
	</div>

	<br />
	<asp:Label ID="Result" runat="server" />
    </form>
</body>
</html>

Explanation

This ASP.NET displays a form to the user. The user then enters the desired first and last names, and presses the submit button, the ASP.NET pages connects to the SQL Server and executes the ‘AddName’ stored procedure we create above to add a new record in the ‘Names’ table.

string connStr = ConfigurationManager.ConnectionStrings["NamesDB"]
	.ConnectionString;

We first retrieve the connection string in a local variable.

	using (SqlConnection con = new SqlConnection(connStr))
	using (SqlCommand cmd = new SqlCommand("AddName", con))
	{
		...
	}

Then we create connection and command objects for this connection. The command object contains the name of the stored procedure we want to execute.

	cmd.CommandType = CommandType.StoredProcedure;

We set the CommandType property of command object to be of type CommandType.StoredProcedure.

	cmd.Parameters.Add("FirstName", SqlDbType.VarChar, 50).Value =
		FirstName.Text;
	cmd.Parameters.Add("LastName", SqlDbType.VarChar, 50).Value =
		LastName.Text;
	cmd.Parameters.Add("ID", SqlDbType.Int);

	cmd.Parameters["ID"].Direction = ParameterDirection.Output;

Add three parameters to this stored procedure and setting the last parameter to receive the data set by the stored procedure, which in our case will be the ‘ID’ of the newly created record.

	con.Open();
	cmd.ExecuteNonQuery();

We then open the connection and execute the stored procedure.

	Result.Text = "New record created. (" +
		cmd.Parameters["ID"].Value + ")";

Finally, we display the retrieved id to the user. Pretty simple stuff.

iii. Retrieve.aspx

Create a new ASP.NET page and copy/paste following code in it:

<%@ Page Language="C#" %>

<script runat="server">
	public void Page_Load(object obj, EventArgs args)
	{
		GridView1.DataSource = SqlDataSource1;
		GridView1.DataBind();
	}
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Retrieve All Names</title>
    <style>
		body { font-family: Verdana; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
	<asp:SqlDataSource ID="SqlDataSource1" SelectCommand="GetAllNames"
	SelectCommandType="StoredProcedure" ProviderName="System.Data.SqlClient"
	ConnectionString="<%$ ConnectionStrings:NamesDB %>"
		runat="server"></asp:SqlDataSource>

	<asp:GridView ID="GridView1" runat="server">
	</asp:GridView>
	</div>
    </form>
</body>
</html>

Explanation

We use <asp:SqlDataSource> and <asp:GridView> server tags to display the result of executing the ‘GetAllNames’ stored procedure to the user.

iv. Update.aspx

Create a new ASP.NET page and copy/paste following code in it:

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat="server">
public void UpdateName(object obj, EventArgs args)
{
	string connStr = ConfigurationManager.ConnectionStrings["NamesDB"]
		.ConnectionString;

	using (SqlConnection con = new SqlConnection(connStr))
	using (SqlCommand cmd = new SqlCommand("UpdateName", con))
	{
		cmd.CommandType = CommandType.StoredProcedure;
		cmd.Parameters.Add("ID", SqlDbType.Int).Value = ID.Text;
		cmd.Parameters.Add("FirstName", SqlDbType.VarChar, 50).Value =
			FirstName.Text;
		cmd.Parameters.Add("LastName", SqlDbType.VarChar, 50).Value =
			LastName.Text;

		con.Open();
		cmd.ExecuteNonQuery();

		Result.Text = "Record updated";
	}
}
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Update a Name</title>
    <style>
		body { font-family: Verdana; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
	<span style="font-size: larger">Update an Existing Name</span><br /><br />

	ID: <asp:TextBox ID="ID" runat="server" /><br />
	First Name: <asp:TextBox ID="FirstName" runat="server" /><br />
	Last Name: <asp:TextBox ID="LastName" runat="server" /><br /><br />
	<asp:Button ID="SubmitButton" Text="Update Name"
		OnClick="UpdateName" runat="server" />
	</div>

	<br />
	<asp:Label ID="Result" runat="server" />
    </form>
</body>
</html>

Explanation

Presents a form, asking for a given record’s ‘ID’ whose first and last names you want to change. You supply all the arguments and click the submit button, this will execute the ‘UpdateName’ stored procedure and the first and last names corresponding to that ‘ID’ will be updated.

iv. Delete.aspx

Create a new ASP.NET page and copy/paste following code in it:

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat="server">
public void DeleteName(object obj, EventArgs args)
{
	string connStr = ConfigurationManager.ConnectionStrings["NamesDB"]
		.ConnectionString;

	using (SqlConnection con = new SqlConnection(connStr))
	using (SqlCommand cmd = new SqlCommand("RemoveName", con))
	{
		cmd.CommandType = CommandType.StoredProcedure;
		cmd.Parameters.Add("ID", SqlDbType.Int).Value = ID.Text;

		con.Open();
		cmd.ExecuteNonQuery();

		Result.Text = "Record deleted";
	}
}
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Delete a Name</title>
    <style>
		body { font-family: Verdana; }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
	<span style="font-size: larger">Delete an Existing Name</span><br /><br />

	ID: <asp:TextBox ID="ID" runat="server" /><br /><br />
	<asp:Button ID="SubmitButton" Text="Delete Name"
		OnClick="DeleteName" runat="server" />
	</div>

	<br />
	<asp:Label ID="Result" runat="server" />
    </form>
</body>
</html>

Explanation

Presents a form with a single input field. You enter the value of the ‘ID’ of the record you want deleted. Pressing the submit button executes the ‘RemoveName’ stored procedure which deletes the given record.

v. index.html

This page will allow you to link to all four ASP.NET pages from a single page. This way you can go to one ASP.NET page to add a new record, and come back to go to another ASP.NET page to view it. Create a new HTML page and copy/paste following code in it:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Index</title>
    <style>
    body { font-family: Verdana; }
    </style>
</head>
<body>

<div>Basic Stored Procedure Operations</div>

<ul>
<li><a href="create.aspx">Create</a></li>
<li><a href="retrieve.aspx">Retrieve</a></li>
<li><a href="update.aspx">Update</a></li>
<li><a href="delete.aspx">Delete</a></li>
</ul>

</body>
</html>

Conclusion

In this tutorial we learned about stored procedures. We learned how to create 4 basic types of stored procedures, and viewed their operations on a sample table. We also created 4 ASP.NET pages and learned how to assign parameters to stored procedures from ASP.NET pages, receive data (via OUT statement) from the stored procedure, and execute stored procedures from ASP.NET pages.

Guys, this is it. Go play with the code. Create the drop stored procedures as many times as you want. You can download all the code discussed in this tutorial from a link below. Have fun!

first: what is xml file ?

XML is tag based just like HTML. there is a example:
<?xml version=”1.0″?>
<boot>
<name>Faisal Khan</name>
<name></name>
<name/>
<name language=”US-EN”>Faisal Khan</name>
</boot>

second: we save the xml file named “aspreadxml.xml”, and we will reading this xml with asp. we can get the xml document elements and attributes.
the code like this:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

<?xml version="1.0"?>
<%
dim xml,objNode,objAtr,nCntChd,nCntAtr
Set xml=Server.CreateObject("Microsoft.XMLDOM")
xml.Async=False
xml.Load(Server.MapPath("aspreadxml.xml"))
Set objNode=xml.documentElement
nCntChd=objNode.ChildNodes.length-1
for i=0 to nCntChd
set objAtr=objNode.ChildNodes.item(i)
nCntAtr=objAtr.Attributes.length-1
for j=0 to nCntAtr
response.write objAtr.Attributes.item(j).Text&"<br>"
next
response.write "<br>"
next
Set objAtr=Nothing
Set objNode=Nothing
Set xml=Nothing
%>

Over 27,000 people every year die from chronic liver diseases and Cirrhosis. People with diabetes have a high number of deaths from liver deterioration. Over 60,000 people die from liver failure. It is estimated that 9,000 die from Chronic Hepatitis C and over 12,000 from liver cancer. Over 25 million people create some form of liver and gallbladder disease every year.

Liver disease is the Seventh killer of American people.

Don’t dismiss the health of your liver as you layout your plans to improve your health. Most people have some from of liver weakness and don’t even know it until it too late. Why not learn what you can do to treat your liver right so it can give you good LIFE.

Here is a list of symptoms that you will have when your liver is not working like it should.

* Frequent headache not related to stress, eyestrain, or shoulder muscle tension

* Frequent menstrual problems

* Blurry vision or red eyes

* Constant bitter taste in mouth

* Excessive anger, depression or moodiness

* Tenderness in the liver area – just under your right rib cage

* Acne, psoriasis, eczema, rashes, and other skin problems

* Weakness in your muscles and joint areas

Any one of these symptoms can be an indication that you have liver weakness. If you have two – three of them for sure you have some liver weakness.

So what can you do if you feel that you have some liver weakness?

The first area to work on is to examine the types of fats and oils you eat and make the changes that will give you better liver health.

Saturated fats, such as found in butter, meat, lard, and other oils are highly susceptible to oxygen damage through the process called oxidation. When these fats are oxidized they become rancid and form free radicals.

But Saturated fats are not the only fats that can be oxidized. Even unsaturated fats, the good oils, can be oxidized. Still it is better to eat most of our fats unsaturated since saturated fats are associated with heart conditions.

All fats can become oxidized outside the body by using them to fry your food or inside your body though the natural oxidation processes.

Liver cells are highly susceptible to free radicals. These free radicals are destructive to liver cell walls and weaken the health of the liver over time.

Also, Scientists have found that 17% of the oxygen you breathe and have available in your body becomes a free radical. These free radicals, again, attack and destroy liver cells.

To counter eating free radicals and the free radicals that are created in your body, you need to take anti-oxidant supplements and eat fruits and vegetables. The yellow and red colored fruits and vegetables are the highest in anti-oxidants. Of course it is best to also limit eating fried food and not use oils that have been sitting around to long.

Step 3.
Choose the linear gradient, cirlcled in green (a).

Open the gradient editor, by clicking on the sample gradient, and choose “foreground to background” (b)

Step 4.
To create the gradient, drag form the top to the bottom of the selection, which should produce something like in the iamge below.

Step 5.

This is the 2nd part of this Photoshop tutorial, to create a menu bar. Next create a thinner rounded rectangle, and make a selection using it (select > load selection)

Step 6.

Set the foreground color to a peach shade (ff7a4f) and the background color to f33a01. Create a linear gradient on the thinner rectangle (b)

a) b)

Step 7.

For the text i’ve used the settings shown below

Step 8.

And you should have something as shown below!

Alive!!! It’s alive!!…The page is ALIVE!!!!!

I don’t want to sound like a nag or like I’m harping on the same issue over and over, but ASP.NET is really about events and objects. The ASP.NET page is no exception. It is an object in the eyes of ASP.NET just like anything else. It has properties and methods and can be interacted with, similar to the other objects you’ve seen so far, and the plethora of things to come as you move through the remainder of this book.

Because events are a big part of ASP.NET and also a huge part of the power of the ASP.NET page object, it’s important to look closely at these event and the order in which they occur so that you can utilize them to their fullest potential.

Understanding Page Events

Maybe this isn’t the best way to explain this. Maybe my mother wouldn’t be so proud of my openness. Maybe these examples will be too graphic for you, but it’s the best way I can describe it, so please bear with me.

Every morning of every workday I start my day the same way. I get up, drag my carcass into the living room, and turn on the television. I stare at overpaid morning show hosts like a dribbling fool, with about as much cerebral activity as an earthworm trying to figure out what to eat. After the first flicker of lights goes off in my cranium, I drag my carcass to the shower to defrost my brain.

In the shower I have a set routine so as not to miss any vital, proper hygienic functions and to ensure that the other people in my office and our clients don’t give me those strange looks anymore when I enter the room. I think if you took the time to analyze this portion of your life, you’d see that without conscious thought, you pick up the bar of soap and proceed to cleanse without ever putting a thought into what you are doing. You may be singing or thinking about the day you are about to face and before you know it…Boom! You’re finished.

It’s a routine that I go through every morning almost without thought. And that’s a good thing; if I needed to be able to think before I could shower, I wouldn’t arrive at work until 10:00 a.m., or until I’ve had several cups of joe. This practice is part of a subconscious, programmed routine that has been burned into my mind from years of habit.

When I then go to work, I respond to the world around me. I make decisions based on what stimulus comes my way. Maybe someone comes to the office for a meeting. They ask questions and I answer them. The phone rings and I pick it up. I get e-mail and I occasionally read it and less often answer it. I am affected by the world around me and what kind of input it gives me. I then go home and enjoy the solace (this isn’t a joke and I’m not kidding) of my family.

At the end of the day I get into my pajamas and go to sleep.

ASP.NET pages are a lot like this. They go through a routine every time they are called. These routines are the ASP.NET pages’ events. They are like the steps I go through every morning to prepare for my day, or like showering by the same routine everyday.

ASP.NET pages have a routine of events that happen, and they happen in the same way, in the same order, every time. You’ve seen one of these events, Page_Load, in some of the previous examples. Let’s look into these events and the others that a page goes through when it is executed.

The three main events, although there are others, are as follows:

• Page_Init
• Page_Load
• Page_Unload

Page_Init

The Page_Init event is the first to occur when an ASP.NET page is executed. This is where you should perform any initialization steps that you need to set up or create instances of server controls. Server controls are discussed in later chapters, so just keep this event in mind.

You don’t want to try to access controls in this event because there is no guarantee that they have been created yet. It is during this event that they are created, and you can control whether your attempt to use these objects will be thwarted by the server processing your request before the object has been created.

The following is an example of the structure of how to use the Page_Init event

Visual Basic .NET

Sub Page_Init()
   'Place your Page_Init code here
End Sub

C#

void Page_Init(){
  //Place your Page_Init code here
}

Note that the Page_Init event fires only the first time the page is loaded. When you use a web form and post back to this page again, the Page_Init event doesn’t fire. But the Page_Load event fires each time the page loads.

Page_Load

This is the page event where you will be doing most of your work. This event occurs only when all the objects on the page have been created and are available for use. You will see—within this book and in other examples available in the .NET Framework SDK and ASP.NET-related web sites—that the lion’s share of work on ASP.NET pages is done during this event. We’ve been using this event since the beginning of the book and will continue to use it in just about every example.

Although you’ve seen it a zillion times already in the book, for consistency’s sake I’ll show you the form here. It doesn’t look a whole lot different from the Page_Init example, and for all intents and purposes the only thing that’s different is that the word Init is substituted with the word Load.

Visual Basic .NET

Sub Page_Load()
   'Place your Page_Load code here
End Sub

C#

void Page_Load(){
  //Place your Page_Load code here
}

Page_Unload

Page_Unload is the counterpart to Page_Init. Just as Page_Init is an event that happens before anything else happens, Page_Unload happens after everything else happens. It is available for you to perform any operation you need to after you are completely finished with the page.

For instance, imagine that you temporarily needed to create a file on the server during the page’s processing. You wouldn’t want to leave it there for eternity, especially if the file was unique to each visitor of the web site. You could have loads and loads of files building on your server without any way to get rid of them. But if you were a good boy or girl, you could destroy the file during the page’s Page_Unload event and make the server administrator a happy camper.

Just to be fair and impartial, I don’t want to leave out showing you the structure of the Page_Unload event. Look familiar?

Visual Basic .NET

Sub Page_Unload()
   'Place your Page_Unload code here
End Sub

C#

void Page_Unload(){
  //Place your Page_Unload code here
}

Getting back to my morning routine, it looks like this:

1. Peter_Init. Roll carcass from bed to in front of the television.
2. Peter_Load. Take shower brainlessly, get dressed (make sure socks match and colors coordinate—check with wife for confirmation). Get into car and drive to the office.
3. Handle the day in all its glory and all the blessings that come with it.
4. Peter_Unload. Get into jammies and go to sleep.

It’s that routine, and I behave just like the Page object does. When I run through these events, I am investigating and affecting all kinds of things. I’m finding out the condition of the world that morning by listening to news, changing the state of my brain to somewhat functional, changing the direction that my hair points from an erratic bird’s nest to some semblance of a hairdo, and more.

I’m doing this through checking and setting properties and executing methods, so to speak. During Peter_Init, I execute the RollCarcass() method to change the Peter.Sleeping property from true to false.

During Peter_Load I’m checking the value of the eye.bags property and seeing what the value of the hair.color property is, which is generally grayer than the day before. I’m assuring that the body.odor property is set to zero by executing the Shower() method.

I then have the ability to respond to events and stimulus from the world around me throughout the day. Then during the Peter_Unload event, I execute the CollapseFromExaustion() method to set the Peter.Sleeping property to true.

Can you see how these different events at different times have a direct affect on my condition? ASP.NET pages can be affected just like this with their different events. Now are you beginning to see more clearly how events and objects interact in ASP.NET and how this is a totally different paradigm from any traditional way of web programming in HTML or Active Server Pages.

As I said in the beginning of the chapter, ASP.NET is all about events and objects, and the ASP.NET page is no exception. You know that objects are made up of their properties and methods, and now you know that objects can also have events, as well.

The page object has the three mentioned events, as well as others that execute without intervention from the designer, but other events also affect ASP.NET pages.

User-Initiated Events

Just as I am faced with input from the world around me after the Peter_Onload event has finished, a page can also deal with events initiated by the web page’s visitor.

Let’s look at an example of some events, both self executing and user initiated. Below is a page that shows the date and asks you to pick what mood you’re in. In the code samples, you’ll also be shown another neat server control called a RadioButtonList and a cool feature of the .NET Framework called Databinding. You will also see a property of the Page object called IsPostBack. We will discuss this later in this chapter, but again, don’t get hung up on these things— just concentrate on the events in the page.

Home > Articles > Web Design & Development >

Exploring ASP.NET Pages

• By Peter Ladka
• Dec 6, 2002
• Sample Chapter is provided courtesy of New Riders

Article Contents

Article Contents

1. Understanding Page Events
2. Understanding Page Properties
3. Understanding Directives
4. Code Separation and Using Code-Behind
5. Summary

Page 1 of 5 Next >

• Print
• Share This
• Discuss

Peter Ladka

Learn more…

• Articles
• Store
• Blogs

Exploring ASP.NET Pages

Dec 6, 2002

ASP.NET for Web Designers

Aug 23, 2002

Sorry, this author hasn’t posted any blogs.

This chapter is from the book
ASP.NET for Web Designers

Explore ASP.NET pages and dig into some of their core functions, such as page events and properties, and directives.

Alive!!! It’s alive!!…The page is ALIVE!!!!!

I don’t want to sound like a nag or like I’m harping on the same issue over and over, but ASP.NET is really about events and objects. The ASP.NET page is no exception. It is an object in the eyes of ASP.NET just like anything else. It has properties and methods and can be interacted with, similar to the other objects you’ve seen so far, and the plethora of things to come as you move through the remainder of this book.

Because events are a big part of ASP.NET and also a huge part of the power of the ASP.NET page object, it’s important to look closely at these event and the order in which they occur so that you can utilize them to their fullest potential.

Understanding Page Events

Maybe this isn’t the best way to explain this. Maybe my mother wouldn’t be so proud of my openness. Maybe these examples will be too graphic for you, but it’s the best way I can describe it, so please bear with me.

Every morning of every workday I start my day the same way. I get up, drag my carcass into the living room, and turn on the television. I stare at overpaid morning show hosts like a dribbling fool, with about as much cerebral activity as an earthworm trying to figure out what to eat. After the first flicker of lights goes off in my cranium, I drag my carcass to the shower to defrost my brain.

In the shower I have a set routine so as not to miss any vital, proper hygienic functions and to ensure that the other people in my office and our clients don’t give me those strange looks anymore when I enter the room. I think if you took the time to analyze this portion of your life, you’d see that without conscious thought, you pick up the bar of soap and proceed to cleanse without ever putting a thought into what you are doing. You may be singing or thinking about the day you are about to face and before you know it…Boom! You’re finished.

It’s a routine that I go through every morning almost without thought. And that’s a good thing; if I needed to be able to think before I could shower, I wouldn’t arrive at work until 10:00 a.m., or until I’ve had several cups of joe. This practice is part of a subconscious, programmed routine that has been burned into my mind from years of habit.

When I then go to work, I respond to the world around me. I make decisions based on what stimulus comes my way. Maybe someone comes to the office for a meeting. They ask questions and I answer them. The phone rings and I pick it up. I get e-mail and I occasionally read it and less often answer it. I am affected by the world around me and what kind of input it gives me. I then go home and enjoy the solace (this isn’t a joke and I’m not kidding) of my family.

At the end of the day I get into my pajamas and go to sleep.

ASP.NET pages are a lot like this. They go through a routine every time they are called. These routines are the ASP.NET pages’ events. They are like the steps I go through every morning to prepare for my day, or like showering by the same routine everyday.

ASP.NET pages have a routine of events that happen, and they happen in the same way, in the same order, every time. You’ve seen one of these events, Page_Load, in some of the previous examples. Let’s look into these events and the others that a page goes through when it is executed.

The three main events, although there are others, are as follows:

• Page_Init
• Page_Load
• Page_Unload

Page_Init

The Page_Init event is the first to occur when an ASP.NET page is executed. This is where you should perform any initialization steps that you need to set up or create instances of server controls. Server controls are discussed in later chapters, so just keep this event in mind.

You don’t want to try to access controls in this event because there is no guarantee that they have been created yet. It is during this event that they are created, and you can control whether your attempt to use these objects will be thwarted by the server processing your request before the object has been created.

The following is an example of the structure of how to use the Page_Init event

Visual Basic .NET

Sub Page_Init()
   'Place your Page_Init code here
End Sub

C#

void Page_Init(){
  //Place your Page_Init code here
}

Note that the Page_Init event fires only the first time the page is loaded. When you use a web form and post back to this page again, the Page_Init event doesn’t fire. But the Page_Load event fires each time the page loads.

Page_Load

This is the page event where you will be doing most of your work. This event occurs only when all the objects on the page have been created and are available for use. You will see—within this book and in other examples available in the .NET Framework SDK and ASP.NET-related web sites—that the lion’s share of work on ASP.NET pages is done during this event. We’ve been using this event since the beginning of the book and will continue to use it in just about every example.

Although you’ve seen it a zillion times already in the book, for consistency’s sake I’ll show you the form here. It doesn’t look a whole lot different from the Page_Init example, and for all intents and purposes the only thing that’s different is that the word Init is substituted with the word Load.

Visual Basic .NET

Sub Page_Load()
   'Place your Page_Load code here
End Sub

C#

void Page_Load(){
  //Place your Page_Load code here
}

Page_Unload

Page_Unload is the counterpart to Page_Init. Just as Page_Init is an event that happens before anything else happens, Page_Unload happens after everything else happens. It is available for you to perform any operation you need to after you are completely finished with the page.

For instance, imagine that you temporarily needed to create a file on the server during the page’s processing. You wouldn’t want to leave it there for eternity, especially if the file was unique to each visitor of the web site. You could have loads and loads of files building on your server without any way to get rid of them. But if you were a good boy or girl, you could destroy the file during the page’s Page_Unload event and make the server administrator a happy camper.

Just to be fair and impartial, I don’t want to leave out showing you the structure of the Page_Unload event. Look familiar?

Visual Basic .NET

Sub Page_Unload()
   'Place your Page_Unload code here
End Sub

C#

void Page_Unload(){
  //Place your Page_Unload code here
}

Getting back to my morning routine, it looks like this:

1. Peter_Init. Roll carcass from bed to in front of the television.
2. Peter_Load. Take shower brainlessly, get dressed (make sure socks match and colors coordinate—check with wife for confirmation). Get into car and drive to the office.
3. Handle the day in all its glory and all the blessings that come with it.
4. Peter_Unload. Get into jammies and go to sleep.

It’s that routine, and I behave just like the Page object does. When I run through these events, I am investigating and affecting all kinds of things. I’m finding out the condition of the world that morning by listening to news, changing the state of my brain to somewhat functional, changing the direction that my hair points from an erratic bird’s nest to some semblance of a hairdo, and more.

I’m doing this through checking and setting properties and executing methods, so to speak. During Peter_Init, I execute the RollCarcass() method to change the Peter.Sleeping property from true to false.

During Peter_Load I’m checking the value of the eye.bags property and seeing what the value of the hair.color property is, which is generally grayer than the day before. I’m assuring that the body.odor property is set to zero by executing the Shower() method.

I then have the ability to respond to events and stimulus from the world around me throughout the day. Then during the Peter_Unload event, I execute the CollapseFromExaustion() method to set the Peter.Sleeping property to true.

Can you see how these different events at different times have a direct affect on my condition? ASP.NET pages can be affected just like this with their different events. Now are you beginning to see more clearly how events and objects interact in ASP.NET and how this is a totally different paradigm from any traditional way of web programming in HTML or Active Server Pages.

As I said in the beginning of the chapter, ASP.NET is all about events and objects, and the ASP.NET page is no exception. You know that objects are made up of their properties and methods, and now you know that objects can also have events, as well.

The page object has the three mentioned events, as well as others that execute without intervention from the designer, but other events also affect ASP.NET pages.

User-Initiated Events

Just as I am faced with input from the world around me after the Peter_Onload event has finished, a page can also deal with events initiated by the web page’s visitor.

Let’s look at an example of some events, both self executing and user initiated. Below is a page that shows the date and asks you to pick what mood you’re in. In the code samples, you’ll also be shown another neat server control called a RadioButtonList and a cool feature of the .NET Framework called Databinding. You will also see a property of the Page object called IsPostBack. We will discuss this later in this chapter, but again, don’t get hung up on these things— just concentrate on the events in the page.

Visual C#

^?View Code CSHARP

<!--page language="c#" runat="server--> <script type="text/javascript"><!--mce:2--></script> <form enctype="application/x-www-form-urlencoded" method="get"> </form>

Figure 4.1 The Page_Load event has built the page, but the onClick event hasn’t had any effect because the button hasn’t been pressed yet.

ASP.NET knows whether you pressed this button—not by a typical client-side onClick event, but by inspecting the form that is posted and seeing whether this button was pressed. The terminology is similar to client-side JavaScript, but the function and method is totally different.

Now it’s time to pick a mood and click the button. You can see in Figure 4.2 that the mood is now displayed because the onClick event that took place server-side executed the function called CheckMood, which sets the text of the label.

Figure 4.2 The onClick event is fired by clicking the button.

To reinforce the point that ASP.NET is smart about calling functions and that what is executed is determined by the onClick event of the button, I have put together a sample with two different buttons that call two different functions. Each button uses its own onClick event.
Visual Basic .NET

C#

If you look at Figure 4.3 you can see that after the Count Down button was clicked, with the value of 10 in the text box, the CountDown function was executed and the code generated and displayed properly.

Figure 4.3 Clicking the Count Down button causes the CountDown function to execute.

Now if you put a string such as “What is the length?” in the text box and click the Get Length button, you are executing the StringLength function.

NOTE

This example has a bit of hidden danger in that if someone enters a string in the text box and clicks the Count Down button, ASP.NET will cause an error. This is because it can’t convert a String type to an Integer in this circumstance. But you don’t need to worry about this in your real-world applications because ASP.NET provides some really, REALLY cool answers to validating input data (that we will be devoting an entire chapter to later). The validators would totally solve any issues like this—and more.

Figure 4.4 Clicking the Get Length button causes the StringLength function to execute.

As if all the objects and events covered earlier weren’t enough, the concept of user-initiated events opens up a totally new way of thinking again about how you can handle and manipulate data, depending on how a user interacts with your web application.

Other events are also available that can help you manipulate data and objects, and I would encourage you again to go to the class browser located at the following link and look at what events you can use on each object:

http://samples.gotdotnet.com/quickstart/aspplus/

Now that we’ve touched on the different events, both default and user-initiated, let’s move on to looking at some of the key properties of the Page object.
Page 1 of 5 Next >

* Share ThisShare This
* Your Account

Discussions
Make a New Comment

You must log in in order to post a comment.
Related Resources

* Podcasts
* Blogs
* Articles
* Store

Author Talk (Audio & Video)Author Talk (Audio & Video)

Recent Episodes

* Jeff Revell Interview
Jeff Revell
* Russ Unger and Carolyn Chandler Interview on UX Design
Carolyn Chandler, Russ Unger

Subscribe
Dreamweaver with RC Concepcion (Video)Dreamweaver with RC Concepcion (Video)

Recent Episodes

* Using Behaviors in Dreamweaver CS4
Rafael Concepcion
* Setting up a Contact Form
Rafael Concepcion

Subscribe

See More Podcasts

Adobe Flash Catalyst: Under the Hood – Part 3 Design Integration Workflows
By Victor Gavenda on June 26, 2009 No Comments

In Part 3 of this continuing series, guest authors James Polanco and Aaron Pedersen show how Flash Catalyst eases the designer’s task of creating user elements for a Flex project.

Adobe Flash Catalyst: Under the Hood – Part 2 The Platform
By Victor Gavenda on June 12, 2009 No Comments

In Part 2 of this continuing series, James Polanco and Aaron Pedersen provide a 30,000-foot overview of the new Flash Platform.

Nancy Aldrich-RuenzelGone is the designer/developer divide
By Nancy Aldrich-Ruenzel on June 18, 2009 1 Comment

In a recent conversation with the authors of A Project Guide to UX Design—Russ Unger and Carolyn Chandler—we chatted at some length about the various roles on a Web team, both best case and worst case. (Here’s the full interview.)

See All Related Blogs

Developing ASP.NET Applications with Macromedia’s Dreamweaver MX 2004
By Matthew David

Some Google in Your Apps: An Introduction to the Google Web API Using .NET and Java
By Tim Stevens

PHP and .NET
By Andrew Stopford

See All Related Articles

Modular Web Design: Creating Reusable Components for User Experience Design and DocumentationModular Web Design: Creating Reusable Components for User Experience Design and Documentation
By Nathan Curtis
Price$40.49

Mastering Web Content: Behavior with Ajax, DVDMastering Web Content: Behavior with Ajax, DVD
By Greg Rewis
Price$35.99

When Search Meets Web UsabilityWhen Search Meets Web Usability
By Shari Thurow, Nick Musica
Price$26.99

See All Related Store Items
Peachpit

* Topics
o Adobe Photoshop
o Apple
o Design
o Digital Photography
o Digital Video
o Gadgets
o Productivity
o Web Design & Development
* Store
* Authors
* Safari Books Online
o How it Works
o Browse the Library
o Free Trial
o Subscriber Login
* Explore
o About
o Academic Resources
o Affiliates
o Articles
o Peachpit Commons Blog
o Podcasts
o Press
o Reference Guides
o User Groups

Account Sign In
View your cart
Search

first:
convert images to byte arrays

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

        /// <summary>
        /// convert image to byte[]
        /// </summary>
        /// <param name="filePath"></param>
        /// <returns></returns>
        public byte[] PhotoToBytes(string filePath) {
            FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
            BinaryReader br = new BinaryReader(fs);
            try {
                byte[] photo = br.ReadBytes((int)fs.Length);
                br.Close();
                fs.Close();
                return photo;
            }
            catch {
                return null;
            }
        }

next: convert byte[] back into images

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

        /// <summary>
        /// byte[] back into Image
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public Image BytesToPhoto(byte[] Bytes) {
 
            MemoryStream stream = null;
 
            Image img = null;
 
            try {
                stream = new MemoryStream(Bytes);
 
                img = Image.FromStream(stream, true);
 
                return img;
 
            }
            catch {
 
                return null;
 
            }
            finally {
                stream.Close();
 
                img.Dispose();
 
            }
        }

1

<script type="text/javascript" src="js/jquery-1.3.2.min.js" ></script>

once we done this,and we can begin to work using AJAX in Jquery.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

$.ajax({
  type: "get",//define the type of request for example: POST/GET.
  dataType:"html",//format the data being received is in. (HTML, XML, JSON, script etc..)
  url: "getInfo.aspx?id="+id, //the URL to make the request to
  cache:false,
  beforeSend: function(XMLHttpRequest){
	//
  },
  success: function(data,textStatus){
	alert(data);
  },
  complete: function(XMLHttpRequest, textStatus){
	//
  },
  error: function(){
	//
  }
});

getInfo.aspx.cs

1

Response.Write("OK");

1
2

<asp:TreeView ID="TV_Department" runat="server"  OnSelectedNodeChanged="TV_Department_SelectedNodeChanged"  ExpandDepth="6"   width="240px" BorderWidth="0px" BorderColor="White" BackColor="White" LineImagesFolder="~/TreeLineImages" NodeWrap="True" ImageSet="Msdn" NodeIndent="10">
</asp:TreeView>

cs:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54

protected void Page_Load(object sender, EventArgs e)
{
 
        if (!IsPostBack)
        {
            BindTree(isTheme.DeptID); 
 
        }
}
 
/// <summary>
///  
/// </summary>
void BindTree(int DeptID)
{
        DataTable dt = getlist.GetList(" * ", "").Tables[0];// we can get the datatable from MSSQL XML and so on.
        DataView dv = new DataView(dt);
        dv.RowFilter = "DeptID =" + DeptID;
        TV_Department.Nodes.Clear();
        if (dt.Rows.Count > 0)
        {
            foreach (DataRowView drv in dv)
            {
                TreeNode node = new TreeNode();
                node.Text = drv["DeptShortName"].ToString();
                node.Value = drv["DeptID"].ToString();
                node.Expanded = true;
                node.SelectAction = TreeNodeSelectAction.Select;
                TV_Department.Nodes.Add(node);
                AddReplies(dt, node);
            }
            TV_Department.SelectedNodeStyle.BackColor = System.Drawing.Color.FromArgb(242, 255, 253);
        }
 
}
/// <summary>
/// get the children 
/// <param name="dt"></param>
/// <param name="node"></param>
private void AddReplies(DataTable dt, TreeNode node)
{
        DataView dv = new DataView(dt);
        dv.RowFilter = "PID='" + node.Value + "'";
        foreach (DataRowView row in dv)
        {
            TreeNode replyNode = new TreeNode();
            replyNode.Text = row["DeptShortName"].ToString();
            replyNode.Value = row["DeptID"].ToString();
            replyNode.Expanded = true;
            replyNode.SelectAction = TreeNodeSelectAction.Select;
            node.ChildNodes.Add(replyNode);
            AddReplies(dt, replyNode);
        }
 }

In the asp.net world,we frequently uploading files via a web page, in this example,we will upload a file without refresh.

index.html:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>无标题页</title>
    <script type="text/javascript" src="../js/jquery-1.3.2.min.js"  charset="GB2312"></script>
    <script type="text/javascript">
    $(function() {
	$("#btnUploadFile").click(function(){
 
	    $.ajax({
        type: "post",
        dataType:"html",
        url: "upload.aspx",
        timeout: 20000,
        data: "userfile="+escape($("#userfile").val()),
        cache:false,
        beforeSend: function(XMLHttpRequest){
            //ShowLoading();
        },
        success: function(data,textStatus){
            $("#dialog").html(data);
            alert("succeed");
        },
        complete: function(XMLHttpRequest, textStatus){
            //HideLoading();
        },
        error: function(){
            //HappenError();
        }
    });
	});
});
</script>
</head>
<body>
<form id="form1" method="post" enctype="multipart/form-data">
<div>
    <input id="userfile" type="file" /><input id="btnUploadFile" type="button" value="upload" /></div><div id="dialog"></div>
</form>
</body>
</html>

upload.aspx

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Net" %>
<script runat="server">
    protected void Page_Load(object sender, EventArgs e) {
        string requestpath = Request.Form["userfile"].ToString();
        string _path = "../Users/";//
        string extName = "";//
        string fileNamePath = ""; //
        string NewFilePath = "";//
        FileInfo userPostedFile = new FileInfo(Server.UrlDecode(requestpath));
        if (userPostedFile.Length > 0) {
            extName = userPostedFile.Extension;
            if (_path.EndsWith("/") == false)
                _path = _path + "/";
            fileNamePath = HttpContext.Current.Server.MapPath(_path);
            NewFilePath = fileNamePath + DateTime.Now.ToString("yyyyMMddHHmmss") + extName;
            WebClient myWebClient = new WebClient();
            myWebClient.Credentials = CredentialCache.DefaultCredentials;
            FileStream fs = new FileStream(Server.UrlDecode(Context.Request.Form["userfile"]), FileMode.Open, FileAccess.Read);
            BinaryReader r = new BinaryReader(fs);
            byte[] postArray = r.ReadBytes((int)fs.Length);
            Stream postStream = myWebClient.OpenWrite(NewFilePath, "PUT");
            if (postStream.CanWrite) {
                postStream.Write(postArray, 0, postArray.Length);
                Response.Write("ok!");
            }
            else {
                Response.Write("error!");
            }
            postStream.Close();
            postStream.Dispose();
        }
    }
</script>

this is the author web

To grab the value* or text** of a option in the select box, you must know it’s index. Most of the time you’ll only need use of the user selected option, so we can use the select object’s selectedIndex property to get the index we want, then use that to get the value of the option we want. This code example will grab the selected value of the myselect select box:

1

myselect.options[myselect.selectedIndex].value

This is an select box:

1
2
3
4
5

<select onchange="window.location=this.options[this.selectedIndex].value">
    <option value="#">Select a search engine</option>
    <option value="http://www.google.com">Google</option>
    <option value="http://www.yahoo.com">Yahoo</option>
</select>

second,we can load this XML documents by using the System.Xml.XmlDocument class.

.CS

1
2
3
4
5
6
7
8
9
10
11
12
13
14

XmlDocument doc = new XmlDocument();
// 1:Load the XML data from a file
doc.Load("e.xml");
// 2:Load the XML data from a file stream
FileStream fs = new FileStream("e.xml", FileMode.Open);
doc.Load(fs);
fs.Close();
// 3:Read the XML by using XmlTextReader
XmlTextReader rdr = new XmlTextReader("e.xml");
rdr.MoveToContent(); // Move to the content nodes.
rdr.Read(); // Start reading.
rdr.Skip(); // Skip the root.
rdr.Skip(); // Skip the first content node.
doc.Load(rdr); // Read the second node data into DOM.

if you want to save axml documents,you can do it like this:

1

doc.Save("a_File.xml");

Scarlett says she is ‘honoured’ to front the campaign

Scarlett says she is ‘honoured’ to front the campaign

The head of the champagne house says Scarlett was the ‘obvious choice’ to be the company’s celebrity ambassador

The actress holds a champagne glass between her toes in one image

Scarlett Johansson stars in a new campaign for Moët & Chandon

Scarlett Johansson proved she is indeed a bubbly blonde in a new campaign for Moët & Chandon.

The Hollywood actress looks her bombshell best in a series of smouldering images for the champagne house, who named her their first ever celebrity ambassador last month.

In one provocative image she pops the cork off a bottle of the French tipple, while in another she shows off her fancy footwork as she holds a champagne glass between her toes.

wo can using this code:

1
2
3
4
5
6
7
8
9
10

StringBuilder sb = new StringBuilder();
foreach (RepeaterItem item in Rep.Controls) {
if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) 
{
     Literal questionid = (Literal)item.FindControl("questionid");
     HtmlTextArea hta = (HtmlTextArea)item.FindControl("txtJisuan");
     sb.Append(Server.HtmlEncode(hta.Value));
     sb.Append("$$");
}
}

if you want to find some control inside  HeaderTemplate of Repeater,you kan do this:

1
2
3
4
5
6
7
8

foreach (RepeaterItem item in Rep.Controls) 
{
if (item.ItemType == ListItemType.Header) 
{
Label lbSelTotal = (Label)item.FindControl("lbSelTotal");
break;
}
}

you need pay attention to the red words.

Here are the Tools.
90 day trial version of Visual Studio 2008

If you decide to use Visual Web Developer Express then you must have Service Pack 1 installed. You can download Visual Web Developer 2008 Express with Service Pack 1
Visual Web Developer 2008 Express with Service Pack 1

Next  I will introduce “How to Creating an ASP.NET MVC Web Application Project”.

click this link: Start download.

Declaring a delegate:
public delegate int PerformCalculation(int x, int y);
or
public delegate void TestDelegate(string message);

Demo:
using System;
public delegate void TestDelegate(string message); //Declare the delegate
class Test
{
  public static void Display(string message)
  {
    Console.WriteLine("The string entered is : " + message);
  }
  static void Main()
  {
    TestDelegate t = new TestDelegate(Display); //Instantiate the delegate
    Console.WriteLine("Please enter a string");
    string message = Console.ReadLine();
    t(message); //Invoke the delegate
    Console.ReadLine();
  }
}

The Microsoft Enterprise Library is a collection of reusable software components (application blocks) designed to assist software developers with common enterprise development challenges. Application blocks are a type of guidance; they are provided as source code plus documentation that can be used “as is,” extended, or modified by developers to use on complex, enterprise-level line-of-business development projects.

http://entlib.codeplex.com/

Want to look younger or less tired? Focus on the area around your eyes, a new study suggests, because that’s where people get visual clues about your age and level of fatigue.

When asked to estimate the age of people in photographs, participants in a study looked at the eye region almost half the time, researchers found. The number was about the same when the participants tried to figure out how tired people in the photographs were.

The findings might seem obvious, but the study’s lead author, a plastic surgeon, said they’re important because cosmetic-surgery patients don’t always get treatment where they need it.

Wrong treatment
“They want to look younger and less tired, but if you look to see what they’re being offered, it’s often not things around the eyes,” said Dr Peter A. D. Rubin, a US plastic surgeon and an associate professor of ophthalmology at the University of Tennessee Health Science Centre.

Rubin and his colleagues launched the study to figure out how people gauge age and fatigue. “What better way than to see where people are actually looking when they’re making these judgments?” he said.

The researchers recruited 47 college students – 15 men, 32 women – and told them to look at photographs of 48 older people on a computer monitor. The monitor analysed reflections from the eye to determine where the study participants were looking. The participants then rated either the age or the fatigue level of the people in the photos.

When gauging the age of people, the students looked at the eye region 46% of the time, followed by the nose (19%), forehead (13%) and the area between the eyebrows (11%).

The numbers were similar when the students were trying to figure out how tired the people in the photos appeared.

The study findings were published in the journal Ophthalmology.

Why eyes reveal so much?
The eye region makes up just 21% of the face, according to the study authors. So why does it seem to reveal so much?

“There is a lot going on around the eyes,” Rubin said. For one thing, eyelids are the thinnest skin on the body, making swelling more prominent. Also, he said, the eye region undergoes many changes during ageing and suffers from significant sun damage.

“Beauty is not only in the eye of the beholder,” Rubin said. “It’s also in the eye of the beholdee.”

Timothy J. Slattery, a postdoctoral fellow in psychology at the University of California, US, said the study findings reflect those of other research that has found that people fixate on the eyes when they look at photos of faces. – (Randy Dotinga/HealthDay News, February 2009)

.CS:
customers.DataSource=OleDBDataDataTable(“SELECT * FROM customers”)
customers.DataBind()

.aspx:

<form runat=”server”>
<asp:Repeater id=”customers” runat=”server”>

<HeaderTemplate>
<table border=”1″ width=”100%”>
<tr bgcolor=”#b0c4de”>
<th>Companyname</th>
<th>Contactname</th>
<th>Address</th>
<th>City</th>
</tr>
</HeaderTemplate>

<ItemTemplate>
<tr bgcolor=”#f0f0f0″>
<td><%#Container.DataItem(“companyname”)%> </td>
<td><%#Container.DataItem(“contactname”)%> </td>
<td><%#Container.DataItem(“address”)%> </td>
<td><%#Container.DataItem(“city”)%> </td>
</tr>
</ItemTemplate>

<FooterTemplate>
</table>
</FooterTemplate>

</asp:Repeater>
</form>

</body>
</html>

we can ussing Jquery select CheckBox Multiple Rows Column.
here is the code:

<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script><script type="text/javascript">
<!--
    $(function(){
      $("#chk").click(function(){
                if($(this).attr(“checked”)==true){
                    $(“input[name='chk_list']“).each(function(){
                        $(this).attr(“checked”,true);
                    });
                }
                else{
                   $(“input[name='chk_list']“).each(function(){
                        $(this).attr(“checked”,false);
                    });
                }
            });
        });
     });
// –></script>


<asp:TemplateColumn>
          <HeaderTemplate>
                    <input type=checkbox id="chk" />check all
                </HeaderTemplate>
       <HeaderStyle Width="10%" CssClass="zi1B" BackColor="#EFEFEF" Height="22"></HeaderStyle>
       <ItemTemplate>
        <asp:CheckBox  id="chk_list" name="chk_list" Runat="server"  value='<%# DataBinder.Eval(Container.DataItem, "SchemeID") %>'></asp:CheckBox>
       </ItemTemplate>
       <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateColumn>

here:http://devexpress.com/Products/Free/WebRegistration60/

For adults, romances are variable, and friendship is the constant.

Privileged Youth reverses the equation: Love affairs are constant, and it’s the friendships that vary. And matter most.

That is the essence of Gossip Girl, the semi-satirical portrait of power and privilege in the private schools and penthouses of New York’s ultra rich, the New York Times says in a think piece.

It’s often said that Hollywood is “high school with money.” On this glossy, glamour-soaked CW series, high school is better than Hollywood.

Gossip Girl, which had its Season 1 finale this past Monday, explores the un-navigability of friendships. Female bonding is punctuated by the joy and disappointments of dating, but the ruling passion is power.

The pride that comes with connecting with one’s ilk and asserting control, as well as the scorching pain of rejection and ridicule.

Sex is easy; it’s the cliques that take time and solicitude.

“You can tell us anything,” Blair Waldorf coos to a distraught Serena van der Woodsen, hung over and harboring a shameful secret.

“We’ve seen you with vomit in your hair, making out with investment bankers in the men’s room at P. J. Clarke’s.”

In a culture obsessed with youth, money and appearance, 16 is the new 30, and teenage girls’ discontent about boys and clothes and one another has resonance even for older audiences.

Parents fret that youngsters grow up too fast; children complain that grown-ups refuse to grow old.

Gossip Girl goes further than most shows in depicting the excesses of the rich and underage (in this fantasy teenagers are never carded), but most of all it represents the next evolutionary stage of girl power TV after Sex and the City.

That pioneering HBO series, and the movie version that comes out later this month, celebrates girlish women who joined forces — “Us against the world” — in the pursuit of success and happiness.

Gossip Girl focuses on worldly little girls who join forces against one another. The series, along with such like-minded shows as the MTV semi-reality show The Hills and a cautionary senior edition, The Real Housewives of New York City are focused on friends, and most of all on frenemies.

They are so post-femininist that they circle back not just to Mean Girls, but to the pre-Friedan era of Clare Boothe Luce and Rona Jaffe.

It’s not actually a step backward of course; it’s more of a mischievous sidestep, a zig after many years of networks’ zagging to catch up with Sex and the City.

That series’ selling point was not just sex and clothes. It offered the charisma of four stylish, sexy women taking on Manhattan like D’Artagnan and the Three Musketeers.

None of the imitations, including Cashmere Mafia, a flop on ABC, and NBC’s slightly more successful version, Lipstick Jungle adequately captured the tone of the original.

Producers of the next Bond movie are coming to Israel to search for a dark-skinned beauty

Amir Kaminer, Yoav Birenberg

The producers of the next Bond film are now looking for the next Bond girl to star in the 22nd film in the series. This time around, their search has also brought them to Israel.

The lucky girl will star alongside Daniel Craig, the current 007.

Unfortunately, the character of the new girl in the script will not be Israeli but Spanish, yet according to the producers a dark-skinned Israeli girl could also fit the role.

The hunt for the right girl is spanning the entire Mediterranean basin, and producers of the series are now asking Israeli casting agents to send photographs and resumes of Israeli beauties with good acting skills. Another requirement is perfect command of the English language.

The veteran casting director Bruria Elback will be in charge of Israeli casting, which is set to commence shortly. “Auditions for the James Bond movie are being held in many countries and to my delight, we too are now part of it,” Elbeck said.

According to Elback the “candidates for the part have to be of international standard, stunning and dark- skinned. They are definitely not looking for blonds here, but for a Latin look.”

The film which still lacks a final name will primarily be shot on location in Italy, and will be directed by Mark Forrester. Paul Haggis who wrote the script for “Casino Royale”, which enjoyed the highest box office sales, is also among the film makers.

The producers of the 22nd Bond film will soon be arriving in Israel. Since Ursula Andress emerged from the water in a white bikini and a hunting knife in “Dr. No” (1964), the first film in the series, the Bond girls have a place of honor in the Bond ritual. Another well-known Bond girl is Halle Berry.

Israeli actresses Ayelet Zorer, Sarai Givati and other Israeli stars should get prepared.

Twilight

 Stephenie Meyer’s vampires are not your parents’ vampires. They walk around in daylight. They sparkle like diamonds in the sunlight. And they love baseball. Meyer’s young love vampire series of novels became a veritable pop phenomenon among teen girls (and their mothers), and the very faithful screen adaptation was an unqualified hit with the fans. Kristen Stewart is the human damsel Bella Swan, who is uncommonly, instinctively, irrationally attracted to the brooding Edward Cullen (Robert Pattinson), a pale, aloof high school dreamboat in a reclusive vampire family that has vowed to live in harmony with humans. Director Catherine Hardwicke celebrates the swoony emotional intensity of romantic delirium – this is one heroine who is literally swept off her feet – and delivers the goods when the feral vampire hunters (led by Cam Gigandet) target Bella to rouse the Cullens into battle.

Features an amiable but lazy commentary by Hardwicke, Pattinson and Stewart, who have a tendency to go on about little stories from the set and behind-the-scenes vignettes, as if struggling for something to say. Also features five extended scenes and five deleted scenes (with introductions by the director), and the 54-minute documentary “The Adventure Begins: The Journey From Page to Screen,” which isn’t all that well organized but does feature a lot of behind-the-scenes footage and numerous interview clips with Meyer (in addition to the cast and crew). Also includes three music videos and a short featurette from the cast’s appearance at Comic-Con, notable mostly for the nonstop screaming by the fans.