Insert      

string scon = "Data Source=MAYANKSHARMA-PC;Initial Catalog=aman;Persist Security       Info=True;User ID=sa;password=getsetgo";
        con = new SqlConnection(scon);
        cmd = new SqlCommand("",con);
        con.Open();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("",SqlDbType.VarChar,50).Value = TextBox1.Text.Trim();
        cmd.Parameters.Add("",SqlDbType.VarChar,50).Value = TextBox2.Text.Trim();
        cmd.ExecuteNonQuery();

Fetch


string connec = "Data Source=MAYANKSHARMA-PC;Initial Catalog=aman;Persist Security Info=True;User ID=sa;password=getsetgo";
        con = new SqlConnection(connec);
        cmd = new SqlCommand("",con);
        con.Open();
        cmd.CommandType = CommandType.StoredProcedure;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();