Tuesday, May 09, 2006

Some Code Differences Between WebDemo and KD Test Google Map Site

In our production environment, I created a table in our database to store geocodes for each country capitals rather than constructing xml data file on the fly. The system will first go to our database table and check if there exists a record for the country capital. If so, merge it with counting records; otherwise, it jumps out onto the internet and retrieves the geocode from Yahoo geocoding service, finishes merging process and then insert back to database table.

Here is complete version of the codes:

private void MergeDataAll(XmlTextWriter objX, SqlDataReader dr)
MapDataAccess da = new MapDataAccess(Global.CONNSTRING);
SqlDataReader drG;

GoogleAddress ga = new GoogleAddress();
MapData md = new MapData();

string strC = "";
strC = dr["ADR1_COUNTRY"].ToString();
drG = da.GetCCGeocode(strC,MapData.Capital(strC).Trim());

if ((drG.HasRows)&&(drG["Lat"].ToString() != "")&&(drG["Lng"].ToString()!= ""))
objX.WriteAttributeString("lat", drG["Lat"].ToString());
objX.WriteAttributeString("title", strC);
objX.WriteAttributeString("message", dr["CountryTotal"].ToString());
md.SetGeocodesEach(strC, MapData.Capital(strC).Trim());
if ((ga.Latitude != 0) && (ga.Longitude != 0))
objX.WriteAttributeString("lat", ga.Latitude.ToString());
objX.WriteAttributeString("title", strC);
objX.WriteAttributeString("message", dr["CountryTotal"].ToString());
//Insert lat and lng into database.
if (MapData.Capital(strC).Trim() != "")

Our table is called CCGeocode and there are only four fields: Country, Capital, Lat and Lng. Here is the code snippet that makes use of Microsoft applicationblocks to insert:

public bool InsertCCGeocode(string strCountry, string strCity, string strLat, string strLng)
string queryString="Insert Into CCGeocode";
queryString += " (Country, Capital, Lat, Lng)";
queryString += " values ('"+strCountry+"', '"+strCity+"', '" +strLat+"', '"+strLng+"')";
bool success=false;
SqlCommand myCommand=new SqlCommand(queryString, conn);
int rows = myCommand.ExecuteNonQuery();
if (rows > 0)
return success;

To download a WebDemo project, please visit:
To see an active Google Map:

Thursday, March 02, 2006

Breeze Meeting Connection Errors

Here are a list of all of our user's description about the connection error when they tried to connect to Breeze Meeting:

"I am unable to connect for the last 5 minutes. The screen is stuck at "Breeze Meeting" connecting...".

"I am having trouble connecting to Breeze chat. It says loading breeze and then it freezes after that green status lines finishes loading. I will try restarting my computer."

"I'm having problems joining the chat. There are script errors."

"Still unable to connect. The connection times out after I enter my name - so I'm getting through partially. I have never seen this issue before."

"I cannot connect. I tried from 2 computer and I get the same error. it says connecting but nothing happens. The URL says " https://breeze.kd.iu.edu/kdchat?launcher=false"
After I enter as guest it loads breeze and then nothing happens."

"It's 2:15 pm now and I still can't get into the room. The Breeze is trying to connect the meeting... "

" I tried this and it still does not seem to log me in. Are others experiencing the same problem? " ---- User was asked to try copying the URL and pasting into a new browser.

"No luck. I tried everything, including restarting computer and cable modem. I'll continue trying for a few more minutes then give up."

"I am getting the following error when trying to connect:
Connection: Timed Out
server: rtmp://breeze.kd.iu.edu:1935/?rtmp://bl-bus-kdbreeze:1935/,rtmpt://breeze.kd.iu.edu:443/?rtmp://bl-bus-kdbreeze:1935/ "

We use Windows 2003 Server, SQL Server 2000 SP4, Firewall is on, SSL installed, NT authentication, TWO NIC associated with Breeze server with two IP addresses.

Thanks for reading and suggestions.

Tuesday, February 28, 2006

Object reference not set to an instance of an object

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
KD.Admin.Web.ListKDToolsAllSemesters.OnInit(EventArgs e)
System.Web.UI.Control.InitRecursive(Control namingContainer) +233
System.Web.UI.Page.ProcessRequestMain() +197

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

I spent almost 2 hours to check and debug the error. It turned out that our project deployment was not updated. If I tell you why the error was generated, you might get shocked. The aspx file version is not updated or the old copy of the ListKDToolsAllSemesters.aspx was deployed rather than a latest one!!!!! Enjoy the fun and sadness of the computer world!!!

Thursday, February 23, 2006

Live Web Cams | Free Web Cam

