...
....
using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page
{
    SqlConnection sqlcon = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=DB2;Integrated Security=True;Pooling=False");
    protected void Page_Load(object sender, EventArgs e)
    {
        GridControl();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        String sqlins = "insert into emp_t values(@emp_name)";  
        SqlCommand sqlcmd = new SqlCommand();
        sqlcmd.Connection = sqlcon;
        sqlcmd.CommandText = sqlins;
        sqlcmd.CommandType = CommandType.Text;
        sqlcmd.Parameters.Add("@emp_name", TextBox1.Text.ToString());
        sqlcon.Open();
        sqlcmd.ExecuteNonQuery();
        sqlcon.Close();
        Response.Write("record saved");

        GridControl();
    }
    public void GridControl()
    {
        String sqlsel = "select *from emp_t";
        SqlDataAdapter sda = new SqlDataAdapter(sqlsel, sqlcon);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();

    }

}

...
.....
using System.Data.OracleClient;



public partial class _Default : System.Web.UI.Page
{
    OracleConnection oracon = new OracleConnection("Data Source=EARTH;Persist Security Info=True;User ID=rinku;Password=rinku;Unicode=True");
   
    protected void Page_Load(object sender, EventArgs e)
    {
        GridControl();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        String orains = "insert into T6 values(@name)";

        OracleCommand oracmd = new OracleCommand();
        oracmd.Connection = oracon;
        oracmd.CommandText = orains;
        oracmd.CommandType = CommandType.Text;
        oracmd.Parameters.Add("@name", TextBox1.Text.ToString());
        oracon.Open();
        oracmd.ExecuteNonQuery();
        oracon.Close();
        Response.Write("Record saved");
        GridControl();
        
    }
    public void GridControl()
    {
         String orasel="select *from T6";
         OracleDataAdapter oda = new OracleDataAdapter(orasel, oracon);
         DataTable dt = new DataTable();
         oda.Fill(dt);
         GridView1.DataSource = dt;
         GridView1.DataBind();

    }


}