Question: I want to get distance text from following link. i have used NSXML parsing but unable to get the result. please tell me which xml method should i used for following xml. 

<http://maps.googleapis.com/maps/api/directions/xml?origin=30.9165904,75.8634752&destination=30.89314000,75.86938000&sensor=true>

Thanks to all

Answer: 
first: Write your code on server side on Page\_load or in any other method for selecting 
record.
and for selecting record from database you can use the following code

```
string myConnectionString="server=dbserver;database=mydatabase;uid=user;pwd=password;Connect Timeout=120;pooling=true;Max Pool Size=60;";// you can place your connection string in web.config
SqlConnection con = new SqlConnection(myConnectionString);

SqlCommand cmd = con.CreateCommand();
cmd.CommandText = @"SELECT [stuff] FROM [tableOfStuff]";

con.Open();

SqlDataReader dr = null;
try
{
    dr = cmd.ExecuteReader();

    while(dr.Read())
    {
        // construct your html for your table data here
    }
}
catch(SomeTypeOfException ex){ /* handle exception */ }

```
For more control over the rendering, you can use a [ListView](http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.listview). Scroll down to the bottom of that page for an example.