ASP.NET

REGISTRATION.ASPX

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class registration : System.Web.UI.Page
{
    Class2 obj1 = new Class2();

    protected void Page_Load(object sender, EventArgs e)
    {
        //if (!IsPostBack)
        //{
        //    bind();
        //}


    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        obj1.exec("insert into tblregister (name,address,gender,email,fon,uname,pwd)values ('"+TextBox1.Text+"','"+TextBox2.Text+"','"+RadioButtonList1.SelectedItem.Text+"','"+TextBox3.Text+"','"+TextBox4.Text+"','"+TextBox5.Text+"','"+TextBox6.Text+"')");

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        TextBox1.Text = string.Empty;
        TextBox2.Text = string.Empty;
        TextBox3.Text = string.Empty;
        TextBox4.Text = string.Empty;
        TextBox5.Text = string.Empty;
        TextBox6.Text = string.Empty;
    }
    public void bind()
    {
        obj1.getdata("select * from tblregister");
        GridView1.DataSource = obj1.dt;
        GridView1.DataBind();
    }

    protected void Button4_Click(object sender, EventArgs e)
    {
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {

        GridView1.EditIndex = -1;
        bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string p = GridView1.DataKeys[e.RowIndex].Value.ToString();

        string name = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
        string address = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
        string phone = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text;
        string password = ((TextBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[0]).Text;

        obj1.exec("update tblregister set name='" + name + "',address='" + address + "',fon='" + phone + "',pwd='" + password + "' where id='" + p + "' ");
        bind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        bind();

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id1 = GridView1.DataKeys[e.RowIndex].Value.ToString();
        obj1.exec("delete from tblregister where id= + id1");
        bind();

    }
}






CLASS
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using MySql.Data.MySqlClient;
using System.Configuration;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
    public MySqlConnection con=new MySqlConnection(ConfigurationManager.ConnectionStrings[@"sjober"].ToString());
    public MySqlCommand cmd = new MySqlCommand();
    public DataTable dt=new DataTable();
    public MySqlDataAdapter ad=new MySqlDataAdapter();
    string s;
	public Class1()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public MySqlConnection getcon()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        else
        {
            con.Open();
        }
        return con;
    }
    public DataTable getdata(string cmdtxt)
    {
        cmd.Connection = con;
     cmd.CommandType = CommandType.Text;
     cmd.CommandText = cmdtxt;
     ad.SelectCommand = cmd;
     ad.Fill(dt);
     return dt;

    }
    public string exec(string cmdtxt)
    {
        try
        {
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = cmdtxt;
            cmd.Connection = getcon();
             s = cmd.ExecuteNonQuery().ToString();
             cmd.Connection = getcon();
             
        }
        catch (Exception ex)
        {
            ex.ToString();
        }
        return s;
    }
}
<div class="signature">JINSON JOHN</div>

<p id="results"></p>

    <script src="http://maps.google.com/maps?file=api&v=2&key=ABQIAAAA7j_Q-rshuWkc8HyFI4V2HxQYPm-xtd00hTQOC0OXpAMO40FHAxT29dNBGfxqMPq5zwdeiDSHEPL89A" type="text/javascript"></script>
<!-- According to the Google Maps API Terms of Service you are required display a Google map when using the Google Maps API. see: http://code.google.com/apis/maps/terms.html -->
    <script type="text/javascript">

    var geocoder, location1, location2;

    function initialize() {
        geocoder = new GClientGeocoder();
    }

    function showLocation() {
        geocoder.getLocations(document.forms[0].address1.value, function (response) {
            if (!response || response.Status.code != 200)
            {
                alert("Sorry, we were unable to geocode the first address");
            }
            else
            {
                location1 = {lat: response.Placemark[0].Point.coordinates[1], lon: response.Placemark[0].Point.coordinates[0], address: response.Placemark[0].address};
                geocoder.getLocations(document.forms[0].address2.value, function (response) {
                    if (!response || response.Status.code != 200)
                    {
                        alert("Sorry, we were unable to geocode the second address");
                    }
                    else
                    {
                        location2 = {lat: response.Placemark[0].Point.coordinates[1], lon: response.Placemark[0].Point.coordinates[0], address: response.Placemark[0].address};
                        calculateDistance();
                    }
                });
            }
        });
    }
    
    function calculateDistance()
    {
        try
        {
            var glatlng1 = new GLatLng(location1.lat, location1.lon);
            var glatlng2 = new GLatLng(location2.lat, location2.lon);
            var miledistance = glatlng1.distanceFrom(glatlng2, 3959).toFixed(1);

            document.getElementById('results').innerHTML = 'Address 1: ' + location1.address + '<br />Address 2: ' + location2.address + '<br />Distance: ' + miledistance + ' miles (or ' + kmdistance + ' kilometers)';
        }
        catch (error)
        {
            alert(error);
        }
    }

    </script>
  </head>

  <body onload="initialize()">

    <form action="#" onsubmit="showLocation(); return false;">
      <p>
        <input type="text" name="address1" value="Address 1" class="address_input" size="40" />
        <input type="text" name="address2" value="Address 2" class="address_input" size="40" />
        <input type="submit" name="find" value="Search" />
      </p>
    </form>
    <p id="results"></p>

  </body>
</html>

<p id="results"></p>