As I have posted before, my kids coloring site started as a Dutch site. After working on it for about half a year I decided to make a dot.com version of it, to look how long it will take to have some visitors from outside Holland and Belgium.
I'll keep you posted!
So take a look at Kids-n-Fun.com. You will find printable coloring pages of Cars, Fifi and the Flowertots, Winx club, Dora the Explorer, the Zoo, and loads and loads more...
Take a look at Kids-n-Fun.com.
Thursday, December 28, 2006
Coloring pages Happy Feet
When a new (animation) movie becomes a hit, it still takes a few weeks before the first printable coloring pages to arrive. Well here they are, coloring pages of the funny penguins, starring in the movie. Have fun!
Tuesday, December 26, 2006
Static Url's
Somewhere in may 2006 I started this site to see how long it would take to get some visitors. Well, on Christmas day there where over 1200 visitors, looking at 9000 pages. The funny thing is that I don't have a page rank in Google (lack of links pointing to my site), and dynamic pages.
Since a couple of days I am using IsapiRewrite, changed the code and now: Static urls.
I wonder how long it will take before Google picks up this new url's and if it have some (positive) effect on the number of visitors.
Since a couple of days I am using IsapiRewrite, changed the code and now: Static urls.
I wonder how long it will take before Google picks up this new url's and if it have some (positive) effect on the number of visitors.
Sunday, December 17, 2006
Go Diego, Go
Looking in Google Analytics, I discovered some visitors looking for coloring pages of Diego. I thought they looked for Diego from the movie Ice Age, but I thought they ment Diego, the nephew of Dora the Explorer. So I have added some printable coloring pages of Diego. Have fun!
Thursday, December 07, 2006
Fifi and the flowertots
I live in Holland and Fifi started just a few month ago. This tv-serie is the girl-version of Bob the Builder. I looked for coloring pages of Fifi in Holland, but didn't find anything. I found a couple on the Internet, so if you are looking for Fifi and the Flowertots coloring pages, look here and you will find 19 (!) pages.
Monday, December 04, 2006
Query: number of rows SQL Server
There is a fast and easy way to determine the number of rows in a table. Instead of using queries like:
Select COUNT(*) from tablename
where it is necessary to use the datatable, you can use the systemtable:
SELECT rows
FROM sys.sysindexes
WHERE (id = OBJECT_ID('tablename'))
AND (name = 'PrimaryKey name').
This is very fast, because you select only one row.
Select COUNT(*) from tablename
where it is necessary to use the datatable, you can use the systemtable:
SELECT rows
FROM sys.sysindexes
WHERE (id = OBJECT_ID('tablename'))
AND (name = 'PrimaryKey name').
This is very fast, because you select only one row.
Saturday, November 25, 2006
Print web page: Hide content
I discovered some kind of a bug in ASP.NET 2.0...
First things first. On my "web coloring page" are some Google ads. I don't want to show these ads on the prints.
Start with some css at in the <head> tag of the web page:
<style type="text/css" media="print">
.donotprint{Display : none}
.doprint{Display: normal}
</style>
Then create a table. For each <td> you choose the between the classes doprint and .donotprint.
I have tried this with <div> tags, but that did not work; All content after using the .donotprint class was invisible, even after using the .d.oprint class with the next <div> tag. Very strange...
But it works with tables.
First things first. On my "web coloring page" are some Google ads. I don't want to show these ads on the prints.
Start with some css at in the <head> tag of the web page:
<style type="text/css" media="print">
.donotprint{Display : none}
.doprint{Display: normal}
</style>
Then create a table. For each <td> you choose the between the classes doprint and .donotprint.
I have tried this with <div> tags, but that did not work; All content after using the .donotprint class was invisible, even after using the .d.oprint class with the next <div> tag. Very strange...
But it works with tables.
Most popular coloring pages
At this moment, the most popular coloring page is a page from the movie Cars (Pixar): Lightning McQueen, printed more than 600 times in November.
Look here for more Cars coloring pages
Look here for more Cars coloring pages
Google bot
I started my website Kids-n-Fun in may, 2006. It took Google months before my site was visited. In October 2006 the visitors went up from a few (5 to 10 per day) reaching more than 600 at the end of the month.
The number of pages the Google robot visited went up from 100 pages per day to 1200 pages at the end of October.
Look at this graph (from Google Site maps):
My question: What happened first: the increase of visitors or the increase of crawled pages by the Google search robot.
If it is the increase of visitors, how does Google know this, and if it is the Google robot, why waiting for 4 months to really start indexing the pages on my site?
Anybody?
The number of pages the Google robot visited went up from 100 pages per day to 1200 pages at the end of October.
Look at this graph (from Google Site maps):
My question: What happened first: the increase of visitors or the increase of crawled pages by the Google search robot.
If it is the increase of visitors, how does Google know this, and if it is the Google robot, why waiting for 4 months to really start indexing the pages on my site?
Anybody?
Wednesday, October 18, 2006
Create 302 response after moving page
After moving a webpage to another location on your webserver, search engines try to search this page a several times. To avoid this you have to tell the robot that the location is changed, by creating a 302 response:
Response.StatusCode = 302
Response.RedirectLocation = url
Thats all, problem solved.
Response.StatusCode = 302
Response.RedirectLocation = url
Thats all, problem solved.
Wednesday, October 04, 2006
Passing parameters from form to query
I didn't use this idea for my website, but I think it is a very usefull tip voor the MS Access developers among us.
This solution passes values from a MS Access form to a query without defining parameters in de query.
Create an global array:
Global Params(10)
Create a function that returns a value from
Function RtnParams(ParamNum As Integer)
ReturnParam = Para=ms(ParamNum)
End Function
Somewhere in the form (click event button for example) store the values into the array
Params(1) = txtId (from field)
Call in the WHERE-clause of the query the function which returns the right value:
Select * FROM table
WHERE id = ReturnParams(1)
Simple and effective, yet again.
This solution passes values from a MS Access form to a query without defining parameters in de query.
Create an global array:
Global Params(10)
Create a function that returns a value from
Function RtnParams(ParamNum As Integer)
ReturnParam = Para=ms(ParamNum)
End Function
Somewhere in the form (click event button for example) store the values into the array
Params(1) = txtId (from field)
Call in the WHERE-clause of the query the function which returns the right value:
Select * FROM table
WHERE id = ReturnParams(1)
Simple and effective, yet again.
Sunday, October 01, 2006
Dynamically add webusercontrol to webform
On a few pages I dynamically add webusercontrols to a webform. It's very easy.
Drag a panel on your webform, name is default, panel1.
Make a webusercontrol in the directory "webcontrols" in your project, and name it wucmyControl.ascx, for example.
Then use this code in the load event of the form:
Dim myControl = LoadControl("~/webcontrols/wucmyControl.ascx")
'assign a value to the properties of the webcontrol
myControl.property1 = "any value"
myControl.property2 = "any value"
' add the control to the panel control
Panel1.Controls.Add(ThemaControl)
Done!
Drag a panel on your webform, name is default, panel1.
Make a webusercontrol in the directory "webcontrols" in your project, and name it wucmyControl.ascx, for example.
Then use this code in the load event of the form:
Dim myControl = LoadControl("~/webcontrols/wucmyControl.ascx")
'assign a value to the properties of the webcontrol
myControl.property1 = "any value"
myControl.property2 = "any value"
' add the control to the panel control
Panel1.Controls.Add(ThemaControl)
Done!
Using ObjectDataSource in code
There is an easy way to use a objectdatasource in VB.Net code. Drag an objectdatasource control on your webform.
Then, in the page load event, use the following code:
Dim mySource As ObjectDataSource = ObjectDataSource1
Dim result As IEnumerable = mySource.Select()
Dim row As DataRowView
For Each row In result
'your code here
'you can acces any field in a row:
' myString = row("table field name")
Next
Then, in the page load event, use the following code:
Dim mySource As ObjectDataSource = ObjectDataSource1
Dim result As IEnumerable = mySource.Select()
Dim row As DataRowView
For Each row In result
'your code here
'you can acces any field in a row:
' myString = row("table field name")
Next
Coloring pages Open Season
This new animation movie Open Season shows in cinemas in Holland next week. I am looking for coloring pages of this movie.
Can anyone please help me?
Thanx!
Can anyone please help me?
Thanx!
Saturday, September 30, 2006
Google Analytics
It's possible to use Google Analytics for analyzing the traffic onyour blog. Just add a HTML/Javascript page element on your page en paste the javascript Google generates in it. Best is it to put it somewhere at the bottom of your page. It gives great insight in the traffic and it's free.
Look here for Google Analytics.
Look here for Google Analytics.
Friday, September 29, 2006
Query Select random row
I was looking for a way to select a random row from a table, preferably in a stored procedure.
This is the query:
SELECT TOP (1) *
FROM table
ORDER BY NEWID()
Simple and effective!
This is the query:
SELECT TOP (1) *
FROM table
ORDER BY NEWID()
Simple and effective!
Google adsense and changes in content
The number of visitors on my site is slowly increasing, so is the number of clicks on the Google ads. Problem is that the number of hits is growing faster than the number of clicks on the ads.
The main reason, I think, is my own content, so I changed the text a little. Google adsense doesn't react immediately, it will take 1 to 2 weeks voor Google to react on the changes.
More info: Google adsense
The main reason, I think, is my own content, so I changed the text a little. Google adsense doesn't react immediately, it will take 1 to 2 weeks voor Google to react on the changes.
More info: Google adsense
Coloring pages Cars (Pixar)
I discovered that where just a few good links available with coloring pages of Cars, the new Pixar animation movie.
So I added a few to Kids-n-Fun. So look
here for the coloring pages of Cars!
So I added a few to Kids-n-Fun. So look
here for the coloring pages of Cars!
Create Dynamic headers in ASP.NET 2.0
Kids-n-Fun is a dynamic site. All content is stored in a database. I have some code (VB.Net) to create the content tags in the header dynamically.
If you using a Masterpage use this in the load event:
Dim myPage as new Page
Dim myHTMLHead as new HtmlHead
Dim myHTMLMeta as new HTMLMeta
myPage = thisPage
myHTMLHead =CType(myPage.Master.FindControl("MasterHeader"), HtmlHead)
myHTMLMeta.Name = "description"
myHTMLMeta.Content = "your description"
myHTMLHead.Controls.Add(myHTMLMeta)
myHTMLMeta.Name = "keywords"
myHTMLMeta.Content = "your keywords"
myHTMLHead.Controls.Add(myHTMLMeta)
If you don't use master pages (you should!) use this code instead:
myHTMLHead=CType(myPage.Header, HtmlHead)
The rest of the code is the same.
If you using a Masterpage use this in the load event:
Dim myPage as new Page
Dim myHTMLHead as new HtmlHead
Dim myHTMLMeta as new HTMLMeta
myPage = thisPage
myHTMLHead =CType(myPage.Master.FindControl("MasterHeader"), HtmlHead)
myHTMLMeta.Name = "description"
myHTMLMeta.Content = "your description"
myHTMLHead.Controls.Add(myHTMLMeta)
myHTMLMeta.Name = "keywords"
myHTMLMeta.Content = "your keywords"
myHTMLHead.Controls.Add(myHTMLMeta)
If you don't use master pages (you should!) use this code instead:
myHTMLHead=CType(myPage.Header, HtmlHead)
The rest of the code is the same.
First blog
Well, welcome to my blog. I have created this blog to write about my experiences creating a brand new website Kids-n-Fun. This blog is about the things I discover along the way, about content, ASP.Net 2.0, search engine optimalisation, Google Adsense and so on.
Kids-n-Fun is a (dutch) website for kids. I have started with coloring pages, and create much more the coming winter. Pages voor crafts, recipes kids can make themselves. After that there will be a special corner voor parents, but more about that in the near future.
Enjoy!
Kids-n-Fun is a (dutch) website for kids. I have started with coloring pages, and create much more the coming winter. Pages voor crafts, recipes kids can make themselves. After that there will be a special corner voor parents, but more about that in the near future.
Enjoy!
Subscribe to:
Posts (Atom)