Archives

Archives / 2008 / May
  • ADO.NET Data Services in.NET 3.5 SP1 Beta1

    I started working on an example using the ADO.NET Data Services (formerly Astoria) in .NET 3.5 SP!.  ADO.NET Data Services uses the Entity Framework to expose data to clients in a restful manner.  Its ideally suited to data access over ajax clients.  For some reason, my sample wouldn't completely run.  I could query and delete, but no inserty or updatey action would work.  The error messages I got were crap merely saying that the operation failed.  What good are those messages?  I posted some messages and I decided to contact Pablo Castro about the issue.  Pablo was his usual helpful self.  He gave me a bunch of suggestions.  I went through them and it looked like I needed to have the VJ# redistributable installed.  I then mucked up my VPC session.  I went back and started from the beginning with a fresh VPC.  I installed VJ# redistributable, .NET 3.5 SP1 beta1, Sql Express Management Studio, and voila, I got meaningful error messages finally.  With the meaningful error messages, it was cake to fix the updatey problem.  The inserty problem magically resolved itself.  All was right with the world.  Expect a video podcast on this topic shortly along with source code examples and things that tripped me up in the process..

  • Pictures from Recent Events (Western Michigan Day of .NET & User Group talk in California, MD)

    I wanted to post some of the pictures that I took at the events that I have been to in the past week.  They are:

    Western Michigan Day of .NET: http://aspnetpodcast.com/CS11/photos/random_pics/tags/Western+Michigan+Day+of+.NET/default.aspx

    California, MD User Group Talk: http://aspnetpodcast.com/CS11/photos/random_pics/tags/California+Maryland/default.aspx

  • Follow me on Twitter

    As if we don't have enough things that waste our time, follow my comments about life and things upto 140 characters on twitter.  My twitter url is http://twitter.com/wbm and enjoy.

    PS.  If you follow me, I'll follow you, assuming you aren't a twitter spammer.

  • ASP.NET Podcast Show #112 - Intro to ASP.NET AJAX

    Original Url: http://aspnetpodcast.com/CS11/blogs/asp.net_podcast/archive/2008/05/07/asp-net-podcast-show-112-intro-to-asp-net-ajax.aspx

    Subscribe to everything <---- This is what the cool kids are doing.

    Subscribe to WMV.

    Subscribe to MP4/M4V.

    Subscribe to MP3

    Download WMV.

    Download M4V.

    Download MP3.

    Show Notes:

  • ASP.NET Podcast Show #111 - ASP.NET AJAX with Virtual Earth

    Original url: http://aspnetpodcast.com/CS11/blogs/asp.net_podcast/archive/2008/05/05/asp-net-podcast-show-111-asp-net-ajax-with-virtual-earth.aspx

    Subscribe.ASP.NET AJAX with Virtual Earth <-- Everybody needs some, how about you!

    Download WMV - Video for PC.

    Download M4V - Video for iPod.

    Download MP3 - Audio only.

    Show Notes:

    • Upcoming events.
    • URLs of importance, so important that your life depends on them.
    • Mapping with Virtual Earth.
    • Web Services.
    • Client Script.

    Source Code:

    Master Page:

    <%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><head runat="server">    <title>ASP.NET Podcast Mapping Page</title>    <asp:ContentPlaceHolder id="head" runat="server">    </asp:ContentPlaceHolder>    <script src="http://maps.google.com/maps?file=api&amp;v=2.x&amp;key=ABQIAAAA_mrKwezGRvHyiI2zD3-QjxQyvuBphQwgXhP_kHK6Ww2QlMKTbxQ3mY6sQnMU6V5PMK8wQzOfhkt_Vw" language="javascript" type="text/javascript"></script>    <script type="text/javascript" src="http://dev.virtualearth.net/mapcontrol/mapcontrol.ashx?v=6.1"></script> </head><body onunload="GUnload()">    <form id="form1" runat="server">    <asp:ScriptManager ID="sm" runat="server">        <Services>            <asp:ServiceReference Path="~/GetMapData.asmx" />        </Services>    </asp:ScriptManager>    <div>        <asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">                </asp:ContentPlaceHolder>    </div>    </form></body>

    </html>

     

    ASP.NET Page:

     <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Live_Default" Title="Virtual Earth Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><div id="MapDiv" style="position:relative; width:450px; height: 350px;" ></div><br /><div id="MapInfo"></div> <script language="javascript" type="text/javascript">var Map;function pageLoad(){    GetMapData.MapData(SetupMap);}   function SetupMap(result){    var Lat = result.Center.Lat;    var Lon = result.Center.Lon;    var ZoomLevel = result.ZoomLevel;    var MapView, TopLeft, BottomRight;    Map = new VEMap('MapDiv');    Map.LoadMap(new VELatLong(Lat, Lon), ZoomLevel ,'h' ,false);    MapView = Map.GetMapView();    TopLeft = MapView.TopLeftLatLong;    BottomRight = MapView.BottomRightLatLong;    //TopleftLatLong and BottomRightLatLong return a VELatLong object.    Map.AttachEvent("onchangeview", MapChangedView);    GetMapData.GetPointData(10, TopLeft.Latitude, TopLeft.Longitude,        BottomRight.Latitude, BottomRight.Longitude, GetDataSuccess);}function GetDataSuccess(result){    var i = 0;    var Lat, Lon;    $get("MapInfo").innerHTML = "";    for(i=0;i<result.length;i++)    {        Lat = result[i].Location.Lat;        Lon = result[i].Location.Lon;        var shape = new VEShape(VEShapeType.Pushpin, new VELatLong(Lat, Lon));        shape.SetTitle("Title: " + i);        shape.SetDescription(result[i].Description);        Map.AddShape(shape);        $get("MapInfo").innerHTML += "Point Location - Lat: " +             result[i].Location.Lat + " Lon: " + result[i].Location.Lon + "<br />";    }}

     

    function MapChangedView(e){    Map.DeleteAllShapes();    MapView = Map.GetMapView();    TopLeft = MapView.TopLeftLatLong;    BottomRight = MapView.BottomRightLatLong;    GetMapData.GetPointData(10, TopLeft.Latitude, TopLeft.Longitude,        BottomRight.Latitude, BottomRight.Longitude, GetDataSuccess);}</script></asp:Content>

     

    Web Service: 

    using System;using System.Collections;using System.Collections.Generic;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Web.Script.Services; /// <summary>/// Summary description for GetMapData/// </summary>[WebService(Namespace = "http://tempuri.org/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)][ScriptService]public class GetMapData : System.Web.Services.WebService {     public GetMapData () {         //Uncomment the following line if using designed components         //InitializeComponent();     }     [WebMethod]    [GenerateScriptType(typeof(MapData))]    public MapData MapData()    {        MapData md = new MapData();        LatLon ll = new LatLon();        ll.Lat = 36;        ll.Lon = -84;        md.Center = ll;        md.ZoomLevel = 8;        return (md);    }     [WebMethod]    [GenerateScriptType(typeof(PointData))]    public PointData[] GetPointData(int PointCount,         double ULLat, double ULLon,         double LRLat, double LRLon)    {        int i = 0;        double PTLat, PTLon;        double LatDelta, LonDelta;        Random rd = new Random();        PointData pd;        LatLon ll;        List<PointData> pdl = new List<PointData>();         LatDelta = ULLat - LRLat;        LonDelta = ULLon - LRLon;         for (i = 0; i < PointCount; i++)        {            pd = new PointData();            ll = new LatLon();            ll.Lat = LRLat + LatDelta * rd.NextDouble();            ll.Lon = LRLon + LonDelta * rd.NextDouble();            pd.Location = ll;            pd.Description = "Point number: " + i.ToString();            pdl.Add(pd);        }        return (pdl.ToArray());    }} public class MapData{    public LatLon Center;    public int ZoomLevel;} public class LatLon{    public double Lat;    public double Lon;} public class PointData{    public LatLon Location;    public string Description;}

  • ASP.NET Podcast Show #110 - Integrating ASP.NET AJAX with Google Maps

    Original Url: http://aspnetpodcast.com/CS11/blogs/asp.net_podcast/archive/2008/05/01/asp-net-podcast-110-integrating-asp-net-ajax-with-google-maps.aspx

    Subscribe

    Download - WMV - PC Video.

    Download M4V - iPod Video.

    Download MP3 - Audio Only.

    ASP.NET AJAX with Google MapsShow Notes:

    • Integrate ASP.NET AJAX with Google Maps.
    • Google Key.
    • Web Services.
    • Returning Data.
    • Setting up the Map.
    • Adding points to the Map. 
    • Clearing the Map.

    Web Service Code:

    using System;using System.Collections;using System.Collections.Generic;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Web.Script.Services; /// <summary>/// Summary description for GetMapData/// </summary>[WebService(Namespace = "http://tempuri.org/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)][ScriptService]public class GetMapData : System.Web.Services.WebService {     public GetMapData () {         //Uncomment the following line if using designed components         //InitializeComponent();     }     [WebMethod]    [GenerateScriptType(typeof(MapData))]    public MapData MapData()    {        MapData md = new MapData();        LatLon ll = new LatLon();        ll.Lat = 36;        ll.Lon = -84;        md.Center = ll;        md.ZoomLevel = 8;        return (md);    }     [WebMethod]    [GenerateScriptType(typeof(PointData))]    public PointData[] GetPointData(int PointCount,         double ULLat, double ULLon,         double LRLat, double LRLon)    {        int i = 0;        double PTLat, PTLon;        double LatDelta, LonDelta;        Random rd = new Random();        PointData pd;        LatLon ll;        List<PointData> pdl = new List<PointData>();         LatDelta = ULLat - LRLat;        LonDelta = ULLon - LRLon;         for (i = 0; i < PointCount; i++)        {            pd = new PointData();            ll = new LatLon();            ll.Lat = LRLat + LatDelta * rd.NextDouble();            ll.Lon = LRLon + LonDelta * rd.NextDouble();            pd.Location = ll;            pd.Description = "Point number: " + i.ToString();            pdl.Add(pd);        }        return (pdl.ToArray());    }} public class MapData{    public LatLon Center;    public int ZoomLevel;} public class LatLon{    public double Lat;    public double Lon;} public class PointData{    public LatLon Location;    public string Description;}

    ASPX Page Code:

    <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Google_Default" Title="Google Maps Page" %><asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><div id="MapDiv" style="width:450px; height: 350px;" ></div> <br /><div id="MapInfo"></div><script language="javascript" type="text/javascript">var Map;function pageLoad(){    GetMapData.MapData(SetupMap);} function SetupMap(result){    var Lat = result.Center.Lat;    var Lon = result.Center.Lon;    var ZoomLevel = result.ZoomLevel;    var Bounds, sw, ne;    Map = new GMap($get("MapDiv"));        Map.addControl(new GSmallMapControl());    Map.addControl(new GMapTypeControl());    Map.setCenter(new GLatLng(Lat, Lon), ZoomLevel);    Bounds = Map.getBounds();    sw = Bounds.getSouthWest();    ne = Bounds.getNorthEast();    $get("MapInfo").innerHTML="SW Point: " + sw + "<br />" + "NE Point: " + ne + "<br />";    GEvent.addListener(Map, "dragend", MapMoved);    GEvent.addListener(Map, "zoomend", MapZoomed);    GetMapData.GetPointData(10, sw.lat(), ne.lng(), ne.lat(), sw.lng(), GetDataSuccess);}function MapMoved(){    var Bounds, sw, ne;    Bounds = Map.getBounds();    sw = Bounds.getSouthWest();    ne = Bounds.getNorthEast();    Map.clearOverlays();    GetMapData.GetPointData(10, sw.lat(), ne.lng(), ne.lat(), sw.lng(), GetDataSuccess);}function MapZoomed(OldZoomLevel, NewZoomLevel){    MapMoved();}function GetDataSuccess(result){    var i = 0;    $get("MapInfo").innerHTML = "";    for(i=0;i<result.length;i++)    {        var pt = new GLatLng(result[i].Location.Lat,             result[i].Location.Lon);        Map.addOverlay(DisplayPointMarker(pt, result[i].Description));        $get("MapInfo").innerHTML += "Point Location - Lat: " +             result[i].Location.Lat + " Lon: " + result[i].Location.Lon + "<br />";    }} function DisplayPointMarker(point, Description){    var gmrker = new GMarker(point);    var Message = Description    GEvent.addListener(gmrker, "click", function(){        Map.openInfoWindowHtml(point, Message);    });    return(gmrker);}</script></asp:Content> 

    MasterPage.master source code:

    <%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Google_Default" Title="Google Maps Page" %><asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><div id="MapDiv" style="width:450px; height: 350px;" ></div> <br /><div id="MapInfo"></div><script language="javascript" type="text/javascript">var Map;function pageLoad(){    GetMapData.MapData(SetupMap);} function SetupMap(result){    var Lat = result.Center.Lat;    var Lon = result.Center.Lon;    var ZoomLevel = result.ZoomLevel;    var Bounds, sw, ne;    Map = new GMap($get("MapDiv"));        Map.addControl(new GSmallMapControl());    Map.addControl(new GMapTypeControl());    Map.setCenter(new GLatLng(Lat, Lon), ZoomLevel);    Bounds = Map.getBounds();    sw = Bounds.getSouthWest();    ne = Bounds.getNorthEast();    $get("MapInfo").innerHTML="SW Point: " + sw + "<br />" + "NE Point: " + ne + "<br />";    GEvent.addListener(Map, "dragend", MapMoved);    GEvent.addListener(Map, "zoomend", MapZoomed);    GetMapData.GetPointData(10, sw.lat(), ne.lng(), ne.lat(), sw.lng(), GetDataSuccess);}function MapMoved(){    var Bounds, sw, ne;    Bounds = Map.getBounds();    sw = Bounds.getSouthWest();    ne = Bounds.getNorthEast();    Map.clearOverlays();    GetMapData.GetPointData(10, sw.lat(), ne.lng(), ne.lat(), sw.lng(), GetDataSuccess);}function MapZoomed(OldZoomLevel, NewZoomLevel){    MapMoved();}function GetDataSuccess(result){    var i = 0;    $get("MapInfo").innerHTML = "";    for(i=0;i<result.length;i++)    {        var pt = new GLatLng(result[i].Location.Lat,             result[i].Location.Lon);        Map.addOverlay(DisplayPointMarker(pt, result[i].Description));        $get("MapInfo").innerHTML += "Point Location - Lat: " +             result[i].Location.Lat + " Lon: " + result[i].Location.Lon + "<br />";    }} function DisplayPointMarker(point, Description){    var gmrker = new GMarker(point);    var Message = Description    GEvent.addListener(gmrker, "click", function(){        Map.openInfoWindowHtml(point, Message);    });    return(gmrker);}</script></asp:Content>