For those of you who are tired of static images, dull pictures, here is good news. Confabulator.com provides a downloadabe free web cam software from which you could view live web cam show ranging from traffic information to city scenary, from outdoor to computer chips. You could also see who is getting married, who is in hairdreser. You could also see Carribean Cruise route even before your real travel. You could also see spotlights at Disney World, skiing resort all over the world. All are totally free web cam show provided by web cam fans like you and me.

This is in fact a hot widgets created by Konfabulator.com(website url is confabulator.com) and bought by Yahoo later on and became Yahoo Widgets site. A little note is if you type Konfabulator.com, you will be redirected to Yahoo's widgets site. There are a large variety of widgets you could choose from. Fun and Games, Date and Time, News Feeds, Sight and Sound, Geek Stuff and much more. If you like, you could even contribute your version of widget and upload into the gallary.

I downloaded Cam Viewers which provide real time pictures taken from different cities from Canada. I also installed traffic widget to monitor local live traffic information. I would like to say pictures are now real clear and sometimes, it might not provide any feed at all.

Web cam chat nowadays become more and more hot in dating, and language learning. People could just sign in, set up a earphone set, you then could view and chat with anyone you like. You could also select your language chat partner through several websites to improve your langauge skills such as skype.com, xLingo.com, ESL Online Talk, English Learn.

One of another hot web cam application is home web cam for parents to monitor their kids or just for purpose of taking a look of your favourite pets, or for security's reason. A recent breaking news is some crimes happened through web am site myspace.com. People grabbed the young girls address and physically visit and assault the girls. To set up, it's pretty easy; you could choose creative web cam, or logitech web cam or yahoo web cam.

You could even become an online star by creating your own version of video show and post it on podcasting site and earn some extra money. The hottest business still sits on the adult business. If you search with phrases like "web cam girl", "adult web cam chat", "teen web cam", "adult web cam", "amateur web cam", the returned results might shock you. Be cautious here.

Thursday, February 02, 2006

Auto Refresh Content | Access No Cached Data

