Larry Watanabe's Blog

Why Process?

2011-07-22T08:52:00.000-07:00

I'm beginning to understand why software companies have process. It isn't because you have bad programmers on your team. Usually you have a few great ones, a lot of good ones, some average ones, and the occassional bad one. But any one of them can mess up the system on any given day, and it isn't necessarily the bad programmers who are the worst offenders -- sometimes it's the great ones.

Netbeans API

2011-04-22T10:16:00.000-07:00

Netbeans API
- tutorial - learning trail
- tried first example, didn't run until added more libraries
- do not see the System.out.println result

SVN Import

2011-04-19T19:01:00.000-07:00

http://svnbook.red-bean.com/en/1.4/svn.tour.importing.html

svnadmin create /usr/local/svn/newrepos
$ svn import mytree file:///usr/local/svn/newrepos/some/project \
-m "Initial import"
Adding mytree/foo.c
Adding mytree/bar.c
Adding mytree/subdir
Adding mytree/subdir/quux.h

Committed revision 1.

---------------

So much better than the headache of figuring out CVS Root syntax

Hibernate Notes

2011-04-18T15:34:00.001-07:00

Hibernate Notes
1. Develop a system that displays, allows add, delete, and modifications
New Project
2. Web Application,
3. select Hibernate and Java Faces frameworks,
4. choose correct database
hibernate configuration
1. open hibernate.cfg.xml
2. add,
a. driver_class,
b. url, jdbc:mysql://localhost:3306/databaseName
c. username,
d. password if not there
3. Optional Properties
a. Configuration properties
i. Show_sql – true
4. Miscellaneous properties
a. Current_session_context_class – thread
Package
Create filviewer package in Soruce Packages
HibernateUtil
i. Use File->Hibernate->New HIbernateUtil (or somewhere in there)
ii. Put in Source Packages in package filmviewer
Reverse Engineering
i. Go to default package
ii. Open up New file->Hibernate->Hibernate reverse engineering wizard
iii. Use src/java
iv. Add tables from database
Mapping POJO’s
i. Use File->Hibernate->Hibernate Mapping Files and POJO’s from Database
ii. Use
a. JDK5.1 language,
b. hibernate.cfg.xml ,
c. hibernate.reveng.xml,
d. domain Code,
e. Hibernate XML Mappings
Session Bean
i. Use File->JavaServer Faces->JSF Managed Bean
ii. Use either Request Scoped or Session Scoped as appropriate.
iii. Edit:
a. Import Org.hibernate.Session, Query, Transaction, java.util.*
b. Cache HibernateUtil.getSessionFactory().getCurrentSession() in an instance variable
c. Helper Methods
private Session getSession() {
return HibernateUtil.getSessionFactory().getCurrentSession();
}

private Transaction beginTransaction() {
return HibernateUtil.getSessionFactory().getCurrentSession().beginTransaction();
}

private Transaction getTransaction() {
return HibernateUtil.getSessionFactory().getCurrentSession().getTransaction();
}
View
public List view() {
try {
beginTransaction();
Query query getSession().createQuery("from Film");
List< POJO > result = (List< POJO >) query.list();
getTransaction().commit();
return result;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
Add
public void add(String title, String description) {
try {
beginTransaction();
POJO film = new POJO ();
film.setTitle(title);
film.setDescription(description);
getSession().save(film);
getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
}
}
Delete
public void delete(int id) {
try {
beginTransaction();
Film film = (Film)getSession().get(Film.class, id);
getSession().delete(film);
getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
}
}
Update

public void update(int id, String title, String description) {
try {
beginTransaction();
Film film = (Film)m_session.get(Film.class, id);
film.setTitle(title);
film.setDescription(description);
getSession().update(film);
getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
}
}

Running Methods/Accessing View
a. Edit Web Pages/index.xhtml
b. Add xmlns:f=http://java.sun.com/jsf/core
c.

Debugging
1. Helpful to run server from console using glassfish\bin\startserv so you can see stacktraces in terminal window.
Database
Example of how to create a table with autoincremented primary key
CREATE TABLE film (
filmId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) ,
description VARCHAR(1000)
);

What to plan before starting development on a project?

2011-04-18T07:09:00.001-07:00

[someone asked this on Programmers.stackexchange.com - my response]

Most important thing to do: review the specs, interact with customer to get more refined specs.

The requirements are undoubtedly incomplete, vague, or incorrect. The biggest waste of time is doing the wrong thing. Customers are not professional software engineeers, and cannot be expected to be good at developing a good set of requirements.

So, you should review the specs, interview the customer and find out if this is what he/she really needs and wants, and can afford, etc.

Develop test/use cases and review with customer. If a requirement isn't testable, throw it out.

Develop the design and make sure if all the pieces function correctly that it would in theory do what you need.

Develop an architecture prototype that tests all of the technology to be used in every layer but ignore functionality. You are testing the architecture, not the functional specification. Having the wrong architecture will mean you have to rewrite everything, so getting the right architecture is important. Make sure it can meet your requiremenets for speed, efficiency, security, etc.

How to delete a windows service

2011-04-12T09:11:00.001-07:00

1. Run Regedit or Regedt32

2. Find the registry entry "HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services"

3. Look for the service there and delete it. You can look at the keys to know what files the service was using and delete them as well (if necessary).

Glassfish no free port available port value out of range

2011-04-09T20:15:00.001-07:00

You may get this error when trying to start the Glassfish server. I believe this occurs because it's trying to use a port already in use.

My glassfish was set up with default ports 8080, and I had a Default Web Site and Team Foundation server running using port 8080. When I shut these off, this error disppeared.

When I have time I'll just change the ports.

Kamikaze Java

2011-04-07T21:19:00.001-07:00

Sun's Java initiative reminds me of the Kamikaze in WWII. A gutsy move against an overwhelmingly powerful enemy, but they had to know its close to the end when they're that desperate.

Zune - No installation Media

2011-04-04T01:48:00.001-07:00

This fix worked for me

http://support.microsoft.com/kb/910336

find Missing int - amazon question

2011-03-29T02:46:00.000-07:00

static private void findMissing(int[] intArray, int n)
{
bool[] bitArray = new bool[n];

if (intArray == null)
throw new Exception("findMissing - intArray is null");

for (int i = 0; i < n; i++)
bitArray[i] = false;

foreach (int x in intArray)
{
if (x < 0 || x >= n)
throw new Exception("findMissing - x is out of range - x=" + x);
bitArray[x] = true;
}
for (int i = 0; i < n; i++)
{
//Console.WriteLine("i=" + i + " bit=" + bitArray[i].ToString());
if (!bitArray[i])
Console.WriteLine("Missing element at i=" + i);
}
}

static private void testFindMissing()
{
int[] intArray = new int[]{ 1, 2, 4, 7, 3, 5, 6, 0, 9, 10 };
findMissing(intArray, 11);
Console.ReadLine();
}

amazon question find min diff in a list of int

2011-03-29T02:28:00.001-07:00

static private void minDiff(int[] intArray)
{
if (intArray == null)
throw new Exception("minDiff - intArray is null");

var query = intArray.OrderBy(x1 => x1);
List intList = query.ToList();
if (intList.Count <= 1)
throw new Exception("minDiff - must have at least 2 elements in list");

int minDiff = int.MaxValue;
int x = -1;
int y = -1;
for (int i = 1; i < intList.Count - 1; i++)
{
if (intList[i] - intList[i - 1] < minDiff)
{
x = intList[i];
y = intList[i - 1];
minDiff = x - y;
}
}
Console.WriteLine("x=" + x + " y=" + y + " minDiff=" + minDiff);
Console.ReadLine();
}

static private void testMinDiff()
{
int[] intArray = new int[] { 3, 9, 6, 17, 33, 1, 16 };
minDiff(intArray);
}

Nesting Functions vs Intermediate Variables

2011-03-23T20:42:00.000-07:00

Unless you really love looking at the call stack, create intermediate variables and un-nest your function. The compiler will compile away these variables anyways, so no loss in efficiency. They will be handy for debugging and make the code clearer.

Delete a Project from Team Foundation Server

2011-03-22T07:21:00.000-07:00

Answer: go to the Visual Studio 2010 command prompt and use “TfsDeleteProject.exe“.

Example:

TfsDeleteProject /collection:http://larry-pc:8080/tfs “Fret Project“

You can get the url, if you've forgotten it, by going to
Team -> Connect to Team Foundation Servers -> Servers ..

Forcing DataGridView to Refresh when changed

2011-03-22T01:11:00.000-07:00

This works - save DataSource, save scroll position, restore datasource, restore scroll position, e.g.

private void forceRefresh()
{
int x = dgvMusicalScaleList.FirstDisplayedScrollingRowIndex;
dgvMusicalScaleList.DataSource = null;
dgvMusicalScaleList.DataSource = musicalScaleList;
dgvMusicalScaleList.FirstDisplayedScrollingRowIndex = x;
}

You forgot to make it public, dummy!

2011-03-21T23:29:00.000-07:00

Microsoft has a convoluted way of saying this;

Error 1 Inconsistent accessibility: property type 'System.Collections.Generic.List' is less accessible than property 'Frets.MusicalScale.notes' J:\Users\Larry\Documents\Visual Studio 2008\Projects\Frets\Frets\Classes\MusicalScale.cs 44 41 Frets

2-valued boolean variable

2011-03-19T10:27:00.001-07:00

What do you name a variable that is a boolean but can have 2 meaningful values out of N?

Example: x can have values "red" or "blue".

Calling it bRed, or isRed, is meaningful if he value is true , but doesn't convey any info about the "false" case.

YOu could implement it as an int, or if you are picky, as an enum. But this means more lines of code to declare the enum, etc.

I thought of "redOrBlue", but logically speaking, the value is always true :)

