retreive data from oracle and stored in mysql in c# windows

Hi Honey,

First you have get the records from oracle and need to bind the record in Datagridview.

Create the same table in mysql and loop the datagridview value and save the record in mysql.

Try this Code,

design

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using Oracle.DataAccess.Client;
using Oracle.ManagedDataAccess;
using MySql.Data.MySqlClient;
namespace CSharpCornerDemo
{
public partial class Form4 : Form
{
public Form4()
{
InitializeComponent();
}
OracleConnection Oraclecon = new OracleConnection("Your Oracle Datasource");
MySqlConnection MySqlcon = new MySqlConnection(" your MySqlDatasoure");
private void Form4_Load(object sender, EventArgs e)
{
Oraclecon.Open();
DataSet ds = new DataSet();
OracleDataAdapter sdr = new OracleDataAdapter("select * from TRAMS_M_LOOKUPTYPE", Oraclecon);
sdr.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Oraclecon.Close();
}
private void button1_Click(object sender, EventArgs e)
{
for(int i=0;i
{
string value=dataGridView1.Rows[i].Cells[0].Value.ToString();
MySqlcon.Open();
MySqlCommand insert = new MySqlCommand("insert into TRAMS_M_LOOKUPTYPE(lookupname)values('" + value + "')", MySqlcon);
insert.ExecuteNonQuery();
MySqlcon.Close();
}
}
}
}

datagridview and button in your form

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi Honey,

First you have get the records from oracle and need to bind the record in Datagridview.

Create the same table in mysql and loop the datagridview value and save the record in mysql.

Try this Code,
design
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using Oracle.DataAccess.Client;
using Oracle.ManagedDataAccess;
using MySql.Data.MySqlClient;

namespace CSharpCornerDemo
{
    public partial class Form4 : Form
    {
        public Form4()
        {
            InitializeComponent();
        }
        OracleConnection Oraclecon = new OracleConnection("Your Oracle Datasource");
        MySqlConnection MySqlcon = new MySqlConnection(" your MySqlDatasoure");
        private void Form4_Load(object sender, EventArgs e)
        {
            Oraclecon.Open();
            DataSet ds = new DataSet();
            OracleDataAdapter sdr = new OracleDataAdapter("select * from TRAMS_M_LOOKUPTYPE", Oraclecon);
            sdr.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            Oraclecon.Close();

        }

        private void button1_Click(object sender, EventArgs e)
        {
            for(int i=0;i
            {
                string value=dataGridView1.Rows[i].Cells[0].Value.ToString();
                 MySqlcon.Open();
                 MySqlCommand insert = new MySqlCommand("insert into TRAMS_M_LOOKUPTYPE(lookupname)values('" + value + "')", MySqlcon);
                 insert.ExecuteNonQuery();
                MySqlcon.Close();
            }


        }
    }
}
datagridview and button in your form