The following code snippet is Javascript on the client to directly access data without caching.
var request = GXmlHttp.create();
var url = "AlumData.aspx?RandomKey=" + Math.random() * Date.parse(new Date());
request.open('GET', url, true);
request.onreadystatechange = function() {
if (request.readyState == 4) {
var xmlDoc = request.responseXML;
var markers = xmlDoc.documentElement.getElementsByTagName("marker");
for (var i = 0; i < markers.length; i++) {
var point = new GPoint(parseFloat(markers[i].getAttribute("lng")),
var info = "" + markers[i].getAttribute("title") + "
info += "My Message: " + markers[i].getAttribute("message");
var marker = new createMarker(point, info);
To see the page in action, you could visit:

Note: the pages could be removed at any time.

Monday, January 23, 2006

Google Map Dynamic Data Generated from SQL Database C# .Net Codebehind

Definition of MapDataAccess class with method GetGeoCodesCountry:

public class MapDataAccess
private SqlConnection conn;

public MapDataAccess()
this.conn = new SqlConnection(Global.CMCONNSTRING);

public SqlDataReader GetGeoCodesCountry(string strCountry)

string queryString="SELECT *";
queryString += " FROM People where ADR1_COUNTRY='" + strCountry + "' order by lname";

return SqlHelper.ExecuteReader(conn, CommandType.Text, queryString);


Code behind codes that returns Google Map data xml file. You could pass back Session["CountryCode"] by set up a postback event on dropdownlist from client:

private void Page_Load(object sender, System.EventArgs e)
MapDataAccess da = new MapDataAccess();
SqlDataReader dr;
string strCountry = Session["CountryCode"].ToString();
dr = da.GetGeoCodesCountry(strCountry);

Response.ContentType = "text/xml";
XmlTextWriter objX = new XmlTextWriter(Response.OutputStream, System.Text.Encoding.UTF8);

if ((dr["LATTITUDE"].ToString() != "")&&(dr["LONGITUDE"].ToString()!=""))
objX.WriteAttributeString("lat", dr["LATTITUDE"].ToString());


Note: These are not complete list of my original codes, please make necessary changes according to your situation.

Monday, January 02, 2006

web site submission

Url Submission Net-submit Your Site To 66 Search Engines
Submit your url to 66 search engines and directories. Search engine optimization tips are provided for high ranking.

Bonin's Resources
A web directory of business, resources, shopping, sports and much more!

Cadastro Em Sites De Busca
Top website promoter, promotion, marketing, ranking and seo.

Charleston Web Design, Web Hosting, And Search Engine Optimization
Palmettosoft is a website design, web hosting and search engine optimization company based in charleston, sc. Specializing in custom programming, website design, web hosting, search engine marketing, flash, domains, corporate identity and print.

12dailypro Tactics
Join 12dailypro through my link, and get a free website to promote with!

Cadastro Em Sites De Busca
Top professional website promoter, ranking, marketing and seo

Optimize Your Website
Promote your website by getting a higher search engine ranking.

#1 Free Link Exchange Directory On The Web - Link Market
Have you ever tried to exchange links, swap links, or trade links? Was it hard? Use link market instead; - it is easy to use, free and very smart. It will save you hours of work.

Template Affiliate Program
You can make from 5 to 35% in commission on every sale you refer from your web site.

teacher web site

London International School Of E-learning
1700+ courses. Advanced learning experience,24/7 instant mentor. Cisco, a+, network+, programming, web design or mcse for $64. 99. Business admin, projet management for $32. 99. Register now, start now. 3 days refund policy. 99% success rate at exam

free music download web site | video | VOIP

Video Production And Web Design Services
Professional video production services uk. Services include filming, digital video editing, dvd authoring and streaming video conversion as well as web site design and media integration.

Template Shop
Professionally designed html and flash templates for your web project.

Skype - Skype Video - Business Voip Service Provider - Skype Voip
Free videos on learning everything you could possibly want to know about skype

Terrasip Voip, The Home Of Vowlan
Terrasip, vowlan (voice over wlan)community, sip, wifi, cheapest voip tarriffs for 56 countries, apply online, free membership, 40 percent savings compared with skype, no computer required, all rates apply worldwide, independent of your location.

Rss Web Site

Rss Feeds 4u A Human Edited Rss Feed, Blog And Podcast Directory.
A directory of rss feeds from around the world. As well as offering free submission to the rss feeds directory, rss feeds 4u offer advice to web designers, internet marketing consultants and everyday computer users on how they can best use rss feeds.

Create a Web Site | Ranking

Free Ranking Counter
Ranking counter is a free service that will show you the google pagerank on your website. You will receive your code in an email when you sign up. You will then have to click on the code or copy and paste it into your browser.

Build a Web Site | Hosting

Web Hosting Directory
Web hosting directory review your current cheap web hosting company. Find cheap web hosting available for coldfusion, windows, linux and adult web hosting. Including dedicated servers, reseller accounts and virtual private dedicated servers.

Alojamiento Web
Praktonhost - servicio profesional de alojamiento web, professional hosting services.

Usa Webhosting
Usa webhosting, professional website hosting solutions and services. Usa webhosting is a pa web hosting company and we are committed to providing you awith high-quality, low cost web hosting. We have awesome features that you won't find even on more

Reseller Hosting
Reseller hosting, dedicated servers, virtual webhosting and website hosting!

Flizard Technologies Web Hosting Solutions - Reliable Managed Host
Powerful & affordable managed web hosting solutions. Starting at $5. 95 cad per month you get the best service and support. Come check out our plans and compare. Have questions, email us or call us at 1-800-598-6934. 30 day money back guarantee.

Small Business web Site Design

Carpet Cleaners, Carpet Cleaning Company, Carpet Cleaning Service
We offer three cleaning professional website packages that and can be afforded on any budget. We offer both templated and custom built websites. We offer the only free carpet cleaners directory in the business. Over 20,000 individuals looking for ca

Søgemaskine Optimering Søgemaskineoptimering Seo Ppc Rss Xml Sem
Abcdesign a/s er siden 1983 udbyder af business building, traffic building, internet markedsføring, søgemaskine optimering, seo, xml, rss, blog building, link building, brand building, community building, overture og adwords, adsense, yahoo & google.

Custom Website Designs
Affordable custom website designs for ecommerce, small business, corporate, real estate, mortgage, medical, church, and wedding. Find a website designer in your area.

Web Site Layout Design

Flash Templates - Website Templates
Professionally designed flash templates, website templates, flash intros, swish themes, php-bb skins, corporate and oscommerce templates.

Web Design Professional, custom website design and graphic design services by matt martin of grants pass, oregon.

Free Animations And 3d Signs
Free animations and 3d signs. Tons of original creations plus an archive of graphics. Great for your web pages.

Find Discount/cheap Books, Used College Textbooks, Medical Books
Compare book prices at 110 bookstores for cheap books on business, home design,art computer software, travel, shopping,interne health,internet,web design, hosting,gift, jewelry,writer,medical,clothing,electronics,directories, consumer, and education.

Offering online design and printing services including business card, logo, postcard, newsletter and web design.

Custom Web Design
Custom web design service in virginia, usa. Providing professional custom web design to all business industries nationwide. Get a free no-obligation web design quote today!