What do you think of "redNotBlue"? Any better ideas?

DataGridView not Updating when DataSource modified

2011-03-19T03:58:00.001-07:00

I had this problem. I managed to solve it as follows:

int x = dgvMetronomeSpeeds.FirstDisplayedScrollingRowIndex;
dgvMetronomeSpeeds.DataSource = null;
m_metronomeSpeeds.Add(new Integer(0));
dgvMetronomeSpeeds.DataSource = m_metronomeSpeeds;
dgvMetronomeSpeeds.FirstDisplayedScrollingRowIndex = x;

If you don't save and restore the FirstDisplayedScrollingRowIndex, then the user loses his/her scroll position.

other keywords - c#, msdn, .NET, scrolling

Never take notice of an error that you don't know how to handle

2011-03-18T10:38:00.000-07:00

This is in general a good principle, but in specific cases it is a good idea to intercept it. The special case is when the error occurs at a very low level (i.e. a null pointer exception) and thus there is not enough context information to make sense of the error.

When debugging, it isn't an issue because you have access to the call stack and can figure out the context from there. If, however, the error is generated for a user, and the user provides the information to support, then there won't be enough information to figure out the error, at least not easily.

In this case (or if you are a developer and are anticipating this case happening in the future, where the user might be QA) it is often helpful to catch the error, add some context information, and rethrow the exception. Or, you could check for the error that might cause the exception, and throw an exceptioin yourself instead of calling the routine that might generate the exception.

For example, usinng a variable

Class1 c = complicatedCreationMethod();

....

c.method1();

Now, method1 will fail if c is null. If there is any possibility that complicatedCreationMethod() might return null, you may want to check for this and throw an exception rather than simply letting the null pointer exception percolate to the top of the error handlers.

Tracking down bugs

2011-03-16T09:23:00.001-07:00

This is basic, but anyways this is how I do it.

Put a breakpoint before the error occurs (your best guess). Step OVER code (not going into any code) until you run into the exception. Then, set the breakpoint at that procedure call, remove the previous breakpoint, step into that part, and repeat above until you find the bug.

Eventually you end up with a single line of code where the error occurs, that has no function calls. Simplify the call by removing any nested procedure calls and serializing them. E.g. instead of f1(f2(f3)) do x = f3; y = f2(x); z = f1(y). This makes it easier to step and watch the variables.

Data Design or Procedure First?

2011-03-14T09:11:00.000-07:00

It's often a difficult decision whether to design the data representation or the algorithm first.

In a big team, designing the data representation first means that all team members can work on their individual functional components that operate on the same data representation.

However, the data representation may not be the right one for the algorithms, or not as simple or optimal as it could be. To determine the best data representation, you need to design the algorithm first.

When programming individually, I find it is best to figure out the simplest data representation (even if hard-coded, no IO) required to develop the algorithm, get that working, then modify the data representation to fit additional requirements (i.e. persistence, modifiability, etc). There's no point designing a lot of functionality (i.e. communication, database, etc.) if you don't have a good representation.

In a team, you can do this by prototyping critical algorithms first, then designing the data representation, then passing out functional component work.

Xml Serialization and Deserialization of Complex Objects/Lists

2011-03-14T00:24:00.000-07:00

http://msdn.microsoft.com/en-us/library/ms950721.aspx

what isn't really made clear here is that you have to pass into the XMLSerializer constructor all the types that will come in the nested types of the objects. you can do this e.g.

public class Class1
{
public static Type[] extraTypes = new Type[] { typeof(Class2), typeof(Class3) }

private list1 List = new List();
public List
{
get ..
set ..
}
... same for Class3 ..
}

Then you need to create the xml serializer as XmlSerializer(typeof(Class1), Class1.extraTypes)

Changing SoundPlayer volume

2011-03-11T11:06:00.001-08:00

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/42b46e40-4d4a-48f8-8681-9b0167cfe781

CheckedListBox Mutual Exclusive Selection

2011-02-23T12:25:00.000-08:00

I thought that this would be a simple property setting in the CheckedListBox, but no I guess not. I assume that the individual only wants to select one item, and that item should be both selected and checked.

Here's how I did it:

private void checkOnlySelection(CheckedListBox cbox)
{
Object selectedItem = cbox.SelectedItem;
if (selectedItem == null)
return;
for (int i = 0; i < cbox.Items.Count; i++)
{
Object o = cbox.Items[i];
bool match = o == selectedItem;
cbox.SetItemChecked(i, match);
}
}

Just call this method in the SelectedIndexChange event handler and it will do the trick.

Career Aptitude Tests - Nature vs. Nurture

2011-02-17T09:25:00.002-08:00

If they ever develop a really good test for career aptitudes, what correlations they would find? Gardeners <-> biologists, mechanics <-> computer programmers, waiters/tresses <-> actors/actresses? But every waiter is an aspiring actor so it would be hard to separate nurture vs. nature. Are they called waiters/resses because they're all waiting to become actors/tresses?

Orange Peel Plant Food

2011-02-17T09:25:00.001-08:00

Cut up orange peels added to the soil really give house plants a growth spurt. Grapefruit and lemonade also work, but not vinegar, so it's something in the citrus (vitamin C?) and not the acidity.

Blues and Folk and Rap

2011-02-17T09:20:00.001-08:00

Blues, folk, and rap are pretty similiar. Structured chord progressions, and in the foreground, the guitar solo is speaking for blues, the singer's voice is speaking for folk, and the rapper's words is speaking for rap.

