使用 c# odbc 在 oracle 数据库中插入记录

我在C#中乱搞，试图了解如何使用C# ODBC将记录插入数据库。我已经学会了如何将记录读入DGV，但现在我陷入了插入的困境。快速概述我的代码正在做什么，它从表中读取 20 行到DGV，然后它应该将相同的行插入到不同的表中。

我正在使用VS 2012和SQL Developer（Oracle）。

这是我的表单中的代码：

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;
namespace WindowsFormsApplication13
{
public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
    }
    private void button1_Click(object sender, EventArgs e)
    {
        for (int rows = 0; rows < 20; rows++)
        {
            dataGridView1.Rows.Add(); // adding needed amount of rows
            for (int cols = 0; cols < 13; cols++)
            {
                this.dataGridView1[cols, rows].Value = getNumberOfThreads(rows, cols);
            }
        }
        StringBuilder sql = new StringBuilder();
        sql.AppendLine("insert into chsarp_test_table");
        sql.AppendLine("SELECT *");
        sql.AppendLine("FROM legal_transactions");
        sql.AppendLine("WHERE rownum between 1 and 25");
        //using (DataTable dt = Database.GetData(sql.ToString()))
        //    if (dt.Rows.Count > 0)
        //  Database dt = new Database.SetData(sql.ToString());
        Database.SetData(sql.ToString());
    }
    public static string getNumberOfThreads(int i, int j)
    {
        StringBuilder sql = new StringBuilder();
        sql.AppendLine("SELECT *");
        sql.AppendLine("FROM legal_transactions");
        sql.AppendLine("WHERE rownum between 1 and 25");
        using (DataTable dt = Database.GetData(sql.ToString()))
            if (dt.Rows.Count > 0)
                return dt.Rows[i][j].Equals(DBNull.Value) ? "null" : dt.Rows[i][j].ToString();
        return "null";
    }
}
}

这是我类中的代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Odbc; //used for the ODBC stuff
using System.Data; // Used for public static datatable
using System.Windows.Forms;
namespace WindowsFormsApplication13
{
class Database
{
    private const string connOdbc = "dsn=atlas32;uid=NAME;pwd=XXXX";
    private const string cnnOLE = "provider =XXXX;User ID = NAME;password = XXXX; Data Source = XXX Properties=;Persist Security Info=False";
    public static DataTable GetData(string Sql)
    {
        DataTable dt = new DataTable();
        try
        {
            OdbcConnection cnn = GetConnection();
            using (OdbcDataAdapter da = new OdbcDataAdapter(Sql, cnn))
            {
                da.SelectCommand.CommandTimeout = 0;
                da.Fill(dt);
            }
            CloseConnection(cnn);
        }
        catch (Exception ex)
        {
            //Queries.LogErrors(ex.Message, Sql);
            MessageBox.Show("Error 1");
        }
        return dt;
    }
    public static void SetData(string sql)
    {
        try
        {
            OdbcConnection cnn = GetConnection();
            using (OdbcCommand cmd = new OdbcCommand(sql, cnn))
                cmd.ExecuteNonQuery();
            CloseConnection(cnn);
        }
        catch (Exception ex)
        {
            //Queries.LogErrors(ex.Message, sql);
            MessageBox.Show("Error 2");
        }
    }
    private static OdbcConnection GetConnection()
    {
        try
        {
            OdbcConnection cnn = new OdbcConnection() { ConnectionString = connOdbc };
            cnn.Open();
            return cnn;
        }
        catch (Exception ex)
        {
            //throw ex;
        }
        return null;
    }
    private static void CloseConnection(OdbcConnection Connection)
    {
        try
        {
            if (Connection.State == ConnectionState.Open)
                Connection.Close();
                Connection.Dispose();
        }
        catch (Exception ex)
        {
            //throw ex;
        }
        Connection = null;
    }
}
}

我试图逐步完成代码，但它在ExecuteNonQuery的SetData Method中下降。我试图对此进行调查，但不能介意任何对我有帮助的信息，任何朝着正确方向的推动都将不胜感激。