How to use ASE bulk copy into c#

Question

How to use ASE Bulk Copy in c# to insert data into Sybase

I tried this code,

            AseBulkCopy f = new AseBulkCopy(con);
            f.BatchSize = 10000;

            string query;
            for(int i=0;i<10000;i++)
            {
                query = "insert into Sample3 values("+i+",'dd')";
                AseCommand cmd = new AseCommand(query,con);
                cmd.ExecuteNonQuery();
            }
            MessageBox.Show("Insertion Complete");
            con.Close();

But it take same time as general please suggest any solution I am new about that

It doesn't look like you use the `AseBulkCopy` class at all. — Aron, Apr 30 '14 at 10:23
No idea...I can't find documentation at all...but it is clear from your code you aren't calling it at all. — Aron, Apr 30 '14 at 10:49

score 0 · Answer 1 · answered Jan 05 '15 at 08:58

AseBulkCopy is used to insert rows from a C# datatable to a database table. Check the below code:

AseBulkCopy obj_AseBulkCopy = new AseBulkCopy(db_Conn);
obj_AseBulkCopy.DestinationTableName = "db_Table";
obj_AseBulkCopy.BatchSize = 1000;
db_Conn.Open();
obj_AseBulkCopy.WriteToServer(dt_DataTable);
db_Conn.Close();

Using the above code, you will be able to insert all the rows present in the dt_DataTable to db_table in the database.

How to use ASE bulk copy into c#

1 Answers1