Media Sync Problem on Blackberry

2011-02-13T09:27:00.000-08:00

I tried to use the "Media Sync" on the Blackberry Desktop software and got an error

Media Services are Not Available.

You need to turn on mass storage mode from the connected Blackberry device to use this feature. This may require you to reconnect your device.

Here's a link on the blackberry site for a fix.

In theory, yes. But when the device reset, and I clicked on "Media Sync", I once again got the "Media Services are Not Available" message. Maybe next time I'll get a Nokia or Samsung (IPhones are cool but way outside my budget until I get off my contract).

The article then says to go to Microsoft Support and look up KB 297694. This has a hotfix -- for Windows XP only. I've got Windows 7. And the "Contact Us" link doesn't actually have any specific category for technical issues - only one for non-technical issues, instructions to contact your manufacturer, or specific categories (like IPhone) that aren't related.

Now I'm not only getting the runaround within a company, they are coordinating their runaround strategies to send me to another companie's runaround department.

Someone suggested just going back to version 5.0. Having worked in this industry, I can guess what happened: the guy who wrote the software and understood it moved on to another job, within or outside the company, and the new programmers are being managed according to the latest approach (structured programming? agile? foobarius?) and no one really knows how the software works.

bizspark

2011-01-05T11:56:00.002-08:00

I finally got my site www.sym3d.ca done, and applied to the BizSpark program offered by Microsoft at www.Bizspark.com It's a handy program that gives you cheap access to Microsoft software, and contact with venture capital and business partners.

To apply, you need a business site, and a non-free email account. Most hosting services give you some email addresses associated with the site for free, and google apps gives you a free version restricted to 50 users. I used the hosting service discountasp.net which offered a year of hosting for $90.

Long Arrow and the Lost Amulet

2010-12-10T11:47:00.000-08:00

When something goes wrong do you try and escape by fantasizing you're someone else? This morning I got home and couldn't find my keys in my pocket.I was going to have to backtrack and try and find it. So .. this is my tale.

Long Arrow sighed with relief as he arrived at the camp. He reached down to touch his amulet for reassurance ...what? Where was his amulet. With a sinking heart he remembered the clinking sound along the trail some miles back .. could he have dropped it?

He was cold and hungry .. but without the amulet, he could not enter his camp that was magically sealed against intruders not bearing one of the amulets.

Steeling his will for the long discouraging journey back, he stripped his gear down to the essentials to make for a lighter trip. He unloaded the goods that he had brought back to the camp and put down the tools and gear he would not need for this trip. Speed was of the essence, lest another warrior or demon spirit come across the amulet and pick it up.

Swiftly but carefully retracing his path, he started his relaxed, ground-eating lope. He tried to visualize where he had heard that sound ..was it where the path approached the Dundas rock?

The miles faded into a blur but With a sinking heart he was fast approaching the Dundas rock and had not yet come across the amulet. He would have to continue his journey further, all the way to the trading post. Perhaps he had dropped it there before loading up for the trip back.

Grimly he tried not to think of the consequences if he could not recover the amulet. Without the amulet, he would have to try and survive until another warrior returned to the camp with an amulet. But all the warriors had left for the day and would not return until nightfall.

The trading post appeared around the bend, and he ran inside. The proprieter asked him "Back again Long Arrow .. did you forget something?"

"I've lost my spirit amulet .. has anyone turned it in?"

"Sorry, we don't have it"

Suddenly Long Arrow felt something brush against his thigh. His amulet! It was caught on a thread from his jersey. Feeling a little foolish he stuffed it into his pocket and prepared for the trip home, but much more lighthearted. The trip would be easy knowing that he would be able to enter the camp at the end.

(although I felt pretty dumb then)

I love Holloween

2010-10-27T13:46:00.001-07:00

This is for my friend Mark Landsberg :)

Mark -- you don't like me calling it "Holloween"?

the day for phantoms, goblins and creatures unseen?

You say that "hallow" not "hollow" is the appropriate name

I think "hollow's an appropriate term just the same

Cause there's lots of "hollow about the october's end

Pumpkins, chocolate witches, and stomach's on the mend,

So if you feel that "holloween" is difficult to swallow,

Like an overly sweet chocoate coated marshmallow,

Wash it down with a grin and a spicy apple cider,

glass of brandy, or rum, whichever you decide, sir.

I could use a wish right now

2010-10-09T19:34:00.000-07:00

I love Hayley Wiliams voice ... and I was listening to "Airplanes" but thinking that he doesn't really need a wish that badly :) So I wrote this.

You don't need a wish cause your rap game is slow
You need a wish when you've got no where to go
No place to turn to and the heat's on you
You've lost your friends and your love for true

You're complaining now cause your life is too soft
You're forgetting what you were, what you've lost and the cost
You haven't lost anything but the suffering and pain
Why you want to remember living on the street in the rain?

If you remember that, you'll remember you don't need a wish
You live in a mansion, beautiful wife who's a dish
You don't want to go back to the life that you left
Or remembering the taste of fear as you fled

So you've lost the music came from the pain and the fears
Now your words have no feel don't leave anyone in tears
But don't reminisce about the good days gone past
If they were so good then why'd you flee so fast

Let the airplanes fly on high fly right on by
Leave the wishes for others whose life is a cry
For help no one answers or cares anyhow
But they really could use a wish now, wish right now

Who you are

2010-10-02T00:19:00.001-07:00

i know who you are,
you're my superstar
you can become anything
become anyone
you've got that chameleon groove going
you're my perfect girl
put my head in a whirl
i fulfil your needs
continue to succeed
but we both know the truth
the truth is a lie
words we live by
but the lie becomes the truth
and the truth becomes moot
you fake it for me
perfect girl that you be
and i know it
you bestow it
with deception and faking it
you know you're not taking it
that i'm drawing you in
with a simulation of sin
but the more you fake it
the more you become it
and you know it
and i'm hoping
that you're hoping
that you'll become it for real
we're both going by feel
i want to see you this weekend
you want me to come in
do the things unbelievable
things inconceivable
we'll continue to try
til one of you dies

The Life you Chose

2010-09-29T11:05:00.001-07:00

Larry don't leave me, please don't go, don't leave ever
I remember you saying that, holding you promising never
but though you had your chance, you never would change
never understood that, always thought it so strange
you wouldn't do anything, is this the life you wanted?
guess you got what what was coming though your words still haunted
Larry don't leave me, please don't go, don't leave ever
i remember you saying that, holding you promising never.

