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!