Create report using Jasper report (part 2)

I wrote a part of this subject Create report using Jasper report (part 1) about 2 months ago.Excuse me i wrote it by vietnamse lang .for a long time i didn't come back now i wanna write an article guide you guys to use sub-report by using Jasper report in java but now it's 11h41 pm.too late my moon will kill me. there's quick way.sorry me if you cannot read clear because my english is not good.i wanna to improve it by write some english articles

Hope this help

Unable to convert MySQL date/time value to System.DateTime

My database have a column named update_link, datetime type, that constants a row with zero value(0000-00-00 00:00:00). Then each times i try to select row i got this.

This's a solution: add "allow zero datetime" to you connection string

String conn = "SERVER=127.0.0.1;DATABASE=MoodleService;UID=root;PASSWORD=123456";allow zero datetim=true;

Hope this helps

PS: This's first time i writed an article by english, there're some stupid paragraph becuz my english is not good,please tell if you canot understand ^^

Connect to MySql using c#

This's first time i writed an article by english, there're some stupid paragraph becuz my english is not good
I'm new in c#, i stared learning about 2 mouths ago.Now i wanna to share some tips i learned.Let's start
Likes the title, very simple so i got a trouble when trying connect to mysql without mysql driver.i spent a night to solve.

First go to http://dev.mysql.com/downloads/connector/net/#downloads to download last version. Before installing, go to folder root\MySQL\MySQL Connector Net 5.0.9\Binaries\.NET 2.0,you will see a file named: MySql.Data.dll that is mysql driver. Or you can download from my direct link Mysql.Data.dll

open Visual Studio, do following

choose browse tab

code:

import MySql.Data.MySqlClient

Boolean rs = false;

String conn = "SERVER=127.0.0.1;DATABASE=MoodleService;UID=root;PASSWORD=123456";

String sql = "select * from links where link_id = 1";

MySqlConnection conn = new MySqlConnection(conn);

MySqlCommand command = new MySqlCommand(sql);

conn.Open();

try{

cmmand.ExecuteNonQuery();

}

catch(Exception ex)

{

rs = true;

}

Console.WriteLine(rs==true ? "Execute success":"Execute failed");

Console.ReadLine();

Hope this help

What is PageRank ?

PageRank, or PR, is a numeric value that Google places on how important a page is on the Web. PageRank is determined by how many incoming links there are to a page. Google figures that when one page links to another page, it is in effect “casting a vote” for the importance of the other page. The more incoming links (votes) there are for a page, the more important the page is to Google, generally speaking.

Many people obsess and over-hype the importance PageRank and therefore introduce worry and confusion that is not warranted. It is but a single factor in the overall ranking algorithm. This may be because it is the only part of the Google ranking algorithm that is made public – well sort of.

You can see what the “public” PR value of a page is in the Google Toolbar:

PageRank vs. Search Result Ranking

Some people confuse Google PageRank (PR) with their page’s ranking for a certain search result for a certain keyword. Google PR is just one factor that is used to determine your page’s actual rank (position or placement) on a search results page for a given search query.

It is not uncommon to see a page with a lower PageRank value that is positioned higher on a search results page than a page with a higher PageRank. This shows that PageRank is not the most important factor in Google’s ranking algorithm. A properly keyword-optimized site with a lower PageRank can outrank a non-optimized site with a higher PageRank.

This is a common scenario for large corporate sites. The corporate site may have a high PageRank as a result of the large number of other sites that link to it, but they end up being outranked due to their lack of keyword optimization for their pages.

Choosing a Profitable Niche

It might seem weird, but at first I didn’t use any software to find
profitable niches based on keywords.   Initially, I had purchased
hundreds of templates from a well-known AdSense master (Joel
Comm).  He was selling a package called http://www.hypervre.com/InstantAdsenseTemplates/ (aka IAT).

His templates were based on popular niches that were previously
researched by him and his ‘team’.  So initially that saved me the hassle of trying to find good niches myself.

I started to constantly track my AdSense earnings, and realized
that many of those niches were not paying me.  In fact I was losing
money on several of those niches.

On careful examination, I started to see some trends.  I saw that
some niches (and their sub-niches) were always profitable, and some
were never profitable.  I decided to eliminate the non-profitable sites, and create more sites focusing on the ones making me money.

So I searched the net and downloaded some pre-made profitable
keyword lists and consolidated all of them.  I then categorized them
based on my previous findings of which sites were profitable and
which were not.

I should add here that whichever tool I use for my niche research, I
can never be 100% sure whether the niches I have selected will be
profitable or not.  If I do my keyword research properly, I definitely
have better chances of hitting good niches.  BUT my earnings depend on Google – and their ‘Smart Pricing’ strategy often pays very low, even for the “highly profitable” niches. I can never know for sure until I make my sites and constantly monitor them.

Since I initially purchased the IAT package from Joel Comm, I had a
large group of ‘popular ideas’ for sites with templates and articles.
There were around 300 different ones.

With HyperVRE, I built all these sites and waited to see if they were
giving me profits or not (more on this later).  As I mentioned above, I had to remove some of the niches because they were not profitable, and I was losing money on them.  I ended up removing about 100 sites that were wasting my money, so I was left with about 200 good ones.

So you see, at the beginning I never got a chance to actually “select”
my niches from scratch, as the initial niches were already provided to
me.   That is, I never actually went out and researched the niches
myself – at the start.

Again as mentioned earlier, when I analyzed the sites that were making me money, I started to see some trends in the kinds of sites that paid well, and the kinds of sites that did not pay so well.

That’s when I started some keyword research.  I then used some
keyword lists found on the net, and also the Top 40K Keyword list
that’s in the gold member’s area at the HyperVRE site.
There were a few things that I would look for when trying to predict
if a niche was going to be profitable or not.  Notice I said “predict”.
Like I said before, you don’t know for sure until you try it out.  If it
doesn’t end up being profitable, then scratch it and move on to the
next niche.

I look for some important metrics in doing my Keyword research.  I
look at the average CPC, number of ads for that keyword,
and number of searches in a month. Unfortunately, since I did
not originally use a keyword research tool, I did not always have all
these metrics at my disposal.

I recently acquired Keyword Elite, and I plan to use that for
researching many other profitable niche markets in the coming weeks, as it will show me ALL of these metrics mentioned above, and supposedly a whole lot more.  :-)

So, I consolidated all these gathered lists into one big file.  I then
categorized the keywords into their respective main categories.
Interestingly, I found that the categories I had selected out of my 300 sites and the categories I found from the keyword lists were very, very similar.

I then further categorized these profitable main categories into sub-
categories.  For example, the category Finance was sub-categorized
into Loan, and Loan was further categorized into Auto Loan and Education Loan.

See below for a short schematic…
-Finance
---Loan
------Auto Loan
------Education Loan
------etc.
------etc.
.
-Mortgage
---FHA Mortgage
---Mortgage Refinance
---etc.
---etc.
-Law
---Attorney
------Mesothelioma Attorney
------Divorce Attorney
------etc.
------etc.

Hope you get the picture.
After doing all of this, I came up with ideas for hundreds of other
sites that I could then start working on.  Which ones will actually be
profitable, I still have to check that out.

I know this is a non-conventional way of doing things. But because of my original limited resources (at the time, a lack of a good
keyword/niche tool), this was the best I could do.  And honestly, it
seems to be working pretty well for me.

Once I decided on the niches to focus on, I moved on to the process
of building my sites.