Heartless (Taylor I can't take no mo) .. VMA 2010

2010-09-15T20:16:00.000-07:00

Taylor A. Swift wrote a beautiful song "Innocence" for the VMA ... taking the high road. I heard, though that Kanye and a response ready in case it wasn't the classy song it was ...

Heartless (for Taylor version)

In the night i hear 'em talk, the coldest story ever told
Somewhere far along this road he lost his soul
To a woman so heartless
How could you be so heartless?
How could be so heartless?

How could you sing that song
Talkin all about how i did you wrong
Just try and treat me please with a little class
Don't like it when Barack calls me a jackass

I mean after all the shows that we've been through
All the awards and recogition that we got into
Hey yo, you wrote a song to scold me
Hey yo, I did some things but that's the old me

And now you wanna get me back and you gonna show me
So you make up this song singing po me
You got everyone as a friend, nobody know me
Now I'm feeling low just so lonely

[chorus]

How could you be so Dr. Evil?
You bringing out a side of me that I don't know
Why make the audience hate me so
I hear boos and more from every row

Why does she be so mad at me for?
I like Beyonce that was a mistake
It was a live show, couldn't do a retake
I didn't know my life was at stake

You go and sing a song that's dissin me
Now there aint no girls around that are kissin me
Couldn't you wait a month until I release my new CD
So I could get a few plays on the MTV

[chorus]

Talkin' talkin' talkin' talk
Baby please please knock it off
You don't know what I've been through
You don't know what my agent made me do

So please just let it be
Don't keep on hatin me
Leave me in my misery

I know you can't believe
I could just let it be
An you can't make it worse
I been trashed by this curse
I'm gonna try and sing tonight
I'm so tired of this fight

[chorus]

Heart of Mine

2010-09-10T15:38:00.000-07:00

I tried to call she said that you're out,
wanted to hear your voice and see what you're about,
what you're about,
I met you somewhere downtown last week,
Stopped for ice cream, danced in the street,
danced in the street,

[chorus]
Can Isee you this weekend,
cause you're the girl, on whom I depend
to make me smile, to make things alright
to be beside me through the long night

If you agree, to meet me there,
wherever you want, anywhere,
I'll be there always, anytime,
go anywhere to be with this heart of mine ,
You're in this heart of mine,
You're in this heart of mine,

Said it was the first time you've hear a crowd roar,
Dancing as if you've sprung wings to soar
I want to show you that there's so much more,
There's so much more,
so much more,

I want to see you so lets get together,
I'm asking you for now, not to be forever,
Just a moment that we can remember,
that we can remember

[chorus]
Can i see you, again this weekend,
cause you're the girl, on whom I depend,
to make me smile, to make things alright,
to be beside me through the long night,
If you agree, to meet me there,
wherever you want, anywhere,
I'll be there always, anytime,
go anywhere to be with this heart of mine,
You're in this heart of mine,
You're in this heart of mine.

I love to see you with your hair down,
and walk together through the town,
I have the hat you left to me,
Does that mean you want to see me,
Am I your love or just a good friend,
I don't care, let's just meet again,
Whether it's fake, or if it's real,
It's wonderful the way you make me feel.

[chorus]
Can i see you this weekend,
cause you're the girl, on whom I depend,
To make me smile, to make things alright,
to be beside me through the long night,
If you agree, to meet me there,
wherever you want, anywhere ,
I'll be there always, anytime,
go anywhere to be with this heart of mine,
You're in this heart of mine,
You're in this heart of mine.

Way life is

2010-09-08T20:04:00.000-07:00

I gave her my hoodie to wear
to show that I care
But her cousin dropped bleach on it
couldn't stand the sight of it
Nothing good enough for my girl
but that someone wants to tear it down
Her cousin always shared as if she cared
but who called the cops on her
the night before she was going to come clear
She was so near going to court going to appear
ready to do her time for the crime
She said she kicked a guy in the knee
But that was't really it you see
there was other things goin on
She did some other wrong
that she wouldn't talk about
Some stuff she didn't want to get out
She wouldn't open her mouth up
Too afraid to fess up
Stuff that was just too messed up
I don't know what happened
Her story would always change
Something stranger some hidden danger
Never told me twice the same
Always different facts different names
But I held her when she was cold
Hoping we have time to be together, to grow old
Together through good and bad weather
But it wasn't to be at least with me
So you see though we got together now and then
I knew I couldn't depend
on anything she said
Even when I almost died she never cried
Now don't get me wrong after I was gone
I don't blame her for none of that
I know people said she was no good
Something about her that I misunderstood
But I just liked her anyways
For the good times the good days
When I'd catch her off guard
Come up behind her
Say a word to her whisper "you look beautiful"
Nothing more than being truthful
I knew this was the last time I'd see her
Getting too dangerous I couldn't be with her
Too many people trying to put me down
Time for me to leave town
So I just let her walk away
So I could live another day
Sorry sis that's just the way life is

Hack you Again

2010-09-08T11:54:00.001-07:00

"Hack you again" -- Sing to Miley Cyrus's "See you again." Written for Taylor A. Swift whose account got hacked -- lyrics in comment below.

I got my account hacked again and I'm really so pissed
I have a password now that will never be guessed
Knew you were up to something when you asked for my name
Now I can't wait to hack you again

I've got a way of knowing when something's not right
I feel you're collecting all the data on my life
Cuz i felt this IP connection when you pinged my site
Oh, i can't wait to hack you again

The last time I logged on, I kept getting kicked right out
I typed and typed wondering what the heck is this about
Like I couldn't see what the eff is wrong with me
My best friend Mandy said "Oh, poor security"
The next time I log on i will use caps and non ascii
My heart, it can't rest til then, oh woah woah
I can't wait to hack you again

Wish I had your life

2010-09-04T22:36:00.000-07:00

Your song is just so beautiful it makes my heart just melt,
but is losing your last boyfriend all the pain you've ever felt?
Have you ever felt a butcher knife pressed up against your throat ,
stashed a knitting needle weapon in the lining of your coat?
Not ducked as loaded guns were pointed at your head,
laughed at the fools for only packing .22 cal lead.
You've probably known real love from parents who have souls,
they're not just posers who pretend to fulfil their roles.
Have you ever been set up when you're carrying an inner life
Had to face a jealous girl alone with just a kitchen knife .
Have you ever tried to say you saw her live the following day,
Just to see your dad shake his head, "those wounds were meant to slay"
Have you ever felt it's not your fault your hands are much too quick,
But they shouldn't think you're just another gutless pretty chick.
Have your parents used you time and time to pay the monthy rent,
and looked upon your body as a gift that heaven sent.
Have you even once been told that you are not to use the bath,
cause you didn't want to work this month, so now you face their wrath.
You're lucky not to be one that they sent last month to meet,
the man who helped them not be kicked out to the cold wet street.
Have you ever thanked your God, that Catholics never lie,
else when they say they love you, then that's when you'd really cry.
Your song is just so beautiful it makes my heart just melt,
But I'd trade it in a second for the life that I was dealt.

Peter Principle of Relationships

2010-08-24T05:11:00.000-07:00

No matter how beautiful/handsome, intelligent, rich, talented, and famous you are, if you really try you can always find someone who doesn't think you're good enough for them.

Session state can only be used when enableSessionState is set to true,

2010-08-23T12:31:00.001-07:00

trying to reference a sessionvariable that hadn't been initialized yet. I was trying to referencethe session variable in one of my page's class constructor before theSession_Start function had been executed in the global.asax file
.

Don't you need someone to love?

2010-08-19T13:28:00.000-07:00

Just needing someone to love means you're an empty shell ..... needing to love the right someone means you're a person of discrimination and taste.

sql server management studio prevent option off

2010-08-19T08:00:00.000-07:00

Go to Tools-> Options -> Designers -> Table and Database Designers
checkbox "Prevent saving changes that require table recreation"

http://www.sql-server-performance.com/faq/saving_changes_not_permitted_p1.aspx

report server canot decrypt symmetric key

2010-08-16T08:46:00.001-07:00

http://support.microsoft.com/kb/842421

Reporting Services keeps prompting for login

2010-08-16T07:22:00.000-07:00

See this for a solution. I just went to RS Configuration manager, Service Account and set it to Network.

http://blogs.msdn.com/b/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx

Reporting Services Report Parameters

2010-08-13T11:24:00.001-07:00

Find under Report->Report Parameters.

passing to subreports:
http://msdn.microsoft.com/en-us/library/ms160348(SQL.90).aspx
click on subreport, right click, select properties, go to parameters tab.

Renaming web site in asp .net Visual Studio

2010-08-12T11:42:00.000-07:00

Just open up the .sln file in notepad, and change it there. The web.config file doesn't do anything.

Reporting Services

2010-08-12T07:35:00.000-07:00

Http error 403 - trying to fix by
Control Panel -> Administrative Tools -> IIS --> Web Sites --> Default Web Site --> Report Server --> Properties --> ASP .NET tab --> Edit Configuration --> Application Settings - comparing to working site.

Will Lady Gaga and Miley determine the fate of the FB universe?.

2010-08-12T07:11:00.001-07:00

Lady Gaga and Miley Cyrus are the black holes of FB .... follow any friendship path and it leads to them. Though black holes have been called (little?) gravity monsters, they may be indispensable forces of creation -- fundamental forces in the development and ultimate shapes of galaxies and the stars within them.

Shai Woodley is in a relationship.

2010-08-11T15:12:00.000-07:00

Shai Woodley is in a relationship.

Oh no...Shai is taken again
We'll try to refrain
From writing love notes so inane
(though some would say lame)
They don't make boyfriend's jealous,
But feel pity toward us fellas

Ashley is bored

2010-08-10T04:03:00.000-07:00

Ashley F. Efron Bored :(
5 hours ago · Comment ·LikeUnlike · View Feedback (4)Hide Feedback (4)

poor ashley is bored
would it be untoward
if I gave you a surf board
as a teen choice award
for the girl with whipcord
abs? it's all I can afford

Shenae Grimes

2010-08-10T03:54:00.000-07:00

Shenae Grimes Dear Shenae, [Finish This

Dear Shenae,
i hope you don't mind a
lot if I've kinda
got a litle crush i find ya
so cute .. can I wine and dine ya?

Principle: Data Independence

2010-08-09T12:07:00.000-07:00

A program should function correctly regardless of the state of the database or the data inputs. "Correctness" means that it has anticipated and handles the error, or informs the user of the problem and exits in a pre-defined manner.

Simple LINQ Join Query ASP .NET C#

2010-08-09T11:34:00.000-07:00

// Query.

var Found = from o in Orders
join c in Customers on o.CustomerID equals c.CustomerID
select new { c.Name, o.OrderID, o.Cost };

it's not that there's no time like the present ... but that there is no time but the present.

2010-08-07T08:31:00.001-07:00

and for this one moment, i am going to procrastinate

Import Export Transport Save Data SQL Server 2005

2010-08-04T16:25:00.001-07:00

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

Restarting/Stop/Start MS SQL Server

2010-08-04T12:09:00.000-07:00

from command prompt:

:\Windows\system32>net stop mssqlserver

The SQL Server (MSSQLSERVER) service is stopping.
The SQL Server (MSSQLSERVER) service was stopped successfully.

:\Windows\system32>net start mssqlserver
The SQL Server (MSSQLSERVER) service is starting.
The SQL Server (MSSQLSERVER) service was started successfully.

:\Windows\system32>

changing SQL server authentication mode

2010-08-04T12:05:00.001-07:00

changing authentication SQL Server 2005
select database in object explorer
right click
choose properties
choose security

Publish/Deploy Web Site Visual Studio IIS

2010-08-03T06:30:00.000-07:00

Visual Studio: go to Build -> Build Website
go to Build -> Publish Website
note the Target Location
Go to IIS, on my machine it is Control Panel -> Administrative Tools -> Computer Management -> Services and Applications -> Internet Information Service
Under "Connections" there is a tree-view. Right-click on "Sites". Choose "Add Web Site".
From the Add Web Site Dialog, enter the site name, then Physical Path - same as the Target Locatoin from Step 3. (you can do these both at the same time and cut and paste)
Enter the host name, e.g. www.mysite.com
After that, configure it the way you want .. depends on your preference and the application.

Resizing a window when bottom right corner is off-screen

2010-08-03T06:21:00.000-07:00

Just right click, choose "size", then hover over another corner until you get the diagonal double-arrow resize cursor.

Actually, you don't need to right click and choose "size". You can resize from any corner in Windows 7.

I guess they just keep the item on the menu, because otherwise people would be phoning into ask "where did it go? how can I resize my screen?" :)

Visual Studio Line Number - how to turn on

2010-08-02T18:59:00.000-07:00

Visual studio produces error messages with line number references. Not very useful if you don't have line numbers in your text editor. Here's how to turn it on:

http://www.blackwasp.co.uk/TurnOnLineNumbering.aspx

Basically, to go Tools->Options, then on the left tree control go into "Text Editing" and then either a "Al Languages" or your language branch. Then click on the general settings, and you can select "line numbering".

"I'm gong to delete myself!" -- common line on FB

2010-08-02T07:27:00.000-07:00

I wish in real life people who deleted themselves could be reactivated

selly

2010-08-01T19:55:00.000-07:00

you can tell me u love me a millon times
it doesn't mean anything - no reason no rhyme
i still don't think you mean it
you don't care even a litle bit
there's times you've said you really care
then done something to wear my heart bare
you know who you are
you think you're a star
some girls think you're hot
but you're not worth a thought

Shai (SHAE) Woodley ...

2010-08-01T14:35:00.000-07:00

Shai Woodley My heart stops When you look at meJust one touch Now baby I believeThis is real So take a chance and Don't ever look back,
2 hours ago · Comment ·LikeUnlike · View Feedback (11)Hide Feedback (11)

a few extra lines ...

my heart stopswhen you look at me
i want to be with you so desperately
just one touch
...is that too much
this is the way i feel
now baby i believe this is real
so take a chance and don't ever look back
to your former loves ...just stay on track

Love those shoes!

2010-08-01T12:20:00.001-07:00

A relationship can be like a pair of expensive Italian shoes ... they look great, everyone admires you in them, and you really really want them ...but sometimes they just don't fit right.

2010-08-01T02:20:00.000-07:00

Alexandra posted this:

Alexandra Crittenden ‎"here i go, ill tell you what you already know, here i go.. ill tell you what you already know... if you lovee meee. with all of your heart, if you love mee.. ill make you a star in my universe" :)
about an hour ago · Comment ·LikeUnlike

I commented:

i didn't know
that if i loved you
you'd make me a star
shine down from afar
Your eyes light a twinkle
would make my mouth crinkle
smile at all that you do
if i loved you
would you share the view
of your galaxy that was hidden
from my eyes ...i was bidden
to stay away from you
because they knewh
ow deeply i feel
afraid you would steal
the light from my day
when you went away

Brookelle is peeved

2010-08-01T00:30:00.000-07:00

Brookelle McKenzie posted this status on her fb:

Brookelle Mckenzie Bitch please dont call me a fake. I know i am real, and i got people to back me up anytime(=And they are what i call, true friends(=♥

I filled in some extra lines, just in case she gets into a rap war with the other girl :)

Bitch please don't call me a fake
you have no idea what's at stake
i know i am real
that's just how i feel
and I got people to back me up anytime...
your baseless accusations are a crime
and they are what I call true friends
so you'd better get off or make amends

Tell me truly

2010-07-31T09:23:00.000-07:00

Olga Orlova wrote this on her facebook wall:

Olga Orlova
Tell me whyAm I the one your heart belongs to, why me?
Tell me whyAm I the one who won a place in your heart, why me?
Tell me why do you love me, why is it me you want?

on Monday

I couldn't resist responding with:

Larry Watanabe Let me tryto Tell you why
My heart belongs to you
because you're the one to renew
my spirit each day
i love you in every way
that's why ..
i prayyou feel this way too
for you're the one
who has won
a place in my heart,
why you?
the reason i love you?
you're so true
in everything you do
that's why its you i wan
tthe last words you said haunt
my mind although it daunts
me to live up to all
i've just written on your wall :)

Kate liked it

2010-07-30T15:00:00.000-07:00

Kate Hudson posted this on her facebook account:

When I'm with you I feel like flying,
when I'm without you I feel like dying,
and now knowing you don't feel the same way I feel like crying

I added these lines:

you talked and teased me til I was smiling
you told me you cared but you were lying
why'd you play these games is it a guy thing?

Kate liked it :)

14 minutes ago · LikeUnlike · 2 people Kate Hudson and Sascha-Ralph Nowak like this. ·

DropDownList SelectedIndexChanged not firing

2010-07-30T09:38:00.000-07:00

Edit the properties of the drop down list and set the AutoPostBack to true.

New Facebook Account for Hanna Dakota Fanning

2010-07-28T11:23:00.000-07:00

Hanna just created a new FB account and deleted her old one .. one of her friends was jealous of her or something. I wrote a piece of a song for her:

(modelled after Sheryl Crow's song )

Every day is a new account
I get a little bit of drama
the way people treat me is a crime
I get a little bit closer to deleting another time

Alway use a reaching assist

2010-07-28T07:38:00.000-07:00

Lifeguard Instructor: "Always use a reaching assist even if it's just your bathing suit".

Me: "Why? That won't help me reach them!"

Lifeguard Instructor: "So you can let go if you have to."

You can't save everyone but life is full of suprises and people are stronger than you think. Sometimes when they realize they're on their own they start kicking their legs and make their way to shore.

Aside - were you told of the girl who whipped off her suit during the final exam? I think it's a lifeguard myth myself ... just curious if they're still telling it 30 years later.

Hierarchical Data Repeater Asp .NET

2010-07-27T09:50:00.001-07:00

I looked at a lot of information on hierarchical data display in asp .net. I had trouble with al of them except this one:

http://msdn.microsoft.com/en-us/library/aa478959.aspx#aspn-hierdatabinding_topic4

Finding a Good Relationship

2010-07-27T06:40:00.000-07:00

Finding a good relationshp is like finding a good plum at the supermarket -- it's all about timing! But location also helps -- there are better plums at the farmer's market.

FindControl - Repeater problem - can't find repeater in context

2010-07-26T21:02:00.000-07:00

http://www.west-wind.com/Weblog/posts/5127.aspx

///

/// Finds a Control recursively. Note finds the first match and exists
///

///
///
///
public static Control FindControlRecursive(Control Root, string Id)
{
if (Root.ID == Id)
return Root;

foreach (Control Ctl in Root.Controls)
{
Control FoundCtl = FindControlRecursive(Ctl, Id);
if (FoundCtl != null)
return FoundCtl;
}

return null;
}

with this the code becomes:

///

/// Assigns controls from the subclassed control to this instance so
/// we always can access the controls in our base class.
///

protected void AssignControls()
{
this.lblError = wwWebUtils.FindControlRecursive(this.Master,"lblError") as Label;
this.dgItemList = wwWebUtils.FindControlRecursive(this.Master, "dgItemList") as DataGrid;
}

Repeater name does not exist in current context

2010-07-26T20:23:00.001-07:00

Try using the find control to find your repeater control and then proceed.

linq multiple join

2010-07-26T19:29:00.000-07:00

http://social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/thread/e09b50af-5ab4-4cfb-9617-ef2be339c17f/

this is a good article. Basically you need to make sure the types are the same, so cast if necessary.

FB msg: Are you the REAL Elvis Presley?

2010-07-26T18:28:00.001-07:00

next time someone asks if you're real, just tell them "No, I'm just a figment of you're imagination."

Why do we love acting?

2010-07-26T18:26:00.000-07:00

Why are humans good at acting? It's a skill that must have had some survival value Acting may be an expression of an adaptation mechanism that allows us to survive and thrive in situations where we don't currently fit.

Maybe acting and Stockholm Syndrome are two faces of the same coin.

Getting the ASP .NET CheckBox Value

2010-07-26T09:57:00.000-07:00

I tried to figure this out on the net. There was a lot of info to wade through for such an easy question.

Short answer: just use the Checked property to set or get the value, e.g.

MyCheckBox.Checked = true;

bool val = MyCheckBox.Checked;

Visual Studio crashes on opening a solution .sln file

2010-07-23T08:46:00.000-07:00

Here's a fix to the problem: delete the .suo files.

--------------------
Long version:

My attempts to open solution included: (1) System hard and soft re-boots ; (2) Getting the latest version of the solution from Team Foundation Server; (3) Rolling back changes I had made; and (4) eliminating Visual Studio Add-ins such as Jet Brains Resharper (ver sion 4.5). None of these helped. Blog post and information I found on forums about this issue do not reveal a consistent resolution to the problem (with some folk even reinstalling Visual Studio 2008 and the service packs; others removing and adding references from projects; or removing and re-adding projects in the solution).

I deleted the *.sou file for the solution and I was up and running sans my break points and bookmarks. So maybe the .sou file had become corrupted or Visual Studio was not able to deal with some combination of the elements it stores. Who cares? I was going again! Hopefully this might serve as a quick first option to resolve the issue for those who encounter it

Just Friends

2010-07-23T08:06:00.000-07:00

I'd rather be hated than "Just Friends" *shudder*

At least there'd be some passion there.

Starter Veggie Suggestions

2010-07-23T08:05:00.002-07:00

I'm trying to figure out what a good "starter" vegetable would be.

Something low-maintenance, looks good, and tasty

...hmmm...if you have any girl friends like that, send them my way too!

You could grow ....

2010-07-23T08:05:00.001-07:00

I live in an apartment ...someone told me "you could grow some weed in that spot there".

I don't see the sense in planting any dandelions but I've been thinking of secretly planting some artichokes there.

An infiinite world of possibilities

2010-07-23T08:02:00.000-07:00

the world has infinite possiblities; what is your perception?

I can't wait for your full list, but let me know your top 5 :)

Facebook is Watching You

2010-07-23T08:00:00.000-07:00

It's amazing how connected people are to fb these days. People post when they are going on/off line, when they're eating, etc.

What's next - a 24-hr multi-sensory monitoring system so you can experience everything another person does in virtual reality, with playback and search functions?

Search & replay: "all restroom trips by blonde supermodels in New York restaurants".

Poor Lindsay Lohan

2010-07-23T07:59:00.000-07:00

Feel sorry for Lindsay Lohan ... sometimes beauty, fame, and money can be a curse.
If Lindsay was a nobody with no money, and butt-ugly to boot, I don't think she'd be have the resources to get herself into the kinds of problems she's in (probably couldn't afford a car, for starters).

Of course, then she'd have the problem of being a poor butt-ugly nobody :)

Layla

2010-07-23T07:56:00.000-07:00

Learning "Layla" on the guitar.

Me: "Two guys each with millions of screaming groupies and they have to go for the same woman?."

Emily: "She must have been one SPECTACULAR woman" :)

