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

Question

retreive data from oracle and stored in mysql in c# windows application if u have any suggestion according to my question please :) :)

Ramesh Palanivel · 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

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

Answers (1)