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>