Kento Watanabe - Composer

2010-07-23T07:54:00.000-07:00

My son Kent's music:

http://composersforum.ning.com/profile/Kento

Adding Scrollbars to TextBox in ASP .NET

2010-07-22T09:35:00.000-07:00

just outside the text box add this div tag in this

Undelete file in Team Foundation Server TFS

2010-07-21T08:09:00.000-07:00

You can undelete files/folders in TFS if that is what you want?

In Visual Studio, go to Tools, Options, Source Control, Team Foundation Server and check the "Show deleted items in Source Control Explorer" box. Then browse in source control explorer to the place where the project was located and you can undeleted it.

To make it appear in your solution you could then do a "Get Specific" on the project in Source Control Explorer, then right click on the solution and do "Add Existing Project..." to load the project from your local file system into Source Control Explorer.

Hope that helps - good luck,

Turning off anonymous authenticaion in IIS

2010-07-21T06:48:00.001-07:00

http://support.microsoft.com/kb/308160

How to configure IIS Web site authentication
Use an administrative account to log on to the Web server computer.
Click Start, point to Programs, point to Administrative Tools, and then click Internet Services Manager.

The Internet Information Services snap-in starts.
In the console tree, click * computer name where computer name is the name of the computer.
Right-click one of the following items, and then click Properties:
To configure authentication for all Web content that is hosted on the IIS server, right-click * computer name.
To configure authentication for an individual Web site, right-click the Web site that you want.
To configure authentication for a virtual directory or a physical directory in a Web site, click the Web site that you want, and then right-click the directory that you want, such as _vti_pvt.
To configure authentication for an individual page or file in a Web site, click the Web site that you want, click the folder that contains the file or the page that you want, and then right-click the file or the page that you want.
On the Item Name Properties dialog box where Item Name is the name of the item that you selected, click the Directory Security tab.

NOTE: If the selected item is an individual file, click the File Security tab.
Under Anonymous access and authentication control, click Edit.
Click to select the Anonymous access check box to turn on anonymous access. To turn off anonymous access, click to clear this check box.

NOTE: If you turn off anonymous access, you need to configure some form of authenticated access.
To change the account that is used for anonymous access to this resource, click Edit next to Account used for anonymous access.
In the Anonymous User Account dialog box, click the user account that you want to use for anonymous access.
Click to clear the Allow IIS to control password check box if you want to use the Windows LogonUser() API for user authentication.

NOTE: By turning this password control option off, this forces IIS to use normal authentication and to log the account on locally. You should turn this option off if users experience difficulty accessing resources such as files or Microsoft Access databases on a network computer.
Click OK.
Under Authenticated access, click to select the Basic authentication (password is sent in clear text) check box to turn on basic authentication. When you receive the following message, click Yes:
The authentication option you have selected results in passwords being transmitted over the network without data encryption. Someone attempting to compromise your system security could use a protocol analyzer to examine user passwords during the authentication process. For more detail on user authentication, consult the online help. This warning does not apply to HTTPS (or SSL) connections.

Are you sure you want to continue?
To select a domain with which to authenticate users that are using basic authentication, click Edit next to Select a default domain.
Type the domain that you want in the Domain Name box, and then click OK.

Note If you are concerned about security on your intranet because Basic Authentication transmits user name and password information in clear text, you can use Basic authentication together with Secure Sockets Layer (SSL).
Click to select the Digest authentication for Windows domain servers check box to use digest authentication. When you receive the following message, click Yes:
Digest authentication works with Windows 2000 domain accounts only and requires the accounts to store passwords as encrypted clear text.

Are you sure you wish to continue?
NOTE: You must configure user accounts with the Store password using reversible encryption account option turned on.
Click to select the Integrated Windows authentication check box to use integrated Windows authentication.

NOTE: This authentication method was formerly known as Microsoft Windows NT Challenge/Response or NT LAN Manager (NTLM).
Click OK, and then in the Item Name Properties dialog box, click OK. If the Inheritance Overrides dialog box opens:
Click Select All to apply the new authentication settings to all of the files or the folders that are within the item that you changed.
Click OK.
Quit Internet Information Services.

Detect Active Directory User with ASP.NET

2010-07-21T06:44:00.000-07:00

In IIS turn off anonymous authentication mode and select integrated windows security and basic. Then in your web.config file make sure you are using windows authentication. Then you should be able to access the user name by using

PHP Code:
User.Identity.Name

Adding Existing Project to Team Foundation Server

2010-07-14T05:51:00.001-07:00

It should work fine if you have Team Explorer installed and Check under Tools-->Options -->Source Control--> Plug-in Selection. Here you should have the Visual Studio Team Foundation Server as the current source control plug-in.

The other option is to add the files manually to source control. Open the source control explorer (View -> Other Windows -> Source Control) and the either drag 'n drop the files into the source explorer window, or choose the Add files button in the toolbar which will be available at left top in source control window.

Installing Adventureworks database in SQL Server 2005

2010-07-13T09:37:00.001-07:00

It was hard to track down a useful reference for installing the AdventureWorks database - this one worked (almost). Just had to use regular SQL database, not sqlexpress, but that was easy to find by refreshing the database list.

Just in case the page disappears, copying here.

http://msdn.microsoft.com/en-us/library/aa992075(VS.80).aspx

Walkthrough: Installing the AdventureWorks Database

This walkthrough shows how to install the AdventureWorks sample database for SQL Server 2005, which is a prerequisite for other walkthroughs provided in the ReportViewer documentation. AdventureWorks is not automatically installed with SQL Server or SQL Server Express, but can be downloaded from a Microsoft Web site. You can use the instructions provided in this walkthrough to download, install, and configure a connection to the AdventureWorks database.

The version of AdventureWorks that is distributed with SQL Server 2005 is different from earlier versions AdventureWorks. If you already have a previous version of AdventureWorks, you should install the most recent version so that the queries in other ReportViewer walkthroughs work as expected.

To learn more about using the AdventureWorks sample database, you can search for "AdventureWorks Sample OLTP Database" in SQL Server 2005 Books Online. Books Online is available in most editions of Visual Studio 2005. You can view it on MSDN at www.microsoft.com. You can also download the "AdventureWorks OLTP Database Diagram" from http://www.microsoft.com/downloads/.

Prerequisites
--------------------------------------------------------------------------------

You must have a SQL Server instance installed for which you have permissions. If you installed SQL Server 2005 Express, the default instance name is (local)\sqlexpress. If you upgraded an MSDE instance to SQL Server 2005 Express, see the SQL Server Books Online topic "Upgrading MSDE to SQL Server Express".

The following steps describe how to download, save, attach, and configure the AdventureWorks database.

To download adventureworksdb.msi
--------------------------------------------------------------------------------

1.Navigate to this download Microsoft Web site. Double-click AdventureWorksDB.msi.

2.Click Run and complete the installation wizard. AdventureWorks_Data.mdf and AdventureWorks_Log.ldf are copied to your SQL Server data directory. For SQL Server 2005 Express, the default is c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\.

To confirm your SQL Server data directory
--------------------------------------------------------------------------------

1.Open a Visual Studio 2005 command window. From the Start menu, click All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt.

2.Open a connection to a local SQL Server Express instance by typing or copying the following command into the command line:

CopySQLCMD -S (local)\sqlexpress -E
3.Press Enter.

4.At the SQLCMD prompt, type or copy the following commands.

Copyselect physical_name from sys.database_files where name = 'master'
go
This query returns the location of the file master.mdf, confirming the SQL Server data directory where you will place the AdventureWorks database files.

To attach AdventureWorks to your SQL Server
--------------------------------------------------------------------------------

1.At the SQLCMD 1> prompt, call the sp_attach_db stored procedure to attach the AdventureWorks database in the data directory determined in the previous step. The line below uses the default location for SQL Server 2005 Express. Edit the text as necessary to use the data directory confirmed in the previous steps. Type or copy and paste the following statement into the command window (the statement must not have line breaks).

Copyexec sp_attach_db @dbname=N'AdventureWorks', @filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'
2.Type go.

3.Press ENTER. You may see a series of messages about converting and upgrading the database.

4.Type exit to close the command window.

To verify Adventureworks is attached
--------------------------------------------------------------------------------

1.Open Visual Studio 2005. You do not need to open a project.

2.From the View menu, choose Server Explorer.

3.In the Server Explorer window, right-click on Data Connections and choose Add Connection. The Add Connection dialog box opens.

4.Confirm Data source is set to Microsoft SQL Server (SqlClient).

5.In the Server name textbox, enter (local)\sqlexpress.

6.In Log on to the server, choose your method of authentication.

7.In Select or enter a database name, expand the list of databases.

8.Select AdventureWorks.

9.Click the Test Connection button to confirm that you have connected to AdventureWorks successfully.

Note
With a successful connection, you can right-click the data connection icon for AdventureWorks and select New Query to invoke a Query Expression window if you want to try out queries against this data source.

To configure AdventureWorks to work with Web server controls
--------------------------------------------------------------------------------

1.Open a Visual Studio 2005 command window to run SQLCMD. You will use SQLCMD to grant access to the database and ASP.NET account.

On Windows Server 2003, the ASP.NET process used by the Web server control runs under NT AUTHORITY\NETWORK SERVICE. On other Windows operating systems, the process runs under MACHINENAME\ASPNET.

If you installed SQL Server Express 2005, type or copy the following SQLCMD below to grant login authority to the service. Otherwise, you must specify the SQL Server instance you want to use in place of (local)\sqlexpress.

The following example works for Windows Server 2003 and must have no line breaks.

Copysqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"
2.To grant access to AdventureWorks for this service, use the following command with no line breaks.

Copysqlcmd -E -S (local)\sqlexpress -d AdventureWorks -Q "sp_grantdbaccess N'NT AUTHORITY\NETWORK SERVICE'"
3.To add this service to the owner role account for AdventureWorks, use the following command with no line breaks.

Copysqlcmd -E -S (local)\sqlexpress -d AdventureWorks -Q "sp_addrolemember 'db_owner', N'NT AUTHORITY\NETWORK SERVICE'"
4.Close the command window.

5.You can confirm the configuration by successfully completing Walkthrough: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode.

change password remote desktop windows xp

2010-07-08T06:39:00.001-07:00

when in xp mode, can't use cntrl-alt-end.

Instead, go to cntrl panel, shared user names and passwords, and change it there.

Use mixture of upper/lower case and some numerics.

change password remote desktop windows xp

2010-07-08T05:52:00.000-07:00

Probably works for other OS versions

cntrl-alt-end

Change PATH or environment variables from eclipse java

2010-04-19T06:04:00.000-07:00

select project
go to project menu, select "properties"
select run/debug settings
select edit
select environmnet tab
select
select check off path
put in changes
select append environment to native environment
apply

Work

2010-01-24T19:53:00.000-08:00

1. Installing Subversion server from subversion.tigris.org
2. Subversion book available online
3. Created repository - svnadmin was in PATH environment variable but couldnt' execute command so changed to subversion/bin directory to execute.
4.

My Computer

2010-01-20T19:32:00.000-08:00

to get system on hp, hit cntrl-alt-s

Model #: a6614f
Product #: FK562AAR-ABA
Serial #: 3CW8391NNF
Software Build #: 84NAv6PrA3
Service ID #: 011-609
PCBRAND: Pavilion

My programming setup - what I need

2010-01-12T06:51:00.001-08:00

1. dual monitors, at least 21",

2. Comfortable high-back, leather chair - not an aerolon or other mesh-back imitator.

3. Nice set of monitor speakers.

4. Good keyboard - not too hard to press keys (slows me down). I prefer wired to wireless, as maybe it's just my cheap wireless equipment but sometimes it doesn't seem as responsive as wired.

5. Decent optical mouse - almost anything nowadays seems fine - I do remember back in the day having to open up the mouse and clean the crap off the innards.

6. Good printer within a few feet.

7. Good coffee making system nearby. By this I mean a setup with REAL milk, coffee that I can purchase and make rather than put up with company big pots.

8. Good lighting. I have a window, blinds, and 3 lamps in my room. Right now I don't need any lights - at night i might need 1 or 2, but from a particular direction. Sometimes I need the blinds to cut glare.

9. Well-stocked fridge. Doesn't need to be nearby - it IS good to get up and stretch your legs once in a while :)

10. Plants - for calming influence, and another excuse to get up and stretch your legs (they need misting).

11. A window, and natural light. Much less depressing. Also another good reason to stretch your legs (and back) - take a look outside once in a while.

12. Decent computer. Specs are meaningless, since they change all the time. Basically I go for a high-end system, selling at a medium system range cause it's refurbished from a big box store. People return systems to big box stores all the time, because of trivial reasons (they don't like the color, got it as a gift, etc. etc. - now they are used, basically all the cording has to be re-shrinkwrapped, but nothing is wrong with the system).

13. Headphones - for when the roommates are trying to sleep.

14. No one checking up on me :)

15. Telephone nearby. I have skype and cell.

Larry Watanabe's Blog

Why Process?

Netbeans API

SVN Import

Hibernate Notes

What to plan before starting development on a project?

How to delete a windows service

Glassfish no free port available port value out of range

Kamikaze Java

Zune - No installation Media

find Missing int - amazon question

amazon question find min diff in a list of int

Nesting Functions vs Intermediate Variables

Delete a Project from Team Foundation Server

Forcing DataGridView to Refresh when changed

You forgot to make it public, dummy!

2-valued boolean variable

DataGridView not Updating when DataSource modified

Never take notice of an error that you don't know how to handle

Tracking down bugs

Data Design or Procedure First?

Xml Serialization and Deserialization of Complex Objects/Lists

Changing SoundPlayer volume

CheckedListBox Mutual Exclusive Selection

Career Aptitude Tests - Nature vs. Nurture

Orange Peel Plant Food

Blues and Folk and Rap

Media Sync Problem on Blackberry

bizspark

Long Arrow and the Lost Amulet

I love Holloween

I could use a wish right now

Who you are

The Life you Chose

Heartless (Taylor I can't take no mo) .. VMA 2010

Heart of Mine

Way life is

Hack you Again

Wish I had your life

Peter Principle of Relationships

Session state can only be used when enableSessionState is set to true,

Don't you need someone to love?

sql server management studio prevent option off

report server canot decrypt symmetric key

Reporting Services keeps prompting for login

Reporting Services Report Parameters

Renaming web site in asp .net Visual Studio

Reporting Services

Will Lady Gaga and Miley determine the fate of the FB universe?.

Shai Woodley is in a relationship.

Ashley is bored

Shenae Grimes

Principle: Data Independence

Simple LINQ Join Query ASP .NET C#

it's not that there's no time like the present ... but that there *is* no time but the present.

Import Export Transport Save Data SQL Server 2005

Restarting/Stop/Start MS SQL Server

changing SQL server authentication mode

Publish/Deploy Web Site Visual Studio IIS

Resizing a window when bottom right corner is off-screen

Visual Studio Line Number - how to turn on

"I'm gong to delete myself!" -- common line on FB

selly

Shai (SHAE) Woodley ...

Love those shoes!

Brookelle is peeved

Tell me truly

Kate liked it

DropDownList SelectedIndexChanged not firing

New Facebook Account for Hanna Dakota Fanning

Alway use a reaching assist

Hierarchical Data Repeater Asp .NET

Finding a Good Relationship

FindControl - Repeater problem - can't find repeater in context

Repeater name does not exist in current context

linq multiple join

FB msg: Are you the REAL Elvis Presley?

Why do we love acting?

Getting the ASP .NET CheckBox Value

Visual Studio crashes on opening a solution .sln file

it's not that there's no time like the present ... but that there is no time but the present.